cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Filter widget connected to jdbc mysql connection doesn´t work

SOLVED
horphi
Visitor

Filter widget connected to jdbc mysql connection doesn´t work

Hello,

 

i want to use the filter widget within a mashup, to filter a GRID coming from JDBC MySQL connection?

Does this should work?

 

thwx_filterwidget.PNGthwx_mashup_filter_connection.PNGthwx_quuppa_service_GetAFKO.PNG

 

Many thx in advance,

 

Philipp

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Filter widget connected to jdbc mysql connection doesn´t work

The Widget produces a JSON which you then would have to convert into a proper SQL Filter

You can then use << >> (String vs. Parameter substitution) in an SQL query.

Do be aware that using << >> is considered String substitution and is vulnerable to sql injection.

Proper validation and permissions should be used.

View solution in original post

1 REPLY 1

Re: Filter widget connected to jdbc mysql connection doesn´t work

The Widget produces a JSON which you then would have to convert into a proper SQL Filter

You can then use << >> (String vs. Parameter substitution) in an SQL query.

Do be aware that using << >> is considered String substitution and is vulnerable to sql injection.

Proper validation and permissions should be used.

View solution in original post

Announcements

Check out the upcoming Expert Session: Understanding ThingWorx Navigate Licensing in Community "Customer Events" section.