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

max size 500 for DeleteDataTableEntries ?

  • November 17, 2019
  • 4 replies
  • 1235 views

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

V
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

 

P
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.

S
seanccc17-PeridotAuthor
17-Peridot
November 20, 2019

@PaiChung ,

 

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

 

Regards,

Sean

P
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.

Terms & ConditionsAccessibility statement