Oliver Fisk
Posts: 0
Joined: Wed Jul 09, 2014 10:02 pm

Like and Case insensitive query

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.

Return to “Issues”