Should you need to do more advanced filtering, there are a number of automatically set fields for each submission that are available in the Analytics tab. These can be combined with the default filters to perform complex queries.


Example queries:

  1. Find all submissions that have been modified in the last week by Mobenzi Support:
    • edited:true and modifiedby: “Mobenzi Support” and modifiedon: [NOW-7DAY TO NOW]
  2. Find all submissions not within 5km of a certain point:
    • AND - _query _ : “{geofilt pt=28.956, -30.862 sfield=location d=5}”
  3. Find all submissions between 18:00 and 19:00 regardless of data (time fields are storing seconds from 00:00:00 so it's 18*60*60 TO 19*60*60):
    • received time: [64800 TO 68400]



Advanced fields available for filtering are shown in the table below:


Field
Field Explanation
Example
id
Submission's unique identifier
id:4e9562d6-a0e0-4fd8-80b7-630d88df9dc1
captureddate
Date/time (in the format YYYY-MM-DDThh:mm:ssZ) at which the submission was captured (start date/time).
captureddate:[2012-10-05T00:00:00Z TO NOW]
Returns submissions which were captured from 5 October 2012 till now
receiveddate
Date/time (in the format YYYY-MM-DDThh:mm:ssZ) at which the submission was received by the system.
receiveddate:[NOW-1DAY TO NOW]
Returns submissions received in the last day
capturedtime
Seconds (from midnight) at which the submission was captured.
capturedtime:[82800 TO 86400] 
Returns submissions captured between 11pm and midnight
receivedtime
Seconds (from midnight) at which the submission was received by the system.
receivedtime:[0 TO 10800]
Returns submissions received between midnight and 3am
modifiedby
If edits have been made to the submission, the name of the user who made the edit will appear. If no edits have been to the submission, then this will be the name of the fieldworker who uploaded the submission.
modifiedby: Mobenzi Support Returns submissions submitted or edited by Mobenzi Support
modifiedon
This is the date on which the submission was last edited. If no edits have been made, then this will be the same date as the received date.
modifiedon: [NOW-14DAY TO NOW] Finds all submissions that have been modified in the past 14 days
latitude (double)
The measurement, in degrees, of the location where the submission was captured (distance north or south of the equator).
AND - _query _ : “{geofilt pt=30.965, -29.711 sfield=location d=20}” Finds all submissions not within 20km of a certain point
longitude (double)
The measurement, in degrees, of the location where the submission was captured (distance east or west of the prime meridian, which runs through Greenwich, England).
AND - _query _ : “{geofilt pt=30.891, -29.674 sfield=location d=20}” Finds all submissions not within 20km of a certain point