- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-18-2022 04:20 AM
Hi All,
I want to limit the visibility of Location Entries in incident form.
As of now we have 10000 Locations out of which I want to show 4 Locations in Location search
Can anyone let me know how to configure this?
Regards,
Nagesh
Solved! Go to Solution.
- Labels:
-
Scripting and Coding
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-18-2022 04:30 AM
Hi,
This is very easily achieved by configuring a 'Reference Qualifier' which essentially filters the data as you require.
In the below example I've filtered by Locations in the 'New York' area, however you can filter this based on whatever criteria the 4 locations you wish to display meet.
Simply right click against the Location field and select 'Configure dictionary' and update the 'Reference qual condition' accordingly.
Please note, this will apply across the whole platform wherever the Location field is used. Best practise is advised so as to only apply to the Incident table for example using Dictionary override.
See second screen shot for the same change but only applied to the incident table.
To help others, please mark correct and/or helpful
Thanks,
Robbie
Dictionary override and best practice:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-18-2022 04:30 AM
Hi,
This is very easily achieved by configuring a 'Reference Qualifier' which essentially filters the data as you require.
In the below example I've filtered by Locations in the 'New York' area, however you can filter this based on whatever criteria the 4 locations you wish to display meet.
Simply right click against the Location field and select 'Configure dictionary' and update the 'Reference qual condition' accordingly.
Please note, this will apply across the whole platform wherever the Location field is used. Best practise is advised so as to only apply to the Incident table for example using Dictionary override.
See second screen shot for the same change but only applied to the incident table.
To help others, please mark correct and/or helpful
Thanks,
Robbie
Dictionary override and best practice:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-18-2022 08:33 AM
Hi,
Thanks for your reply, but it will impact globally right, i will give more details about my use case.
We have one custom filed(choice list, refer below snap)in incident form when user select choice(highlighted in yellow) that time only location restriction should work, so kindly help me how to achieve this?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-18-2022 09:12 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-18-2022 09:19 AM
Hi Nagesh,
Good pickup re the platform wide affect.
To filter the location from another field on the form, this too can easily be achieved by the Reference qualifier. (Advanced Reference Qualifier)
To ensure it only applies against the Incident table, create a Dictionary override against the Location field for the Incident table.
As the Location field is a reference field and the controlling drop down is essentially a string, you'll have to call a ScriptInclude to handle this and pass in the dropdown value in order to return the correct Location.
The reference qualifier should look something like this:
javascript: new YourScriptIncludeName().getYourMethodName(current.dropDownFieldName)
To help others, please mark correct and/or helpful.
Thanks,
Robbie