---
title: Searching. Supercharged.
slug: docs.sugarquickqueryis.fun
docTags:
createdAt: 2023-02-12T16:09:39.000Z
---
QuickQuery is **search on steroids**. Here are some of the things you can do with QuickQuery:
- Search using **and/or/not**!
- Search using queries on **related modules! **Need to find Accounts having Calls associated with a closed Opportunity? No problem! How about Opportunities with no Calls or Meetings planned in the next month? Easier than 1-2-3!
- Write queries that** compare fields**! Looking for Opportunities whose assigned user is different from the assigned user of the parent Account? We've got you covered!
- Search** anywhere normal search works** - QuickQuery works on list views, when selecting related records, in dashlets, subpanels, in Forecasts - anywhere you have a search bar!
- **Save your queries** just as you would with regular filters, and re-use them whenever you feel like it! What's more, you can **share your queries with others** simply by copy-pasting them!
- Not sure what that field was named? No worries! QuickQuery **helps you write your query** by hinting appropriate fields, operations, values for drop-downs, currencies, and more. It also lets you know when you made a mistake.
- Everyone likes colors! Watch as QuickQuery **highlights your query** using a beautiful, vibrant palette, which makes it easy to keep your bearings in a long query!
- **Currencies are automatically handled** behind the scenes, with QuickQuery converting between them on the fly!
- Take advantage of an **incredibly powerful way of working with temporal fields**, while also taking into account your timezone settings. Search using queries like *"9am first Saturday of last month"* or *"-2 weekdays"*
- QuickQuery immediately works with **all custom fields and custom modules**! No need to configure anything.
- QuickQuery works **alongside built-in filter functionality**, and [can be combined with them](docId\:W-qrkDeRLeW3WRPt_ZMUc). It is also non-invasive, meaning **each user can decide to turn it on and off as they wish**, for any module.
***
## Crash Course
### Basics
To enable QuickQuery, **click on the grey lightning bolt** in any search bar. The bolt will turn yellow, indicating QuickQuery is up and running.
::::VerticalSplit{layout="middle"}
:::VerticalSplitItem
::Image[]{src="https://api.archbee.com/api/optimize/fRibh2_2NwaS_4MGgrZuA/ZltKSlf8Iy1F_5eGYB1w3_searchingsuperchargedqqoff.png" size="64" width="277" height="120" caption="QuickQuery turned off" position="center" showCaption="true"}
:::
:::VerticalSplitItem
::Image[]{src="https://api.archbee.com/api/optimize/fRibh2_2NwaS_4MGgrZuA/iJbBDh0HiBBF-wQz4onn0_searchingsuperchargedqqon.png" size="74" width="268" height="100" caption="QuickQuery turned on" position="center" showCaption="true"}
:::
::::
You can now start searching!
Start by **typing in the name of a field** we want to search by - say you're in `Accounts`, and you want to search by `Description`:
QuickQuery automatically searches among all valid things you could mean, and gives you the option of **autofilling** it using either the arrow keys **\[↑]** / **\[↓]** and **\[↵ Enter]** or the mouse 🖱️. Try it out!
Once you type the name, QuickQuery proceeds to **suggest all valid operations** you can use, depending on the field type. For example, `smaller than` only appears when dealing with numeric fields!
Pick or type out an operation - we'll use `contains` to search for descriptions containing the word `"licenses"`. **The quotes are important!** You're letting QuickQuery know that you mean the *word* "licenses", as opposed to a *field* named `licenses`.
That's it! Notice how **the **`Search`** button turned green**, indicating that there are no errors in your query, and you're ready to roll. Go ahead and click the button, or press **\[⇧Shift]** + **\[↵ Enter]**, and watch the results of your search appear on screen.
**Congratulations!** You just performed your first basic search with QuickQuery! Now let's take a look at **searching using linked records!**
***
### Search Using Linked Records
Let's stay in the `Accounts` module, and search for `Accounts` having an `Opportunity` with a `Likely` value `larger than` `$25000`. To search by a field in a related record, you write **the name of the related module, a period, and then the name of the field**. So in our example, you would write `Opportunity``.``Likely`. As always, when you start typing, QuickQuery will suggest the correct fields, and even include the period.
Notice how the available operations changed from last time, since you're now querying a numeric field. Pick either `larger than` or `<`, depending on your preference, and notice how QuickQuery suggest the currencies that are configured in your SugarCRM instance.
Pick `"USD"` - you could have also used `"US Dollars"` or `"$"` - be sure to **include quotes around the name of the currency**, and then enter `25000`. The `Search` button turns green, indicating you have a valid query, and you're free to fire it off!
**Awesome!** You just learned how to search using linked records. Keep in mind that you're **not limited to a single level!** How about searching for `Accounts` with `Opportunities` that have no `Task`? No problem!
However, keep in mind that there's more to searching by links than this. You should definitely learn about ``/``/`` in [Fields & Links](docId\:kzBTLLYb4xfJ8DF290vXI)!
***
### Where To Go From Here
- First, spend some time reading our [Terms & Conditions](docId\:Vlm7IzovtB18mrxrRHKfJ)
- After that, quickly learn about the [visual elements in QuickQuery](docId\:P4UIQLB6kdnaOydfb8uHB)
- Then, understand the basics of how to [write queries](docId\:zBJ6ATBBc9_S7nLSnWcHh)
- Most importantly, learn about:
- [Fields & Links](docId\:kzBTLLYb4xfJ8DF290vXI)
- [Operators](docId:-A6C2C3F2FW7YdjuVamvz)
- [Values](docId\:KhWZ7b0QhFIwTzxiLv2JI)
- Finally, browse through [Useful Examples](docId:4z206vS3o6OyFfkvFWR1l) and the [FAQ](docId\:W-qrkDeRLeW3WRPt_ZMUc)