DMXzone Server Connect Support Product Page

Filter problem on Query Options of Database Source Query Builder

Reported 04 Mar 2016 16:10:44
1
has this problem
04 Mar 2016 16:10:44 Greta Garberini posted:
I use a database table for a dynamic populated select form element. Some fields should not be displayed because they start with a html tag like <div>.
So I chose the "Filters" option in Database Source Query Builder like in the old databindings and selected the field Column (name) "Start Not With" value <
After this step not one single record is showing up. I have tried "<" and '<' but no joy.

Replies

Replied 04 Mar 2016 19:05:56
04 Mar 2016 19:05:56 George Petrov replied:
Hi Greta,

Did you just enter as filter value <div> without the quotes? There is no need for quotes - it is all automatically escaped.

Greetings,
George
Replied 08 Mar 2016 15:35:53
08 Mar 2016 15:35:53 Greta Garberini replied:
Well I only did "<" (with and without the quotes) because another field starts with <hr> which I also don't like to include in my select titles. Or is it better to do <div> OR <hr>

Reply to this topic