Help with variable type Lookup Select Box

[yltsai]

To all experts,

I have looked into the wiki and community posts about Service catalog variable type of Lookup Select Box.

I followed along with the Product Document to implement a variable, Time Zone.

But I could not get it to work.

I want to get the active time zone and I set up the Type Specifications as below.

It returns the whole list of labels from the Choice table.

I also tried many other combinations to the Lookup value field, Lookup label field(s), and Reference qual.

They returned nothing or the whole choices records.

Please advise how I fix the problem.

[BALAJI40]

not the name, i guess it is table.

Reference Qul condition:

javascript: element = time_zone^table=sys_user^inactive!=true;

[yltsai · Accepted solution]

Thank you. The query is copied from the list filter and the column Table is really 'name'.

I changed my design to make the variable as a reference and use few simple conditions to make it work.

[BALAJI40]

Happy that your issue was closed.