Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Upload all data from your device to ensure that no data are lost in step 3 below

  2. Change your download parameters to the new desired parameters

  3. Re-initialize your database

  4. Download data

  5. Verify that you recieved the data you expect based on your download parameters. If you need to adjust, repeat steps 2-4 above

Common Where Clauses

Where Clause

Description

Example

field_name='text_value'

Downloads data where the text value matches the value in single quotes within the specified field

Region='NW'

field_name=numeric_value

Downloads data where the numeric value matches the specified value within the specified field

Site_Index=2

field_name='text_value' AND field_name=numeric_value

Combination of the two examples above using the ‘AND’ operator. This will only download data where both conditions are met for a single feature

Region='NW' AND Cruiser_ID='ABC'

field_name='text_value' OR field_name=numeric_value

Similar to above but using ‘OR’. This will download any feature that meets either criteria

Cruiser_ID='ABC' OR Contractor_ID='XYZ'

field_name IN ('text_value1','text_value2')

Allows for selection of multiple values within a list. Similar to using the OR operator on a single field.

Status IN ('Cruised','Checked')

  • known issue - this is not working and will be addressed in a future release. In the meantime, use OR as described above