How do we search for open Self declarations where declaration analyst in <inactive usergroup>
I have used the below condition and its not working for inactive usergroups. For active usergroups its working fine. Please guide.
String data="WF-AC TEST INACTIVE"; // inactive usergroup
String condition = "SELECT "
+ "[Cover Page.Declaration Number] "
+ "FROM "
+ "[Self Declarations] "
+ "WHERE "
+ "[Cover Page.Declaration Analyst] in '"
+ data
+ "' and [Cover Page.Status] not in ('$STATUSTYPE.COMPLETE' , '$STATUSTYPE.RELEASED' , '$STATUSTYPE.CANCEL') ";
IQuery queryDec = (IQuery) agileSession.createObject(
IQuery.OBJECT_TYPE, condition);
ITable tableDec = queryDec.execute();