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?
Answer Summary:
Cancel
1 Comment   [ + ] Show Comment

Comments

  • 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.
Please log in to comment

Answers

2
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.
Answered 11/07/2014 by: grayematter
Fourth Degree Black Belt

Please log in to comment
Answer this question or Comment on this question for clarity

Share