Filter widget connected to jdbc mysql connection doesn´t work

[horphi]

Hello,

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

Does this should work?

Many thx in advance,

Philipp

[PaiChung · Accepted solution]

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.