Can field token be used in validation > drop down list > SQL
I am trying to add a field to an object type that allows the user to select an environment type from a drop down list (PROD/QV/DEV). Then have another field in the object type use the result within a SQL query to return all environments that are PROD or QV or DEV. It doesnt appear this is possible. This is what I have tried:
I have a field (token = [ENV] ) in an object type that asks 'What environment do you want to delete from'. Its a drop down validation where the user selects PROD, QV, or DEV. I would like to take the result and use it within another field, which is using a validation > drop down list > SQL.
select environment_name, server_name from kenv_environments where environment_name like '(ABI)%' and user_data20='[P.ENV]'
I keep getting an error "One of the tokens in the validation was unparseable KNTA-10073). It appears you can ONLY USE tokens that are referenced from the Tokens button at the bottom of the validation. (see pic) Is there any way around this?