Skip to Content
0
Former Member
Jul 01, 2009 at 02:16 PM

Deleting scheduled document instance

30 Views

Hi! I need to schedule an instance of Webi document and delete it in case if shcedule time is greater than predefined value or instance failed. Now the main problem is how to get last instance ID

I'm trying to do the following


String sql = "select * from CI_INFOOBJECTS where SI_KIND='"
			+ CeKind.WEBI + "' and SI_ID="; + InfoObject().getID();  
     
IInfoStore.schedule(  InfoStore.getUnderlying().query(sql)   );

String newInstanceRef = infoObject.properties().getProperty("SI_NEW_JOB_ID").getValue().toString();

last string cause NullPointerEx because there are no such property.. may be I'm going the wrong way and It is possible to schedule document and get new instance ID with any other way?

Thanks

Oleg