cancel
Showing results for 
Search instead for 
Did you mean: 

How to reterive the status of instance of report

Former Member
0 Kudos

iI am using java SDK i have to reetive the status of all the instances of report

That is sucess , failure , pending..etc

how can i do that.

Accepted Solutions (0)

Answers (2)

Answers (2)

Adam_Stone
Active Contributor
0 Kudos

You already have a [thread|http://forums.sdn.sap.com/thread.jspa?threadID=2130692&tstart=0] on this topic, you don't need to create another one. I am closing and locking this thread.

Former Member
0 Kudos

Hi,

You can query the CMS with the query

Select * from ci_infoobjects where si_kind='CrystalReport'/'Webi' and si_instance=1 and si_schedule_status=x

where x can be 1(success), 3(failure), 8(paused), 9(pending) and 0(running).

Regards,

Prithvi

Former Member
0 Kudos

there are many more status like recirring ..i want status that is success, failure, recurring instead of 1,2 0

Former Member
0 Kudos

Hi Amita ,

As per the APIs ,there is a method in ISchedulingInfo interface i.e. getStatus() which returns an int datatype.

So you will get status of the instance as int value only.

You can use the following code snippet

IInfoObjects infoobjects=infostore.query("select * from ci)infoobjects where si_kind='Crystalreport'/''Webi' and si_instance=1");

for(int i=1;i<infoobjects.size();i++)
{
IInfoObject infoobject=(IInfoObject) infoobjects.get(i);

ISchedulingInfo oSchedInfo=infoobject.getSchedulingInfo();

int status=oSchedInfo.getStatus();

out.println(status);
}

Regards,

Prithvi