Deleting a Report When there are 2 with the same Index Criteria

[rstockton]

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

[jeffs42885]

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.

[rstockton]

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

[Justin Derrick]

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.

[jeffs42885]

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.