Table of Contents

Differences Between MobileMap 4.x and MobileMap 5.x for Download Parameters

...

Download parameters are set at any point in time in MobileMap 4.x. In MobileMap 5.x, these parameters are set right before generating a geodatabase. In MobileMap 5.x, these parameters can only be set upon initial geodatabase generation. For the lifespan of a generated geodatabase, it will only be able to download features with the parameters that were set originally when the geodatabase was generated.
...
To specify download parameters, a Feature Service needs to be selected for downloading (Actions menu → Configure Offline Geodatabase). Once a Feature Service has been downloaded, select the download button and then you should see the “Configure Offline Geodatabase Parameters” screen. You will see a table with a row for each of the layers in the service. The checkbox indicates that data should be downloaded for that layer. If data should be filtered or limited when downloading, specify the ‘Where Clause’. The Where Clause is the logic that will be used by MobileMap when it requests data for download. It follows the syntax used by the ArcGIS REST API’s where clause (https://developers.arcgis.com/rest/services-reference/query-feature-service-layer-.htm#GUID-62EE7495-8688-4BD0-B433-89F7E4476673 ).
In the screenshot below, the user has decided to NOT download data for any of the generic feature layers because they do not wish to clutter their map with ad hoc data collected by other users. They have also decided on ONLY download data within the ‘NW’ Region. This assumes that there is a field named ‘Region’ and that ‘NW’ is a valid value.
...
The where clause operates on the database field names (not aliases) and the stored values (not descriptions in the case of Coded Value Domains). For example if a field is named ‘Region', but the Alias is ‘Inventory Region’, use ‘Region’. Similarly, if the Region field uses a Coded Value Domain with the codes ‘NW’, ‘SW’, etc. and descriptions of ‘Northwest’, ‘Southwest’, use the code 'NW’.
Computers have a hard time comparing two decimal numbers for equality due to the well known round-off error problem (https://en.wikipedia.org/wiki/Round-off_error ). For this reason, avoid where clauses that use the equals sign and a specified value. Instead, use > and < to find matches. Example: Acres > 39.99 AND Acres < 40.01 will find Stands that are 40 acres.
Text values need to be surrounded in single quotes. Note that on many android devices there are two single quote characters on the software keyboard. One that is vertical and another that is rotated. Use the vertical one, not the rotated one.
...

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