Getting the data table values based on time inputs

[bkanipakam-2]

Hello all,

I am using datatables to store the values of the alerts generated by a machine. I am able to retrieve the data based on the time filters in the thingworx composer using the QueryDataTableEntries. I have added a filter to get the data for particular time span and I have tested.  I can see the whole table using the following rest call and even implemented the filters in mashups as well to get data related to particular time entries using Time Selector widget. I am able to get whole table data using the rest call and get Json payload as result using the postman application in chrome

Now is it possible handle this to & from date entries using the REST call?

http://<IP>:8080/Thingworx/Things/<AlertLogs/Services/time_input?method=post​

Say, Can i get the data from june,1 2017 to june,15 2017 using the REST call?

Please suggest.

Regards,

Yogesh

[CRArko]

Hello, Yogesh.

A couple of suggestions:

You should use streams not data tables, you can pass any parameters into a REST call.

Dates are passed using the base javascript format (milliseconds from epoch).

Here is a pointer to how these entities are best used:

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS204091

Is this feasible for your use case?

Thanks,

-- Craig A.