QuerySpec that returns multiple WTPartMaster based on Number and Organization name
Need help with defining a QuerySpec. In pure SQL I would define it as.
select * from WTPARTMASTER PM JOIN WTORGANIZATION O ON O.IDA2A2 = PM.IDA3ORGANIZATIONREFERENCE WHERE concat(PM.WTPARTNUMBER, O.NAME) IN ('0000000081Demo Organization','0000000081Other Organization'.......);
I need to be able to search for hundreds of parts in one go, that's why I use the WHERE IN. (ArrayExpression in the QuerySpec) And since I need both the Number and the Org name I concat them, otherwise I cannot use the IN clause.