Hello everyone,
I have filtered out some employee IDs and stored them in an array. Now, I need to use QueryBuildRange to filter the records in PurchReqTable based on this employee array.
Just like this:
SELECT * FROM PurchReqTable WHERE PurchReqTable.Originator IN employeeArray
But I don’t know how to use “IN” operator in QueryBuildRange.
I once tried using the select statement to test:
while select purchReqTable where purchReqTable.Originator in employeeArray
{
Info(purchReqTable.PurchReqId);
}
But I received an error: Types ‘int64(PurchReqPreparerRefRecId)’ and ‘Array’ are not compatible with operator ‘in’.
So, can I use the ‘IN’ operator in QueryBuildRange? If possible, how should I use it.
Any suggestions would be appreciated.