Populate dashboards based on selection on the onwer variable value

[akankshak15]

I am creating a scenario where I have to populate dashboards based on the selection of owner variable (reference to user table) value on catalog item.

I have written the script working on the background script but I am not getting how to call this script include at the reference qualifier Can someone help me with this? 

[akankshak15]

yes

[Nilesh Wahule · Accepted solution]

@akankshak15  - Use case has some exceptions as one dashboard owner can have multiple dashboards assigned.

However you can adjust that change later in the script includes. 

1. You need to have a on change client script on the Dashboard owner field which will call a script include where you will pass user sys id and return the dashboards sys id.

2. In script include you need to query pa_dashbords table putting query for the owner and return the sys id. 

3. After receiving the sys id in the client script just use the form set value to set the value for dashboard variable using g_form.setValue()

Let me know if any concerns 

---------------------------------------------------------------------------------------------------

Please mark my answer as helpful/correct if it resolves your query.

Thanks,
Nilesh Wahule

---------------------------------------------------------------------------------------------------

[Nilesh Wahule]

Hi @akankshak15 ,

Hope you are doing well !!

Did my reply answer your question?

If my response helped, please mark it correct/helpful  and close the thread so that it benefits future readers.

---------------------------------------------------------------------------------------------------

Thanks,
Nilesh Wahule

---------------------------------------------------------------------------------------------------