OnDemand User Group

Support Forums => MP Server => Topic started by: Joe Wolken on October 14, 2021, 08:44:03 AM

Title: ARSDOC Delete Processed more records that listed in the Named Query
Post by: Joe Wolken on October 14, 2021, 08:44:03 AM

I used the OnDemand v.10.5 64bit client to create a Public Named query that used 3 index fields to create the hit-list of items I wanted to delete using the ARSDOC Delete API.  The 3 fields included:
- Job Number (user defined string field)
- Job Date (user defined date field)
- Data Type (OnDemand Application field (eg. PDF, AFP, SCS, TIF, etc..)

I needed to use Data Type to make the search unique to the items I wanted to delete.

My OnDemand returned just the 3 TIFF files I wanted to delete.

I ran the ARSDOC Delete API using -q QUERYNAME parameter

It deleted the 3 files PLUS all other Data Types that also matched the Job Number and Job Date parameters.  In this case is was 20 records.

I assume the difference is that DataType is an Application field and not a userdefined index field.  This seems WRONG.  It seems to me that if defining a Named Query to use in ARSDOC Delete, it should exactly process the records found with the Named Query.

This happened on iSeries Server running server v.10.5.

Has anyone experienced the same? 

Joe