max size 500 for DeleteDataTableEntries ?

[seanccc]

Hi,

Just found that DeleteDataTableEntries can only delete 500 entries as most , but there is no parameter to control it.  Executing the service one more time, and it will delete the next 500 entries.  Is it a correct/designed behavior ? 

Thingworx version:  8.4.4

Regards,

Sean

[vangne]

@seanccc This is a known issue. The cause of this issue is 

• FindDataTableEntries() does not currently accept a maxItems parameter, and as such defaults to a limit of 500 results returned.
• DeleteDataTableEntries() calls FindDataTableEntries() behind the scenes, and as such is subject to the same 500 result limit.

The solution to this issue has been provided in Thingworx 8.5

Thanks,

Vibhuti

[PaiChung]

There is a purge service available as well I believe. If you can define what you want to remove based on timestamp.

[seanccc]

@PaiChung ,

I need to remove by the data table's key,  not timestamp. 

Regards,

Sean

[PaiChung]

If you can't specify the maxItems parameter then the only way to do more than 500 is to do it in the persistence layer directly.