Dictionary Override

[Rooma1]

Hi All,

I have a requirement- 'On the incident form, users should only be able to select active locations, however, they should be able to change the filter to all locations if they need to actually select an inactive location.'

I have configure the dictionary override on incident table for Location field and added the reference qualifier as 'active=true'; Even though users are able to see the all the locations including the inactive locations as well.

Also, they should have an option to change the filter to select the inactive locations if they need. How can we fulfill the requirement?

[Jagadish Sanadi]

Can you show me variable type of active

[Rooma1]

Hi @Jagadish Sanadi Please find the Screenshot

[Jagadish Sanadi]

var gr = new GlideRecord("cmn_location");
gr.addQuery('u_active',true);
gr.query();
if(gr.next())
{
gs.print(gr.name);

}

 Please mark helpful/accepted of it helps.

[Srikanth Buddep]

@Rooma1

Try javascript:'u_active=true' in the reference qualifier.

Regards,

Srikanth B

[Priyanka_786]

@Rooma1 : Script and configuration looks fine now. Are you sure that data with this condition present in system?

Copy this script and test in background script. Debug it by putting logs.

I suspect it'data issue. It's simple condition by putting in dictionary override in reference qualifier should work, no need to create dynamic filter option unless there are any restrictions as per my understanding

Hope it helps. Kindly mark helpful/accepted of it helps.

Regards,

Priyanka Salunke