Why does this Suiteql query: SELECT
Item.ID,
Item.ItemID,
Item.Description,
item.subsidiary
FROM
Item
WHERE (item.subsidiary = 7)
and ( Item.ItemType = 'Assembly' )
Give the error: Search error occurred: Invalid or unsupported search.
The error occurs when adding "WHERE (item.subsidiary = 7) "
