Skip to main content
1-Visitor
June 13, 2022
Question

How to create custom DataTable in Thingworx

  • June 13, 2022
  • 1 reply
  • 1585 views

Hi, 

There is a requirement of storing large data in data table dynamically. We are facing an indexing issue while deleting the data. Does anybody knows how to configure custom Datatable in Thingworx

1 reply

19-Tanzanite
June 13, 2022

Hi @MG_2602.,

First, I saw you mentioned "large data" in data table. You should not use a DataTable for quantities larger than 100.000 rows, as per this Help Center section.

Please note that even if you store lower numbers of rows, you might end up having issues due to the way you access the data (frequency, data size etc)

You mentioned "we are facing an indexing issue while deleting the data". What exactly is the issue?

I also do not fully understand your question about "how to configure custom Datatable in ThingWorx", because all the DataTables are defined using a custom DataShape (hence, all are custom). Have you created maybe your own Java-based DataTable implementation?

 

MG_26021-VisitorAuthor
1-Visitor
June 14, 2022

Hi @VladimirRosu_116627 ,

 

Can we use DataTable generic services like AddConfigurationTableDefinition, GetConfigurationTable.

Can you please help me out in understanding what are these configuation Table. How can we use them and any limitation?

 

Thanks,

Meghna

19-Tanzanite
June 14, 2022

The information you asked for is available in the Help Center, here.

In the future, I suggest you bookmark the ThingWorx Help Center website, and to try to use the search function there. If then you do not find the information in the Help Center, then we would be happy to help in the community.

I noticed you did not answer my questions above - is that problem solved?