Does Castor support the SQL IN expression?
Yes. However, the full expression is a bit different using the LIST keyword. The following example provides a demonstration: SELECT p FROM Product p WHERE p.id IN LIST ( 123, 456, 789 ) If identifiers other than numbers are used, those identifiers must be quoted: SELECT p FROM Product p WHERE p.name IN LIST ( “abc”, “jkl”, “xyz” ) To include NULL values in the ‘IN’ list, use the ‘nil’ keyword: SELECT p FROM Product p WHERE p.name IN LIST( “ABC”, nil ) It is even possible to include bind values in the ‘IN’ lists using the following syntax: SELECT p FROM Product p WHERE p.
