KACE Product Support

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?