Selecting Asset Types For Custom Service Desk Column?
So i know how to have a column with all of the Assets Types being selectable, and i know that "query:select ASSET.NAME FROM ASSET WHERE ASSET_TYPE_ID=? ORDER BY ASSET.NAME ASC", will allow me to show the given "ID=" asset type. The question is, how do you select 2 or 3 Asset Types, and not all or 1?
1 Comment
[ + ] Show comment
Answers (1)
Answer Summary:
Please log in to answer
Posted by:
grayematter
10 years ago
In your query, try changing the
ASSET_TYPE_ID=?
to either
(ASSET_TYPE_ID=2 OR ASSET_TYPE_ID=3)
or
ASSET_TYPE_ID IN (2,3,4,7,12)
Use the first if you have a small number of types. Use the second if you have a larger number of asset types.
ASSET_TYPE_ID=?
to either
(ASSET_TYPE_ID=2 OR ASSET_TYPE_ID=3)
or
ASSET_TYPE_ID IN (2,3,4,7,12)
Use the first if you have a small number of types. Use the second if you have a larger number of asset types. - grayematter 10 years ago