How to do a 'CONTAIN SEARCH'



Introduction
First make sure you are familiar with how search, using filter is implemented with EachScape
 In this Tutorial we will use the Filter Data tutorial app.


Tutorial App: Filter Data 
Instal the Tutorial App 'Filter Data' from the  Base AppTutorial section on your Dashboard.


Click here to install this app in your workspace


The content of this app comes from a Cloud Collection named "Apple and Oranges" which is installed along with the Tutorial App.


Contain Search
We use the Filtering action: Define Data Source Filter.
- In the Tutorial app you access it via any of the Filtering button 'Orange' or 'Apple'-

Choose a column from the Data Source Drop down.
 Next for ‘Parameter’ Dropdown make sure you choose ‘(Custom filters)’
 


Next is the ‘Value’ field which is the complex part.

  • For Value we are going to input in this format: 

    • nameofcolumn:co:[[var:search]]

      • nameofcolumn = name of column name you want to search. Make sure it is type as all lowercase even if the cloud collection has a uppercase letter.

      • co = this is telling the event to see if column contains the text user puts into the Text Input block.

      • [[var:Search]] = The variable which contains the term you want to search. 

 

  • Next we want to Refresh the data source that we are searching.

 

 

The cloud collection will now be searched to find if the variable [[var:Search]] is contained within the column you specified.

To search more than one column at a time (so instead of just the title column as seen in this example) you can add an or statement like this at the end of your Define Data Source Filter ‘Value’:

  • title:co:[[var:Search]]~or~description:co:[[var:Search]]~or~age:co:[[var:Search]]

    • This will now search the Title, Description and Age column for the User Inputted value or our Result Variable [[var:Search]].