Chip Based Filter on SQL Infotable

Forum|Forum|8 months ago
July 23, 2025
1 reply
874 views

I would like to filter the InfoTable returned by a SQL query using a ChipBasedFilter widget and return it directly to an Advanced Grid.

Is there a way to achieve this without creating an intermediate service? I have several mashups with very different requirements and would rather not write a separate service for each one.

Thingworx V9.2

Best answer by Constantine

Well, I guess you can’t have it all that easily… Better wrap your SQL service in a JavaScript one, which accepts a query parameter and uses that InfoTableFunctions resource internally.

This solution will likely be more secure, too, as you’ll be able to control who can pass what parameters to your SQL query.

What I’m trying to say is in a real production application you’ll wrap 90% of your SQL services anyway.

/ Constantine