Page 1 of 1

Like and Case insensitive query

Posted: Fri Jul 11, 2014 3:50 pm
by Oliver Fisk

I'm currently using the following query in the data mapping to return filtered lists from the database: return '{"Database_Field":"' + value + '"}'; by mapping a local variable in the Request.

Can anyone tell me how I would change it to:

  • Ignore the case of the variable input

  • Work as "like" (so someone could enter part of the field content into the variable.

    Thanks in advance.


Like and Case insensitive query

Posted: Fri Jul 11, 2014 4:12 pm
by Evgene Karachevtsev