Agile (MOSC)

MOSC Banner

How do we search for open Self declarations where declaration analyst in <inactive usergroup>

in Agile (MOSC) 1 commentAnswered

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();

      

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center