Can I use a Select query for Asset values like a ticket?
I would like to use a select query to provide the values of a single select custom field in an asset. I don't want to link to another asset, just use the values in an asset table as options.
The following statement query:select ASSET.NAME FROM ASSET WHERE ASSET_TYPE_ID=1 ORDER BY ASSET.NAME ASC
works fine to populate the values of a custom field dropdown in a ticket, but the same string is taken literally in an asset field.
Is there a way to make this work?