To filter the list of possible selections in a reference variable, use a reference qualifier on the Application Services variable, not a Catalog Client Script. To incorporate the value of another variable, it would look something like this:
Where 'used_for' is the name of the field on the referenced table that contains the 'Production' or 'Non Production' value, and 'v_environment' is the name of the Catalog Item variable where that value (which must match exactly) was selected.
@Gem Edwards - Say your Environment variable is having Production and Non-Production as choices
second variable is referenced to table cmdb_ci_service_auto where you wanted to apply filter based on the variable envronment then set the referent qualifier in the Application Service as given below,
javascript: current.variables.environment == 'production' ? "environment=Production" : "environment!=Production";
above configuration filters the cmdb_ci_service_auto table values based on the environment.
