When working with SQL Query objects you can use sqlquery_setConditionsFromUserSearchString to set the "conditions" property of a SQL Query based on text a user enters.

In the following examples you will see results based on various search strings that were entered. The code to perform the search looks like this:

put sqlquery_createObject("todo_items") into theQueryA

put the text of field "Search" into theSearchString

put "todo_items.name contains :1" into theSearchCondition

sqlquery_setConditionsFromUserSearchString theQueryA, theSearchString, theSearchCondition

Basically the text that the user enters in the "Search" field will be parsed by SQL Yoga and inserted into the search condition that has been defined.

Here is what the results look like when no search term has been entered in the Search field.

If a single word is entered then any record that contains that word will be returned. Here you can see that two to-do items contain the word install.

If more than one word is used then the words are split up and results that contain all of the words are returned. Here you can see that no records contain both the word gnome AND the word windows.

If the search term enters the words AND or OR then the search takes that into account. Here you can see that records that contain the word gnome OR the word windows are returned.

If the search term is wrapped in quotes then an exact match is searched for rather than both words. Here you can see that there are no records that contain the phrase install gnome.

If the quotes are removed then a result is returned as there is one record that contains the word install and the word gnome.