An SUPAttributeTest defines a filter condition using an MBO attribute, and supports multiple conditions.
SELECT * from A where id in [1,2,3]
SUPQuery *query = [SUPQuery getInstance]; SUPAttributeTest *test = [SUPAttributeTest getInstance]; test.attribute = @"id"; SUPObjectList *v = [SUPObjectList getInstance]; [v add:@"1"]; [v add:@"2"]; [v add:@"3"]; test.testValue = v; test.operator = SUPAttributeTest_IN; [query where:test];
SELECT a.id from AllType a where exists (select b.id from AllType b where b.id = a.id)