This article provides a few tips for when you are filtering based on the fields within a specific form:
- Field names
- Choice fields
- DateTime fields
- Number fields
- Text fields
A field name is “Household_contents”. When filtering on this field, you would use the filter: Household_contents
Multiple choice fields
Responses to multiple choice fields are based on option value, not the text.
You have a 'Select One' field named “Chronic_conditions” with the options “1. Yes [Y]” and “2. No [N]”. You want to see all the submissions containing chronic conditions. You would use the following filter: Chronic_conditions: Y
'Select Many' fields are referenced slightly different to 'Select One' fields. To filter on a 'Select Many' field type, you must prefix the field name with "mobmulti_".
You have a 'Select Many' field named “Household_characteristics” with option values 1 to 4. To filter for all the submissions where options “1” and “3” were selected for this field, you would use the following filter: mobmulti_Household_characteristics:1 AND mobmulti_Household_characteristics: 3
To reference a DateTime field type in a filter, you must prefix the field name with "mobdate_". Dates are specified in the format YYYY-MM-DDT00:00:00Z.
The basic syntax supports addition, subtraction and rounding at various levels. Commands can be chained together and are evaluated from left to right. '+' and '-' denote addition and subtraction, while '/' denotes "round". Round requires only a unit, while addition and subtraction require an integer value and a unit. Command strings must not include any spaces.
Round to the start of the current hour
Round to the start of the current day
Exactly two years in the future from now
Exactly 25 minutes ago
Exactly 1 day ago
6 months and 3 days in the future from the start of the current day
6 months and 3 days in the future from now, rounded down to nearest day
You have a field named "DOB". To retrieve all submissions where the date of birth reported was between 9 June 2010 and 1 year from the current date, you would use the filter: mobdate_DOB: [2010-06-09T00:00:00Z TO now -1y]
To reference a numeric integer field type in a filter, you must add "mobint_" to the field name.
You have a field named "Household_Member_Count". To display all submissions where households had 4 or more members, you would use the filter: mobint_Household_Member_Count: [4 TO *]
To reference a numeric decimal field type in a filter, you must add "mobdouble_" to the field name.
You have a field named "Baby_Birth_Weight". To filter for all submissions reporting birth weights under 2.5kg, you would use the filter: mobdouble_Baby_Birth_Weight: [0 TO 2.5]
To reference a text field type, you can simply use the field name.
You have a field named "Job_Other". To view all submissions where the job description entered was "Dentist", you would use the filter: Job_Other: “Dentist”
You can also make use of "wildcards" to filter for partial matches. To perform a single character wildcard match, use the "?" character. To perform a multiple character wildcard match, use the '*" character. Do not enclose the search term in quotations.
The filter Job_Other: Art* will return results containing both “Artist” and “Artisan”
The filter Job_Other: T?ster will return results containing both “Tester” and “Taster”