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
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>