[Ur] Constructing SQL WHERE clause at runtime
Sergey Mironov
grrwlf at gmail.com
Tue Jun 2 15:43:03 EDT 2015
Hi! I am trying to implement a post-query filter. Of cause it is
possible to use [queryL] followed by server-side filtering code, but
using the DB engine is a better solution in my case.
Typically, I'd like to convert a list of string patterns to a WHERE
clause of the form (OR Field LIKE {[patter1]} OR Filed LIKE
{[pattern2]} OR ... pattern x ... OR FALSE)
I think it should be possible to write it in Ur/Web, but I can't
remember any examples demonstrating this. Is it really possible?
Thanks in advance,
Sergey
More information about the Ur
mailing list