Pre-filter slushbucket

tillu
Giga Expert

I would like to have a slushbucket filtered automatically. For example, the slushbucket must display the users of a given company. I would like to have it filtered automatically and not manually supplied.

10 REPLIES 10

Thanks Mike, but I need the filter to be dynamic, not preset.


You can use javascript in this:



find_real_file.png


Hi Mike, the javascript is not working. What I need is a filter based on the company as set in the problem record. What I did is I tried creating a script include which returns a list of sys_ids for incidents. The script include is based on a filter having state and the company. Still it is not working.


I actually did find a way how to filter the slushbucket based on filters we required. By editing the UI Action "Edit..." (Many to Many). Added the following lines:



uri.set('jvar_no_filter', 'true');   - to remove any filters (only if needed)



uri.set('sysparm_query', 'company=' + parent.company);     -   added filter based on the company field in the record


Had a similar requirement, ended up following this advice, thank you.



I did create a UI Action for my table, added the uri.set('','') statements as needed and voila! problem fixed!



M