Dashboard Defaults not taken over

Moderator: crythias

Post Reply
hkais
Znuny expert
Posts: 287
Joined: 16 Apr 2016, 08:55
Znuny Version: see in post
Real Name: Hans
Contact:

Dashboard Defaults not taken over

Post by hkais »

znuny 7.0.11

changed the default columns from (1: available) to (2: enabled by default) but the columns are not showing for existing users.
This is the case for new and open tickets.

How can I drop the users configured columns and to take over the configured defaults?

From develepment perspective, in which table are the users column settings stored?
Elected 2022-06 as an IT Governance Portal Expert. The portal for Znuny, OTRS and OTOBO users
skullz
Znuny superhero
Posts: 624
Joined: 24 Feb 2012, 03:58
Znuny Version: LTS and Features
Real Name: Mo Azfar
Location: Kuala Lumpur, MY
Contact:

Re: Dashboard Defaults not taken over

Post by skullz »

Its stored under each of user_preferences table.

Code: Select all

SELECT * FROM user_preferences where preferences_key LIKE 'UserDashboardPref%'
https://doc.znuny.org/legacy/api/otrs/6 ... references
hkais
Znuny expert
Posts: 287
Joined: 16 Apr 2016, 08:55
Znuny Version: see in post
Real Name: Hans
Contact:

Re: Dashboard Defaults not taken over

Post by hkais »

thank you!

Is any path available to reset the users dashboard without messing around in the database?
Would require to reset the users dashboards which I changed to have some default columns.
Asking to enable powerUsers to do so, and do not wnat to give them access to DB
Elected 2022-06 as an IT Governance Portal Expert. The portal for Znuny, OTRS and OTOBO users
skullz
Znuny superhero
Posts: 624
Joined: 24 Feb 2012, 03:58
Znuny Version: LTS and Features
Real Name: Mo Azfar
Location: Kuala Lumpur, MY
Contact:

Re: Dashboard Defaults not taken over

Post by skullz »

no that im aware of..perhaps others users can help..

Build user preferences field based on the dashboard type.
Admin than update the correct value from Admin > Agent > Select Agent > User Preferences> Miscellaneous

This post may help
viewtopic.php?t=19936

Code: Select all

PrefKey => UserDashboardPref0130-TicketOpen-Columns
Data => [% Env("UserDashboardPref0130-TicketOpen-Columns") %]

PrefKey => UserDashboardPref0120-TicketNew-Columns
Data => [% Env("UserDashboardPref0120-TicketNew-Columns") %]
Post Reply