Skip to main content
I
iguerra16-Pearl
16-Pearl
May 21, 2025
Solved

Use queryfilter on a ptcsgrid

  • May 21, 2025
  • 1 reply
  • 425 views

Using thingworx 9.6

I have infotable data shown on a ptcsgrid

I want to apply a "static" filter to hide some rows based on a value (NOTLIKE), and I would use the queryfilter  parameter.

Note that I don't want to filter at service level when generating infotable data because in other objects I need to have all the rows.


I may leave on the ptcsgrid the "filter box" visible on the mashup to filter the visible data, but this should work  after the queryfilter, just on the visible rows

Is there a way to apply a static  queryfilter , not using for example a ptcschipdatafilter ?
I tried with an expression with output type queruyfilter, but it's not clear how to "code" the filter

Best answer by Rocko

I don't think that's possible. The queryFilter to my knowledge is not applied on client side, but on server side when executing the service that acquires that, as shown in the example.

Also, it would be weird if you show the full data elsewhere on the same mashup, it would break the SelectedRow behaviour IMO.

You can route the full set to a second service and in that service apply the queryfilter on the infotable, I don't see an option to do that clientside only.

1 reply

Rocko
Rocko19-TanzaniteAnswer
19-Tanzanite
May 21, 2025

I don't think that's possible. The queryFilter to my knowledge is not applied on client side, but on server side when executing the service that acquires that, as shown in the example.

Also, it would be weird if you show the full data elsewhere on the same mashup, it would break the SelectedRow behaviour IMO.

You can route the full set to a second service and in that service apply the queryfilter on the infotable, I don't see an option to do that clientside only.

Terms & ConditionsCookie settingsAccessibility statement