Advanced Resources Search - Query Language
Advanced Resources Search - Query Language
The Query Language is an advanced search system that allows a logged in user of iCarol to refine search results by looking for specific values in resource record fields.
iCarol Admins can turn on this feature in their iCarol system by following these steps:
- Click Admin Tools in the left hand menu.
- Click the Resources tab.
- Scroll down to the "Other settings" section.
- Click the box next to "Enable Query Language in Resource Searching" to place a check mark there.
- Click the Save settings button at the top of the page.
How to use the Query Language
- Log into iCarol from an account with viewing access to the Resource database
- Click on "Resources" from the left menu, or click on "Search resources" from a call report.
- Enter a search term in the search text box, and click search (eg. Food)
- To refine your search results you will add a specific code to the end of the initial search term. The code consists of a short code (or abbreviation) for a resource field, then an equals sign, followed by the value to search. (eg. Food elg=homeless), then click search.
iCarol will then look for records were the original term exists AND where the additional field values exist.
Note: Query language also supports the boolean operators "AND" and "OR". (eg. Food elg=homeless OR women.
Available Codes for Query Language searches
Code Resource Field Searched (Example)adr= Exact address (eg. "adr=10025 106 Street", "adr=Cambridge")str= Address Line 1 & 2 (eg. "str="Jasper", "str=cambridge")loc= City/Town (eg. "loc=Toronto", "loc=Washinton")pcd= Postal/Zip Code (eg. "pcd="T6K 2W8", "pcd=91210")des= Description (eg. "des=taxes", "des=women")elg= Eligibility (eg. "elg=homeless", "elg=unemployed", "elg=low income")enm= Main Contact, Senior Worker Verifiers Name (eg. "enm=Carol", "enm=Neil")hrs= Hours Opened (eg. "hrs=9:00am", "hrs=3:00pm")lng= Language (eg. "lng=french", "lng=spanish")acc= Accessibility/wheelchair (eg. "acc=yes")
Note: Multiple codes can be used on the same search, for example "Food Bank lng=french elg=feed"
Related Articles
Multi-Language Capability
Multi-Language Capability iCarol offers the ability to use iCarol in both English and French using the Multi-Language Capabilities. This feature allows Resource editors to create French translations of Resource records, and for Admins to customize ...Configuring Resource Search Result Fields
Resource Search Result Fields Resource fields included in search results by default, if values exist in the records fields include: Record Name Alternative Name Record Type From: Parent Record Name (if the record is a Program or Site) Distance from ...Searching for and Viewing Resources
Search and View Resources All users (unless access has been restricted by an Admin) can look up resources. Resources can be searched inside a call report (if enabled) and from the main Resources page. There several search options available, searching ...Training Webinar: Search for Your Resources
During this training, participants will learn about: resource database structure resource search filters searching using custom categories searching using AIRS taxonomy saving resource searches searching using custom fields in resource records ...Sorting Resource Search Results
Understanding How Resource Searches Are Sorted When searching for resources you may choose to sort your search results Alphabetically or by Proximity. After you complete a resource search in iCarol, a radio button appears above your search results ...