Advanced search example

You can search for the objects that meet both of this criteria:

  • Objects that have a Sodium parameter value that is between 20 and 50.
  • AND
  • Objects that have a Protein parameter value that is between 50 and 80.

To do so, you can use a combination of the Simple and Advanced search modes.

  1. Click Simple and enter Sodium for the parameter. Then, enter a minimum value of 20 and a maximum value of 50.
  2. Click Advanced. The search criteria that you entered in Simple mode is displayed. 
    PARAM_CODE = 'SODIUM' and PVALUE >='20' and PVALUE <='50'
  3. Add the Intersect command. Then, specify the criteria for Protein. You can copy and paste the syntax for Sodium and then, modify the values. The complete syntax for Advanced mode is shown here. 
    PARAM_CODE = 'SODIUM' and PVALUE <='20' and PVALUE <='50'
Intersect
PARAM_CODE = 'PROTEIN' and PVALUE >='50' and PVALUE <='80'
  4. Click Search.