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?

[Priyanka_786]

Hi @Rooma1 

I believe you are using wrong condition in reference qualifier. As Location field is referenced to cmn_location table and there is no active field present OOB. You need to use customized conditions here

If my response helped you in any way, please mark helpful/accepted.

Regards,

Priyanka Salunke

[Rooma1]

Hi @Priyanka_786 

Yes, OOB no active field is present but there is a user defined field called u_active and the condition which i am using is below:

Javascript:u_active=true;

[Rooma1]

Hi @Priyanka_786 

I tried creating a dynamic reference qualifier but it is still not working. Can you please help here?

Thanks,

Rooma

[Priyanka_786]

@Rooma1 , I believe u-active field is choice type. If yes remove quotes for true value in query and try.

Could you please confirm once with this custom active field you have data in location table in system.

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

Regards,

Priyanka Salunke

[Rooma1]

@Priyanka_786 The field 'u_active' is of type - True/False. Even if I remove the quotes, it is not working.

Thanks,

Rooma