Hi All,
I think I need to use a script include in reference qualifier field on the catalog variable of a lookup select box.
We don't have any catalog variables to date that have done that, so I'm not sure the syntax in the script include and the ref qualifier field to return the results below. It's almost like I need an if/then/else in the ref qualifier field but I know I cannot do that.
I have a catalog variable where the user will select an “Environment” which could be Prod, test, uat, sand, play, other.
I have another Lookup Select Box variable called “Size” that pulls from the “Size” table with 2 columns “Desc” and “Env”. I want to use a reference qualifier on this menu to…
Only return to the "Size" variable's menu the 2 “Desc” records where “Env=prod” if the Environment variable selected in the field above was “Prod” else return all 4 "Desc" into the "Size" variables's menu options.
Desc Env
Large prod
Medium prod
Small non-prod
Tiny non-prod
