Query for finding the number of reports in a users inbox

sdk development
1

Hi,

I used the following query in my query builder to return me the number of reports in a users inbox

IInfoObjects reportsCount = iInfoStore.query(“SELECT SI_CHILDREN FROM CI_INFOOBJECTS WHERE SI_KIND=‘Inbox’ AND SI_NAME=’”+userId +"’");

But when i use reportsCount.getSize() in java it gives me 1 but i need the no of reports in the inbox for example 25 as the output.

Experts please help me know the query I should use for this and how to program it in java.

Thanking you,
Madhura.

Madhura_J (BOB member since 2011-07-11)