---
title: Example Queries
description: In-Synch
---
[Skip to content](https://kb.arms.com/in-synch/example-queries#main-content)
English
Show submenu for translations
Open main navigation
Close main navigation
- English
Show submenu for translations
- Contact us
Contact us
How can we help you?
- There are no suggestions because the search field is empty.
1. [In-Synch](https://kb.arms.com/in-synch?hsLang=en)
2. [Knowledge base2](https://kb.arms.com/in-synch/knowledge-base2?hsLang=en)
3. [Modules](https://kb.arms.com/in-synch/knowledge-base2?hsLang=en#modules)
# Example Queries
No recent searches
Popular Articles
Sorry! nothing found for
### Example Queries
Created by Russ Hartle, Modified on Fri, 20 Jun, 2025 at 2:40 PM by Russ Hartle
**Example 1:** We will be looking for All Pending or Rejected Assignments to Officers.
1. Add (A) and choose Assignment (B)
[](https://manula.s3.amazonaws.com/user/9801/img/query-002_v1.png)
2. Choose Status (A) as your attribute, Assigned (B), Click the OR button ( C ) and choose Rejected (D)
[](https://manula.s3.amazonaws.com/user/9801/img/query-003.png)
3. We now will add a second Attribute of Officer by clicking Add (A)
[](https://manula.s3.amazonaws.com/user/9801/img/query-004.png)
4. Choose Officer (A) as your attribute and in the Is section (B) select an Officer name from the drop down and click OK.
[](https://manula.s3.amazonaws.com/user/9801/img/query-005_v1.png)
5. Click the double UP Arrows (A) to choose all columns and hit Search (B)
[](https://manula.s3.amazonaws.com/user/9801/img/query-006_v1.png)
6. The results will populate in your Grid similar to what is seen below. Note that you can sort by clicking the Column Header (A), you can preview narratives by hovering over the text box (B), and you can [Work with the Query Results](https://www.manula.com/manuals/in-synch-systems/in-synch-rms-manual/1/en/topic/working-with-query-results) using the Toolbar Icons ( C )
[](https://manula.s3.amazonaws.com/user/9801/img/query-007.png)
**Example 2:** We will be looking for all Cases that have a certain Crime Code Section in a defined time frame
1. Click Add (A) and choose Crime Code (B)
[](https://manula.s3.amazonaws.com/user/9801/img/query-008.png)
2. Choose the Attribute of Code Section (A) and Enter a Criteria (B) and click OK. For this example, I will be using starts with 11. You have various options in the drop down list other than starts with.
[](https://manula.s3.amazonaws.com/user/9801/img/query-009.png)
3. Use the Up Arrow Selection (A) to choose what columns will be visible (for this example I will use the double Up Arrow to select all columns)
[](https://manula.s3.amazonaws.com/user/9801/img/query-010.png)
4. Click Extra (A) to add a second Search Criteria and Choose Case (B) and click OK.
[](https://manula.s3.amazonaws.com/user/9801/img/query-011.png)
5. Change the Attribute (A) to Date Reported and define the Date Criteria (B) and click ok. (for this example we will be looking at a Date Criteria that is after January 1st of 2015 at 00:00:00 hours
[](https://manula.s3.amazonaws.com/user/9801/img/query-012.png)
6. Use the Up Arrow Selection (A) to choose what columns will be visible (for this example I will use the double Up Arrow to select all columns) and click Search (B)
[](https://manula.s3.amazonaws.com/user/9801/img/query-013.png)
7. Your initial results will look as if it only returned the Code Section. However, if you notice the PLUS sign (A) in the left-hand column this indicates there are more details available. This is because we did a multi-layered Query by adding the Extra Criteria. You can now Click (B) to expand your results.
[](https://manula.s3.amazonaws.com/user/9801/img/query-014.png)
8. With your results expanded you can now see that some Code Sections do not contain any Case Data under them (A) However any that do have Case Data will now have it listed under the Code Section similar to (B). With a Multi-Layer Query, you will need to follow the Steps in the [Custom Reports](https://www.manula.com/manuals/in-synch-systems/in-synch-rms-manual/1/en/topic/custom-reports) Section to be able to print your data.
[](https://manula.s3.amazonaws.com/user/9801/img/query-015.png)
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Let us know how can we improve this article! \*
Feedback sent
We appreciate your effort and will try to fix the article
**X**
- [Release Notes](https://kb.arms.com/in-synch/release-notes?hsLang=en#main-content)
- [Version 4.8](https://kb.arms.com/in-synch/release-notes?hsLang=en#version-4-8)
- [Knowledge base3](https://kb.arms.com/in-synch/knowledge-base3?hsLang=en#main-content)
- [How To](https://kb.arms.com/in-synch/knowledge-base3?hsLang=en#how-to)
- [Knowledge base2](https://kb.arms.com/in-synch/knowledge-base2?hsLang=en#main-content)
- [Modules](https://kb.arms.com/in-synch/knowledge-base2?hsLang=en#modules)
- [Knowledge base1](https://kb.arms.com/in-synch/knowledge-base1?hsLang=en#main-content)
- [State Reporting](https://kb.arms.com/in-synch/knowledge-base1?hsLang=en#state-reporting)
- [Internal Wiki](https://kb.arms.com/in-synch/knowledge-base1?hsLang=en#internal-wiki)
- [State Specific Modules](https://kb.arms.com/in-synch/knowledge-base1?hsLang=en#state-specific-modules)
- [Release Notes](https://kb.arms.com/in-synch/knowledge-base1?hsLang=en#release-notes)
- [In-Synch RMS QuickStart Video Series](https://kb.arms.com/in-synch/knowledge-base1?hsLang=en#in-synch-rms-quickstart-video-series)
- [Error Messages](https://kb.arms.com/in-synch/knowledge-base1?hsLang=en#error-messages)
- [Knowledge base](https://kb.arms.com/in-synch/knowledge-base?hsLang=en#main-content)
- [Interfaces](https://kb.arms.com/in-synch/knowledge-base?hsLang=en#interfaces)
[](http://arms.com)
[mailto:email@email.com](mailto:email@email.com)
Copyright © 2026, End2End Public Safety