You are here: More... > Add a condition

Add a condition

To define the data that will be downloaded, create a condition.

  1. On the Map tab, click Condition Builder.

    The Condition Builder box opens.

  2. Select the field.

    The default is All Fields.

  3. In the Field Description box, click the field you want.
  4. In the Value Type box, choose Fixed Value.
  5. In the Comparison box, choose an operator from the list.

    The list shows only the operators that match the data type.

  6. In the Value box, type the number or text.
  7. Choose And or Or if you want to add more conditions.
  8. Click the Add icon.
  9. Repeat for any other conditions, and then click OK.

Notes:
To add multiple values, such a Number of Employees > 50 and < 500, use the left bracket on the first value and the right bracket on the last value.

You can nest up to five conditions in the query.

Dates and times

If the value is a date or a date and a time, do one of the following:

  • Click Constant and choose a timeframe and click the Update Value button.

    If you choose a value that contains N, such as Last_N_Days, enter a number for N in the box.

    date picker

  • Click Value, choose the date, enter the time, and click the Update Value button.

The In operator

In the condition, you can specify a list of field values to include or not include in the results.

  1. In the Comparison box, choose IN or NOT IN.

    options for using in operator

  2. Do one of the following:
    • Under Select Text File containing List, click the Browse button (the folder), select the text (.txt) file that you want to use, click Open, and then click the green checkmark button.
    • Under Enter values, type a value, and then click the green and white plus button. Type the next value. After you add all the values that you want, click the green checkmark button.

Editing a condition

  1. Click the Edit button for the condition that you want to change.

    edit condition button

  2. In the Value box, make the changes that you want. Be sure to keep the syntax the same.

    condition edited in value box

  3. Click the Add icon to add the updated condition.

Condition features for Master-Detail scripts

When you are building a condition for a Master-Detail script, you have a few more options:

  • You can access all objects at once, so your condition can include multiple objects.
  • You can see the full text of the query.
  • You can choose to download all records, only the master records that have detail records, or only the master records that do not have detail records.