Deleting documents in specific load using search

[jplumey]

Hi guys,

My customer has identified a load that contains documents that need to be deleted based on the value of a field. ARSDOC DELETE lets you search for documents but I don't know if there is syntax that lets you specify the particular load. Searching on the field will not work since they do not have unique identifiers anywhere and unless they specify the specific load, they will delete too many documents.

Is there any way of using arsdoc delete with a specific load?

[jplumey]

Ok I found the -X parameter. I'll have to test and see if it works with the delete function.

[Justin Derrick]

Hi.

You can use SQL to specify a portion of the load ID.  If you get a load ID that includes an object ID of 1234FAA, then you can include it in your SQL selection criteria (along with, say, customer number) like this:
  doc_name like '1234FAA%' and cust_num = 987654321

I know that sounds brief and cryptic, but it's a push in the right direction.  Let us know if you have more questions.

[jplumey]

Oh that's a good idea, too. I'll give that a shot.