Queries
Queries are used in many places in the MOBIDI Office. Query enables you to choose only the required records out of thousands of records. Here are some examples:
Map only the last week data → you put a date criterion (last week)
I want last cleaning activities of last 1 month in excel → a data criteria (last 1 month) and activity=cleaning
How many customer's service took more than 3 hours in the last 3 months → last 3 months, customer and service duration >=3 hours
.
Query Interface
Below is the interface whenever a Query is needed. This page is divided into vertical sections and each section is for different criteria. You may use one or all at the same time, you can save a query and use many times.
Section | Purpose | Usa case sample |
|---|---|---|
Data Slider | Date slider enables you to limit records by start and end dates. The slider also has predefined ranges, like last month. |
|
Mobile Users | You can limit the records for a specific user(s) | You may be looking for records that a user entered. You may want to take a quick look at how much work has done last month. |
Groups | You can limit the records for a specific group(s) | It is a criterion you can use if you want to query a user-like group. |
Forms | Forms have common features so you can create queries across forms. This criterion is to limit which form's data will be included. If a form field used in multiple forms it will be a common feature along with creation date, location etc. | You can evaluate all forms in a single query in order to get values such as time spent in the field and person workload in many different fields. This feature will make your work easier in many places. |
Render Options | This criterion is to determine which elements will be on the map. You may show only the points, directions or waypoints. |
|
Attachment Options | Attachments are photos, videos or sound recordings. For example, you may select records containing videos. |
|
Other query Options | This option enables you to deleted records. For many reasons, MOBIDI Office does not persistently delete the records. This option is false by default. |
|
Saved Queries | You may save your query and use many times. This is a practical way of using the same criterion on dashboards, reports and more. |
|
Criteria by Fields
You may use every form field as a criterion. Names starting with John, values between 100 and 200, and so. Please check rules at the end of this page.
Rules for Alphanumeric Fields
Applicable for Text and TextArea field types.
Example | Açıklama |
|---|---|
Solved | Whole word. Records containing “Solved” |
Solved* | Records start with Sol |
*Sovedl* | Text containing Solved in any place. |
Rules for Numeric Fields
Applicable for Number field types.
Sorgu | Açıklama |
|---|---|
>5 | Values greater than 5 |
<5 | Values less than 5 |
1..5 or 1-5 | Values between 1 and 5 |
2,3,5 | Matches to only 2, 3 and 5 |