Reference Qualifier vs auto-populate filtering

[martinkruml]

Hello,

I have this by the look, very simple business requirement, but I do struggle with it.

For one of the catalog item, there's a requirement to show in field "Organization" only those departments, which have parent = empty and code!=obsolete (modified field). However, this filtering is working, except that this variable in the catalog item is still showing "auto-populated" value from settings of the variable (dot walk of department from sys_user table). 

So even if the reference qualifier "pass" these values, it always show auto-populated value whether it is obsolete or not. 

Can you help me, if I can somehow setup it differently via catalog client scripts/different settings in variable in order to show correct list of valid departments? Auto-populated settings should be still in place.

Currently as it is, field is not auto-populated but it shows all valid fields as list (from Lookup select box).

Thanks in advance

[Vasantharajan N]

@martinkruml - If it auto-populate the value then check the default value setting of the variable and make the necessary changes as per your requirement. 

[martinkruml]

Hi,

Default Value is empty, or did you mean that I should write some clearing script there?

[Ankur Bawiskar]

@martinkruml 

share your variable config screenshots and script screenshots.

are you auto populating that variable via some script and reference qualifier is also present?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[martinkruml]

Hi,

This is how it is setup - which is not working - field is getting auto-populated with obsolete department.