Skip to main content
P
PS_100767281-Visitor
1-Visitor
February 10, 2022
Solved

How to use time picker to show data in grid table

  • February 10, 2022
  • 1 reply
  • 1982 views

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.

Best answer by PaiChung

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)

1 reply

P
PaiChung22-Sapphire IAnswer
22-Sapphire I
February 10, 2022

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)

P
PS_100767281-VisitorAuthor
1-Visitor
February 11, 2022

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. 

P
PS_100767281-VisitorAuthor
1-Visitor
February 11, 2022

I have solved my query by using between filter. 

 

Thanks.

Terms & ConditionsAccessibility statement