Skip to main content
12-Amethyst
Jul 23, 2025 4:23 PM UTC
Solved

Chip Based Filter on SQL Infotable

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

18-Opal
Jul 30, 2025 6:34 PM UTC
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

6 replies

18-Opal
Jul 28, 2025 8:33 AM UTC

Hello,

 

You can call Resources["InfoTableFunctions"].Query() directly from your mashup, no need to wrap it in a custom service.

 

/ Constantine

Translate
12-Amethyst
Jul 28, 2025 3:17 PM UTC

Is there a more detailed description for this? I've never executed such calls directly from the MashUp before.

Translate
18-Opal
Jul 29, 2025 10:20 AM UTC

Here, I threw together a quick example -- take a look at the attached file:

 

Constantine_0-1753784380520.png

 

Translate