Lookup select box variable not populating choices correctly in UI Policy conditions.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-30-2023 06:52 AM
Hi All,
I have a lookup select box variable "sub_category" that populates choice values based on the request type. These combinations of the request type and sub categories associated with it are available in a custom table to which the lookup select box is referencing to.
This is working as expected and populating the choice values correctly in the service portal catalog item. But when I try to use the "sub category" field to set the conditions in the catalog UI policy, it is displaying some random numerical values and not displaying the choice list as expected. I need to display different other variables based on the sub category selection for which I am trying to create the UI policies, but not able to set the condition as the sub categories are not populating correctly.
Can you please help me in achieving this requirement. Thanks in advance.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-30-2023 07:20 AM
Portal View:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-30-2023 07:25 AM
@ReshmithaK then the numbers starting with '000... is coming from which field on your custom table ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-30-2023 07:30 AM - edited 08-30-2023 07:34 AM
They are coming from the 'string 3' field only. But they are the values that are not related to the conditions specified i.e. they have different index 2 and string 6 values. (these are the conditional fields mentioned in the reference qualifier)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-30-2023 08:52 AM
@ReshmithaK can you apply the same query using filter option in teh list view of your table and see if you are getting correct set of list ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-30-2023 09:10 AM
Yes, If I put the query that way then I am able to get the correct choice values in UI policy too but a part of my required query cannot be put in the filter condition directly as it is dynamic.
javascript:'u_index_2=d46d1eae1bff51d06678639ce54bcb5e^u_string_6='+current.variables.request_type
Here the sub categories needs to be fetched based on the request type (stored in string 6 field).