Clean personal folders for only specific groups BI 4.2

[system]

Dear,

I want to clean up some reports on personal folders only for specific BI 4.2 groups with the “cleaning” application. But unfortunately, I can not delete reports for only users of a BI group with the Cleanup tool:

Bulk Delete User Documents

This tool is born from our necessity to cleanup user documents that are older than a period of time. Gives you the convenience to delete the Personal/Inbox documents of all the users in a single shot, that are older than a cut off date. It is a JSP version and uses BO XI3.1 SDK. You have to deploy on your Java web/application server. It Prompts you for a)CMS name b)Admin Credentials. c)Inbox or Favorites Documents d)A cut off date and the documents prior to that date will be displayed C…

This tool cleans user documents that are older than a period of time. Delete the Personal / Inbox documents from all users at one time.

delete.jsp

…

String collectInbox(IInfoStore iStore, String cd, String dt) throws SDKException
{

String query = "SELECT SI_ID, SI_NAME, SI_DESCRIPTION " +"FROM CI_INFOOBJECTS " + “WHERE SI_KIND =” + “’” + dt + “’” +“ORDER BY SI_NAME”;

IInfoObjects oInfoObjects = iStore.query(query);

for (int x = 0; x < oInfoObjects.size(); x++)
{
IInfoObject oInfoObjectInbox = (IInfoObject)oInfoObjects.get(x);
int id1 = oInfoObjectInbox.getID();
String id =Integer.toString(id1);
deleteDoc(id, iStore,cd);

}

return “Documents deleted”;

}

How can i change the query by selecting only members of the group ‘XX_Creator’ :

SELECT SI_ID, SI_NAME FROM CI_SYSTEMOBJECTS WHERE DESCENDANTS(“SI_NAME=‘USERGROUP-USER’”, “SI_NAME=‘XX_Creator’”) AND SI_KIND=‘USER’

Thank you very much for your assistance in this matter
Fethi
cleanup.zip (21.0 KB)

---

Fethi (BOB member since 2018-05-17)