How to use time picker to show data in grid table

[PS_10076728]

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.

[PaiChung · Accepted solution]

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)

[PS_10076728]

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. 

[PS_10076728]

I have solved my query by using between filter. 

Thanks.