nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How can a give a dynamic default value to a selection widget

jar

Hello,
 
I am working on a dashboard with a selection widget (combo-box) that is based on a query with Row Level Security in a .DATA file that is weekly refreshed. In this selection widget only the client are shown for which the logged in user has authorization. For almost every end-user there are different clients. 
 
On the dashboard we have a report that needs a parameter (p_client) to show only the data of the client(s) the logged in user has authorization for.
 
I can give a default value in the selection widget but because every user has different clients this would result in an empty page for a lot of users.I would like the selection widget to always select the first value from it's list that is filled by the query in the .DATA file so the user is always presented a report with the option to select another client. 
 
I can not see a way to realize this... If somebody can give me a pointer in the right direction this would be great. 
 
Kind regards,
Jeroen

Find more posts tagged with

Comments

jar

bump ...

jar

Mmhhhh ... apparently quit a unusual "Way We Work". 
 
Been looking for a solution for this for some time now but unfortunately have not been able te fix this. As most of the users have one client on 20+ reports they have to select the same client every time again... 
 
$("#0").val($("#0 option:first").val()); using jQuery seems like a soluction but for me I could not get it to work on a dashboard although the first prompt seems to have the id 0...