Search 1.9 billion lines of Odoo code on GitHub
web_advanced_search
<h1 class="title">Advanced search</h1>
<p><a class="reference external" href="https://odoo-community.org/page/development-status"><img alt="Beta" src="https://img.shields.io/badge/maturity-Beta-yellow.png" /></a> <a class="reference external" href="http://www.gnu.org/licenses/agpl-3.0-standalone.html"><img alt="License: AGPL-3" src="https://img.shields.io/badge/licence-AGPL--3-blue.png" /></a> <a class="reference external" href="https://github.com/OCA/web/tree/14.0/web_advanced_search"><img alt="OCA/web" src="https://img.shields.io/badge/github-OCA%2Fweb-lightgray.png?logo=github" /></a> <a class="reference external" href="https://translation.odoo-community.org/projects/web-14-0/web-14-0-web_advanced_search"><img alt="Translate me on Weblate" src="https://img.shields.io/badge/weblate-Translate%20me-F47D42.png" /></a> <a class="reference external" href="https://runbot.odoo-community.org/runbot/162/14.0"><img alt="Try me on Runbot" src="https://img.shields.io/badge/runbot-Try%20me-875A7B.png" /></a></p>
<p>More powerful and easy to use search, especially for related fields.</p>
<p><strong>Table of contents</strong></p>
<div class="contents local topic" id="contents">
<ul class="simple">
<li><a class="reference internal" href="#usage" id="id5">Usage</a><ul>
<li><a class="reference internal" href="#in-selection-operator" id="id6">In Selection operator</a></li>
</ul>
</li>
<li><a class="reference internal" href="#known-issues-roadmap" id="id7">Known issues / Roadmap</a></li>
<li><a class="reference internal" href="#changelog" id="id8">Changelog</a><ul>
<li><a class="reference internal" href="#id1" id="id9">14.0.2.0.0 (2021-09-21)</a></li>
<li><a class="reference internal" href="#id2" id="id10">11.0.1.0.2 (2018-10-31)</a></li>
<li><a class="reference internal" href="#id3" id="id11">11.0.1.0.1 (2018-09-18)</a></li>
<li><a class="reference internal" href="#id4" id="id12">11.0.1.0.0 (2018-07-20)</a></li>
</ul>
</li>
<li><a class="reference internal" href="#bug-tracker" id="id13">Bug Tracker</a></li>
<li><a class="reference internal" href="#credits" id="id14">Credits</a><ul>
<li><a class="reference internal" href="#authors" id="id15">Authors</a></li>
<li><a class="reference internal" href="#contributors" id="id16">Contributors</a></li>
<li><a class="reference internal" href="#maintainers" id="id17">Maintainers</a></li>
</ul>
</li>
</ul>
</div>
<a name="usage"></a>
<h2><a class="toc-backref" href="#id5">Usage</a></h2>
<p>To use this module, you need to:</p>
<ul class="simple">
<li>Open <em>Filters</em> in a search view</li>
<li>Select any relational field</li>
<li>Select operator <cite>is equal to</cite> or <cite>is not equal to</cite></li>
<li>The text field changes to a relational selection field where you
can search for the record in question</li>
<li>Click <em>Apply</em></li>
</ul>
<p>To search for properties of linked records (ie invoices for customers
with a credit limit higher than X):</p>
<ul class="simple">
<li>Open <em>Filters</em> in a search view</li>
<li>Select <em>Add Advanced Filter</em></li>
<li>Edit the advanced filter</li>
<li>Click <em>Save</em></li>
</ul>
<p>Note that you can stack searching for properties: Simply add another
advanced search in the selection search window. You can do
this indefinetely, so it is possible to search for moves belonging
to a journal which has a user who is member of a certain group etc.</p>
<dl class="docutils">
<dt>Note also the domain dialog offers an editable preview in debug mode:</dt>
<dd><img alt="https://raw.githubusercontent.com/OCA/web/14.0/web_advanced_search/static/img/debug_mode.png" class="first last" src="https://raw.githubusercontent.com/OCA/web/14.0/web_advanced_search/static/img/debug_mode.png" />
</dd>
</dl>
<a name="in-selection-operator"></a>
<h3><a class="toc-backref" href="#id6">In Selection operator</a></h3>
<p>It is also possible when having selected a relational field to filter on, to
choose for the 'is in selection' operator. This will result in opening a list view for
the related model, where it is possible either to select some records, and then use the
'Select' butto, or to enter filters on the related model, and then click the
'Use Criteria' button.</p>
<p>Example: select the 'Created By' field to filter Invoices, and then 'is in selection'
as operator:</p>
<img alt="https://raw.githubusercontent.com/OCA/web/14.0/web_advanced_search/static/img/01-is-in-selection-operator.png" src="https://raw.githubusercontent.com/OCA/web/14.0/web_advanced_search/static/img/01-is-in-selection-operator.png" />
<p>Then select some records and click on the select button:</p>
<img alt="https://raw.githubusercontent.com/OCA/web/14.0/web_advanced_search/static/img/02-select-button.png" src="https://raw.githubusercontent.com/OCA/web/14.0/web_advanced_search/static/img/02-select-button.png" />
<p>Only invoices created by the selected users will be shown:</p>
<img alt="https://raw.githubusercontent.com/OCA/web/14.0/web_advanced_search/static/img/03-select-result.png" src="https://raw.githubusercontent.com/OCA/web/14.0/web_advanced_search/static/img/03-select-result.png" />
<p>Another example would be to filter on the invoice partners:</p>
<img alt="https://raw.githubusercontent.com/OCA/web/14.0/web_advanced_search/static/img/04-use-criteria-button.png" src="https://raw.githubusercontent.com/OCA/web/14.0/web_advanced_search/static/img/04-use-criteria-button.png" />
<p>Now only invoices for partners that are companies, and are in a country with 'Swit' in
the name will be shown:</p>
<img alt="https://raw.githubusercontent.com/OCA/web/14.0/web_advanced_search/static/img/05-use-criteria-result.png" src="https://raw.githubusercontent.com/OCA/web/14.0/web_advanced_search/static/img/05-use-criteria-result.png" />
<a name="known-issues-roadmap"></a>
<h2><a class="toc-backref" href="#id7">Known issues / Roadmap</a></h2>
<p>Improvements to the <code>domain</code> widget, not exclusively related to this addon:</p>
<ul class="simple">
<li>Use relational widgets when filtering a relational field</li>
<li>Allow to filter field names</li>
</ul>
<p>Improvements to the search view in this addon:</p>
<ul class="simple">
<li>Use widgets <code>one2many_tags</code> when searching <code>one2many</code> fields</li>
<li>Use widgets <code>many2many_tags</code> when searching <code>many2many</code> fields</li>
<li>Allow to edit current full search using the advanced domain editor</li>
</ul>
<p>Issues:</p>
<ul class="simple">
<li>Grouped totals can show incorrect values. See <a class="reference external" href="https://github.com/odoo/odoo/issues/47950">https://github.com/odoo/odoo/issues/47950</a></li>
<li>DomainSelector Dialog cannot correctly show 'in selection' domains.</li>
</ul>
<a name="changelog"></a>
<h2><a class="toc-backref" href="#id8">Changelog</a></h2>
<a name="id1"></a>
<h3><a class="toc-backref" href="#id9">14.0.2.0.0 (2021-09-21)</a></h3>
<ul>
<li><p class="first">Restore the 'is in selection' operator.</p>
<p>The 'is in selection' operator offers a really convenient way to either pick a
selection of related records, or specify criteria / filters to define a domain for
the related records.</p>
<p>[NL66278]</p>
</li>
</ul>
<a name="id2"></a>
<h3><a class="toc-backref" href="#id10">11.0.1.0.2 (2018-10-31)</a></h3>
<ul>
<li><p class="first">Fix initialization of 1st domain node</p>
<p>Sometime the dialog is not ready yet, like on EE version.
Hence when you inject the 1st domain node
the dialog must be already opened.</p>
<p>[simahawk]</p>
</li>
</ul>
<a name="id3"></a>
<h3><a class="toc-backref" href="#id11">11.0.1.0.1 (2018-09-18)</a></h3>
<ul>
<li><p class="first">Fix <cite>undefined</cite> in x2m fields</p>
<p>Before this patch, when searching with the "equals to" operator in any
x2many field, the searched parameter was always <cite>undefined</cite>.</p>
<p>The problem was that the underlying field manager implementation was
treating those fields as x2many, while the widget used was the <cite>one2many</cite>
one.</p>
<p>This patch simply mocks the underlying fake record to make think that
any relational field is always a <cite>one2many</cite>. This sets all pieces in
place and makes the field manager work as expected, and thus you can
search as expected too.</p>
</li>
<li><p class="first">Make linter happy</p>
<p>[Yajo]</p>
</li>
</ul>
<a name="id4"></a>
<h3><a class="toc-backref" href="#id12">11.0.1.0.0 (2018-07-20)</a></h3>
<ul>
<li><p class="first">Rename, refactor, migrate to v11</p>
<p>[Yajo]</p>
</li>
</ul>
<a name="bug-tracker"></a>
<h2><a class="toc-backref" href="#id13">Bug Tracker</a></h2>
<p>Bugs are tracked on <a class="reference external" href="https://github.com/OCA/web/issues">GitHub Issues</a>.
In case of trouble, please check there if your issue has already been reported.
If you spotted it first, help us smashing it by providing a detailed and welcomed
<a class="reference external" href="https://github.com/OCA/web/issues/new?body=module:%20web_advanced_search%0Aversion:%2014.0%0A%0A**Steps%20to%20reproduce**%0A-%20...%0A%0A**Current%20behavior**%0A%0A**Expected%20behavior**">feedback</a>.</p>
<p>Do not contact contributors directly about support or help with technical issues.</p>
<a name="credits"></a>
<h2><a class="toc-backref" href="#id14">Credits</a></h2>
<a name="authors"></a>
<h3><a class="toc-backref" href="#id15">Authors</a></h3>
<ul class="simple">
<li>Therp BV</li>
<li>Tecnativa</li>
</ul>
<a name="contributors"></a>
<h3><a class="toc-backref" href="#id16">Contributors</a></h3>
<ul class="simple">
<li>Holger Brunn <<a class="reference external" href="mailto:hbrunn@therp.nl">hbrunn@therp.nl</a>></li>
<li>Rami Alwafaie <<a class="reference external" href="mailto:rami.alwafaie@initos.com">rami.alwafaie@initos.com</a>></li>
<li>Jose Mª Bernet <<a class="reference external" href="mailto:josemaria.bernet@guadaltech.es">josemaria.bernet@guadaltech.es</a>></li>
<li>Simone Orsi <<a class="reference external" href="mailto:simone.orsi@camptocamp.com">simone.orsi@camptocamp.com</a>></li>
<li>Dennis Sluijk <<a class="reference external" href="mailto:d.sluijk@onestein.nl">d.sluijk@onestein.nl</a>></li>
<li><a class="reference external" href="https://www.tecnativa.com">Tecnativa</a>:<ul>
<li>Vicent Cubells</li>
<li>Jairo Llopis</li>
<li>Alexandre Díaz</li>
</ul>
</li>
<li><a class="reference external" href="https://www.dynapps.be">DynApps NV</a>:<ul>
<li>Raf Ven</li>
</ul>
</li>
<li><a class="reference external" href="https://therp.nl">Therp BV</a>:<ul>
<li>Ronald Portier</li>
</ul>
</li>
</ul>
<a name="maintainers"></a>
<h3><a class="toc-backref" href="#id17">Maintainers</a></h3>
<p>This module is maintained by the OCA.</p>
<a class="reference external image-reference" href="https://odoo-community.org"><img alt="Odoo Community Association" src="https://odoo-community.org/logo.png" /></a>
<p>OCA, or the Odoo Community Association, is a nonprofit organization whose
mission is to support the collaborative development of Odoo features and
promote its widespread use.</p>
<p>This module is part of the <a class="reference external" href="https://github.com/OCA/web/tree/14.0/web_advanced_search">OCA/web</a> project on GitHub.</p>
<p>You are welcome to contribute. To learn how please visit <a class="reference external" href="https://odoo-community.org/page/Contribute">https://odoo-community.org/page/Contribute</a>.</p>