Search Records by Criteria

 Overview

You can search records in a view using the Search option displayed below the view header in Live mode as shown in the screen-shot below. The Search option is supported in List view and Grid view. Range search is supported for Date and Numeric fields.

 Steps to specify the search criteria

Click on the Search link which is displayed below the view header in Live mode. This will display the comparison operators supported for each field type and the text-box to specify the criteria value.

Specify the search criteria by selecting the required operator and specify the value. For instance, if you want to search records for Sales form based on a particular profit value, select the operator "Greater Than" for the profit field.

Only those records in the database that satisfy the search criteria will be listed.

 Search Criteria

(*) denotes string field is supported     (#) denotes number field is supported     ($) denotes date field is supported

CriteriaReturnsExample

Is (*, # and $)

Records with values that have an exact match  with the specified keywordReturns "Creator" if the keyword is specified as "Creator"

Is not (*, # and $)

Records with values which do not match at all with  the specified keywordReturns all records except "Creator" if the keyword is specified as "Creator"

Is empty (*, # and $)

Records with empty or blank valuesReturns all records where there is no value in the field

Is not empty (*, # and $)

Records with non-empty or non-blank valuesReturns all records where there is any value present in the field

Starts with (*)

Records with values starting with the specified  keywordReturns all the values starting with "Cre", for example - "Creator" if "Cre" is specified as the keyword

Ends with (*)

Records with values ending with the specified  keywordReturns all the values ending with "Tor", for example - "Creator" if "Tor" is specified as the keyword

Like (*)

Records with comparatively precise valuesReturns all the values starting with "Zoho" like "Zoho CRM", "Zoho Creator" etc if the specified keyword is Zoho*.  Similarly, *Zoho will return all the values ending with "Zoho"

Contains (*)

Records with values containing the specified  keyword Returns all the values containing the keyword. For example, it will return a value like "Creator" if "Cr" or "Ea" or "To" etc are specified as the keyword

Not Contains (*)

Records with values that do not contain the  specified keyword Returns all the values which do not contain the keyword. For example, it will return values like "Mail", "Writer" etc for keywords like "Cr" or "Ea" or "To" etc.

Less than (#)

Records with values lesser than the specified keywordReturns records with values "1", "2" and "3" if the specified keyword is "4"
Greater than (#)

Records with values greater than the specified keyword

Returns records with values  "5", "6", "7" and so on if the specified keyword is "4"
Less than or equal to (#)

Records with values less than or equal to the specified keyword

Returns records with values "1", "2", "3" and "4" if the specified keyword is "4"
Greater than or equal to (#)

Records with values greater than or equal to the specified keyword

Returns records with values "4", "5", "6", "7" and so on if the specified keyword is "4"
Between (# and $)

Records with values between the specified From and To keywords

Returns records with values "2", "3" and "4" if the specified From and To keywords are "1" and "5" respectively

Returns records with date values  "2-APR-2014" and "3-APR-2014" if the specified From and To keywords are "1-APR-2014" and "4-APR-2014" respectively

Before ($)

Records with date values that fall before the specified date

Returns records with date values "2-APR-2014", "1-APR-2014" and so on if the specified keyword is "3-APR-2014"

After ($)

Records with date values that fall after the specified date

Returns records with date values "2-APR-2014", "3-APR-2014" and so on if the specified keyword is "1-APR-2014"

Day ($)

Records with date values according to the specified keyword in terms of days

Click here to know more

Week ($)

Records with date values according to the specified keyword in terms of weeks

Click here to know more

Month ($)

Records with date values according to the specified keyword in terms of months

Click here to know more

Year ($)

Records with date values according to the specified keyword in terms of years

Click here to know more

 Related topics

Functionality based URLs to set criteria for a view | Global Search