[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