| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Community Apps Dependencies | Show |
| Lines of code | 11509 |
| Technical Name |
oql_web |
| License | LGPL-3 |
| Website | https://github.com/hypsai/odoo_addons/tree/main/oql_web |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Community Apps Dependencies | Show |
| Lines of code | 11509 |
| Technical Name |
oql_web |
| License | LGPL-3 |
| Website | https://github.com/hypsai/odoo_addons/tree/main/oql_web |
Advanced Search
Type-to-search: replace Odoo's click-based search with a powerful text query bar featuring syntax highlighting, autocomplete, and intelligent search capabilities.
Syntax Highlighting. Autocomplete. Smart Search.
Advanced Search, Power Search, Smart Query, SQL Query
From Complex to Simple
Traditional Domain (30+ lines)
# 4 preparatory searches
boot_catg = env['product.category'].search(...)
danner_brand = env['product.category'].search(...)
size_values = env['product.attribute.value'].search(...)
waterproof_tags = env['product.template.tag'].search(...)
# Complex domain
domain = [
('categ_id', 'child_of', danner_brand.ids),
('product_template_attribute_value_ids...', 'in', size_values.ids),
('tag_ids', 'in', waterproof_tags.ids)
]
products = env['product.product'].search(domain)
OQL (1 line)
products = env['product.product'].searcho( "CatgS = 'Boot' and Brand = 'Danner' and EuShoeSize in ('40', '40.5') and Waterproof" )
Business terms No prep searches Readable by anyone
OQL Query Workbench
For advanced query development, access the full-screen IDE from the top navigation bar:
Click the OQL button in navigation bar
Full-screen IDE with multi-tab support
Multi-Tab Interface
Manage multiple queries
Model Browser
Quick query creation
Auto-Save
Never lose your work
Cloud Sync
Cross-device backup
Get Started in 3 Steps
Install Module
Install the required dependencies for Advanced Search:
-
Required: Install OQL Module
Advanced Search depends on theoqlmodule. Install it first:
https://apps.odoo.com/apps/modules/15.0/oql -
Download Advanced Search from Odoo App Store
You'll receive a file namedoql_web-x.x.x.zip -
Extract and Place in Addons Directory
Extract the zip file and copy theoql_webfolder to your Odoo addons path -
Install via Odoo Interface
Enable Developer Mode by adding?debug=1to your URL
Then go to: Apps → Click Update Apps List (top menu) → Search "Advanced Search" → Click Install
Use OQL Search
Switch to OQL mode and start searching with business language:
-
Click the OQL Toggle Button
Look for theOQLbutton on the left side of the native search bar. Click it to switch to OQL mode. -
Type Your OQL Query
The native search box will be replaced with an OQL editor featuring syntax highlighting and intelligent autocomplete (with oql_pro). -
Press Enter to Search
Simply pressEnterto execute your query. Results will appear just like native Odoo search.
Pro Tips:
Your search history is automatically saved
Toggle back to native search anytime
State persists across page refreshes
You're All Set!
Start writing business-focused queries and simplify your Odoo data searches today!
Optional: Enhanced Autocomplete
Want the intelligent autocomplete feature shown in the preview GIF above? Install the oql_pro module for advanced code completion and smart suggestions.
Get oql_pro:
https://apps.odoo.com/apps/modules/15.0/oql_proReady to Enhance Your OQL Experience?
Install Advanced Search and start writing queries with syntax highlighting and intelligent search!
View Advanced Search on GitHub
Please log in to comment on this module