cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

max size 500 for DeleteDataTableEntries ?

seanccc
17-Peridot

max size 500 for DeleteDataTableEntries ?

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

4 REPLIES 4
vangne
16-Pearl
(To:seanccc)

@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
21-Topaz II
(To:seanccc)

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

seanccc
17-Peridot
(To:PaiChung)

@PaiChung ,

 

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

 

Regards,

Sean

PaiChung
21-Topaz II
(To:seanccc)

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.

Announcements