Searching. Supercharged.

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 faq 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 you can now start searching! start by typing in the name of a field we want to search by say you're in accounts accounts , and you want to search by description 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 smaller than only appears when dealing with numeric fields! pick or type out an operation we'll use contains contains to search for descriptions containing the word "licenses" "licenses" the quotes are important! you're letting quickquery know that you mean the word "licenses", as opposed to a field named licenses 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 accounts module, and search for accounts accounts having an opportunity opportunity with a likely likely value larger than larger than $25000 $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 opportunity likely 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 larger than or < < , depending on your preference, and notice how quickquery suggest the currencies that are configured in your sugarcrm instance pick "usd" "usd" you could have also used "us dollars" "us dollars" or "$" "$" be sure to include quotes around the name of the currency , and then enter 25000 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 accounts with opportunities opportunities that have no task task ? no problem! however, keep in mind that there's more to searching by links than this you should definitely learn about \<some> \<some> / \<all?> \<all?> / \<all!> \<all!> 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 docid\ p4uiqlb6kdnaoydfb8uhb then, understand the basics of how to guide to writing 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