Skip to main content
seanccc17-Peridot
17-Peridot
November 17, 2019
Question

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

vangne16-Pearl
16-Pearl
November 18, 2019

@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

 

Translate
PaiChung22-Sapphire I
22-Sapphire I
November 18, 2019

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

Translate
seanccc17-PeridotAuthor
17-Peridot
November 20, 2019

@PaiChung ,

 

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

 

Regards,

Sean

Translate
PaiChung22-Sapphire I
22-Sapphire I
November 20, 2019

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.

Translate
Terms & ConditionsAccessibility statement