Chip Based Filter on SQL Infotable

[Pi_Baettgen]

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

[Constantine]

Hello,

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

/ Constantine

[Pi_Baettgen]

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

[Constantine]

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

[Pi_Baettgen]

Basically, it works. However, it doesn't recognize the underlying DataShape. This could be because the service that returns the data is SQL-based.

[Constantine · Accepted solution]

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

[Pi_Baettgen]

I did it with a wraped Service now

Thanks for your help.