How to show only active records for a look up variable from a table?

[User206787]

Hi,

I am having a requirement to show only active locations on a service catalog. I have created a lookup selectbox and lookup table is set to location, When i make some countries inactive they shouldn't be available as a selecting option. If it were not for Service catalog i would have used a reference Qual condition. Since it is for Service catalog variable i am out of options.

Could someone be able to solve this issue ASAP, It would be really helpful.

Thanks

[Pradeep Sharma]

Hi Praveen,

You can define reference qualifier. Please refer the below thread for reference.

Reference Qualifier on Lookup Select Box Variable

[User206787]

I have looked at the above link but i am unable to get what i am looking for, I donot want to write a client script and i want it to run using reference qualifier itself. This is a table which we have pulled from google maps and updated the currency, So we do not need all the locations and want to look at only the active one'e on the form drop down.

Could you provide a test example ? I have like 4 fields only in the table and all of them are strings and one active true or false choice button.

Please suggest

[Michael Ritchie]

There is a reference qualifier field on the variable definition in the type specifications section.   It's not a simple condition builder like on table fields, but you can insert an encoded query like u_active=true in it.