OnDemand User Group

Support Forums => MP Server => Topic started by: rstockton on July 13, 2012, 08:48:46 AM

Title: Deleting a Report When there are 2 with the same Index Criteria
Post by: rstockton on July 13, 2012, 08:48:46 AM

How can I selectively delete a report from CMOD when there are 2 with the same Index criteria?  We are on release 8.4.1.2 of CMOD.

Thanks,

Russell

Title: Re: Deleting a Report When there are 2 with the same Index Criteria
Post by: jeffs42885 on July 13, 2012, 10:20:28 AM

I usually go into the thick client , retrieve the hitlist and then right click on the hit to get the partial load ID, then using that I get the full load ID and then do

arsadmin unload -harchive -uuser -ppassword -gappgroup -LLOADID -Q

Not sure if this helps but it's what I do for deleting single reports, or whole batches.

Title: Re: Deleting a Report When there are 2 with the same Index Criteria
Post by: rstockton on July 13, 2012, 01:34:57 PM

Thanks, but I don't think this will work as we load documents in batches it will delete every document in the batch, since they are all loaded with the same loadid.

Russell

Title: Re: Deleting a Report When there are 2 with the same Index Criteria
Post by: Justin Derrick on July 15, 2012, 05:16:49 AM

You can use the object ID (ie, 1234FAAZ - from your partial LoadID) as part of the SQL identifying your object in the arsdoc command -- like "report_date = 12345 and cust_num = 987654321 and doc_name = '1234FAAZ' "

-JD.

Title: Re: Deleting a Report When there are 2 with the same Index Criteria
Post by: jeffs42885 on July 15, 2012, 02:14:27 PM

Quote from: Justin Derrick on July 15, 2012, 05:16:49 AM

You can use the object ID (ie, 1234FAAZ - from your partial LoadID) as part of the SQL identifying your object in the arsdoc command -- like "report_date = 12345 and cust_num = 987654321 and doc_name = '1234FAAZ' "

-JD.

This will be very useful. Thanks for the tip JD.