Skip to main content
M
Mr_Henry_M1-Visitor
1-Visitor
July 23, 2021
Question

Part of data from DataTable isn't displayed in the Grid

  • July 23, 2021
  • 1 reply
  • 1906 views

Hi!

 

I display the data in the Grid according to the following scheme:

Scheme.png

 

In Thing_test_6 (DataTable) data is added as follows:

Scheme_2.png

 

The problem is that in the Grid some of the data (some rows) coming from FilterServiceForEvents1 isn't displayed for some reason. But if I directly bind FilterServiceForEvents1 to the Grid then all rows are displayed.

1 reply

S
slangleyCommunity Manager
Support
July 29, 2021

Hi @Mr_Henry_M

 

We can't really tell what's going without knowing what the data looks like and the queries you're running, but we're not sure the first query in your top image is needed.  Can you provide some detail around the services that are being called?

 

Regards.

 

--Sharon

M
Mr_Henry_M1-VisitorAuthor
1-Visitor
August 2, 2021

Hi! Thanks for the answer.

 

AdoThing is a RemoteDatabase Thing. FilterServiceForEvents1 is the last one in the chain of services, starting with a service that sends an SQL-query to a data source (DB Access). Specifically FilterServiceForEvents1 is needed in order to display in the mashup only the data that corresponds to the time interval specified in the Timeselector widget. In general, I want to display the data obtained from Access in the Grid and then apply sorting (and perhaps filtering) to it.

 

To do this I use Thing_test_6 and its QueryDataTableEntries service as an intermediary. If I understand correctly this is a standard scheme with which you can accumulate data and apply sorting\filtering to it.

 

And it looks like the first query in the top image is really unnecessary. But in essence, it doesn't change anything.

S
slangleyCommunity Manager
Support
August 5, 2021

Hi @Mr_Henry_M

 

Did you check this page from the ThingWorx Help Center?

 

Regards.

 

--Sharon

Terms & ConditionsAccessibility statement