Skip to main content
Feb 10, 2022 1:36 PM UTC
Solved

How to use time picker to show data in grid table

Hello all,

 

I want to show data of a particular date which date-time picker picked into a grid table. I have data in infotable and DateTime data is in "YYYY-MM-DD" format. How can I do this?

I am new to thingworx. I really appreciate it If you can provide the solution in steps. 

 

Thanks and Regards.

PaiChungAnswer
Feb 10, 2022 1:43 PM UTC

I recommend you check out the courses available in PTCU.com, the ThingWorx foundation series.

Essentially, time picker will select a date, that has to go into a server that is mapped into your mashup that takes the parameter and returns the 'filtered' data.

That data is then mapped to your grid.

Looks like biggest thing you are missing right now is a service to take the date and filter your data. (Also don't forget the DataShape)

3 replies

PaiChungAnswer
Feb 10, 2022 1:43 PM UTC

I recommend you check out the courses available in PTCU.com, the ThingWorx foundation series.

Essentially, time picker will select a date, that has to go into a server that is mapped into your mashup that takes the parameter and returns the 'filtered' data.

That data is then mapped to your grid.

Looks like biggest thing you are missing right now is a service to take the date and filter your data. (Also don't forget the DataShape)

Feb 11, 2022 8:25 AM UTC

Hello,

 

Thank you for your response. Now I am able to display filtered data from an infotable to grid. But I wanted to filter my data according to Date only not Time so that all the data of some particular date I selected from the DateTime picker widget should be display in grid. 

Feb 11, 2022 8:55 AM UTC

I have solved my query by using between filter. 

 

Thanks.