AnsweredAssumed Answered

What is the logic between items of ParamsGetMObjects.mObjCriteriaList?

Question asked by a3e8dd2974d7d639dea937a27a8fcb3894b7b310 on Jan 6, 2014
Latest reply on Jan 28, 2014 by f98e3c1e00fe3acd84761f9782b6aa61b0b04101
Hi all,

When creating 2 or more items to ParamsGetMObjects.mObjCriteriaList, what is the logical relation between the criteria? Someone told me that 'When you supply multiple Ids, we OR them.  It is an AND when other criteria are supplied' before.

But when my list contains 2 items
with the same field name, it doesn't work. E.G. 'Id > 3' and 'Id < 8'.
I want to get the records with Id 4, 5, 6,and 7, but the results also contain 1, 2, and 3. When I set 'Id > 3' after 'Id < 8' in the list, the results contain all records 'Id > 3', and many have a Id greater than 8.

When my filter is 'Id = 3 and Id = 8', in the logic above it means two records would be returned with Id 3 and 8, and in SQL Server logic it means nothing. But when I call API getMObjects(), I get record only Id = 8.

Is there anything I miss?

Best Regards,
Biao

Outcomes