{"id":3451,"date":"2026-02-27T23:15:06","date_gmt":"2026-02-28T04:15:06","guid":{"rendered":"https:\/\/www.airsupervision.com\/wp-r\/docs\/organization-staff\/members-center\/advanced-search-button-detailed-user-guide\/"},"modified":"2026-02-28T09:24:40","modified_gmt":"2026-02-28T14:24:40","slug":"advanced-search-button-detailed-user-guide","status":"publish","type":"docs","link":"https:\/\/www.airsupervision.com\/wp-r\/docs\/organization-staff\/members-center\/advanced-search-button-detailed-user-guide\/","title":{"rendered":"Advanced Search Button"},"content":{"rendered":"\n<p>The&nbsp;<strong>Advanced Search<\/strong>&nbsp;button is made for complex filtering when one quick filter is not enough.&nbsp;It lets you combine multiple conditions in one search,&nbsp;including grouped logic&nbsp;(AND\/OR),&nbsp;then reuse that search later as a preset.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.airsupervision.com\/wp-r\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-28-090620-Copie.png\"><img loading=\"lazy\" decoding=\"async\" width=\"457\" height=\"74\" src=\"https:\/\/www.airsupervision.com\/wp-r\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-28-090620-Copie.png\" alt=\"\" class=\"wp-image-3482\" srcset=\"https:\/\/www.airsupervision.com\/wp-r\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-28-090620-Copie.png 457w, https:\/\/www.airsupervision.com\/wp-r\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-28-090620-Copie-300x49.png 300w\" sizes=\"(max-width: 457px) 100vw, 457px\" \/><\/a><figcaption class=\"wp-element-caption\"> Click on Advanced Search button in List navbar<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.airsupervision.com\/wp-r\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-28-091008.png\"><img loading=\"lazy\" decoding=\"async\" width=\"753\" height=\"288\" src=\"https:\/\/www.airsupervision.com\/wp-r\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-28-091008.png\" alt=\"\" class=\"wp-image-3481\" srcset=\"https:\/\/www.airsupervision.com\/wp-r\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-28-091008.png 753w, https:\/\/www.airsupervision.com\/wp-r\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-28-091008-300x115.png 300w\" sizes=\"(max-width: 706px) 89vw, (max-width: 767px) 82vw, 740px\" \/><\/a><figcaption class=\"wp-element-caption\">Advanced Search dialog with field, operator, value, and group controls<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"build-a-multi-condition-search\"><strong>Build a multi-condition search<\/strong><\/h2>\n\n\n\n<ol class=\"wp-r_indent50\">\n<li>Open&nbsp;<strong>Advanced Search<\/strong>.<\/li>\n\n\n\n<li>In the first line, choose:\n<ul>\n<li>the field (for example Name, Group, Inactive, Created date, etc.)<\/li>\n\n\n\n<li>the comparison operator<\/li>\n\n\n\n<li>the value<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Add more lines if needed.<\/li>\n\n\n\n<li>Choose how lines are combined:\n<ul>\n<li><strong>AND<\/strong>: all conditions must be true<\/li>\n\n\n\n<li><strong>OR<\/strong>: at least one condition must be true<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Click&nbsp;<strong>Search<\/strong>&nbsp;to apply.<\/li>\n<\/ol>\n\n\n\n<p>You can also create grouped logic&nbsp;(for example one block for active members,&nbsp;another block for one date range)&nbsp;and combine those blocks with AND\/OR.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.airsupervision.com\/wp-r\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-28-091008-1.png\"><img loading=\"lazy\" decoding=\"async\" width=\"753\" height=\"288\" src=\"https:\/\/www.airsupervision.com\/wp-r\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-28-091008-1.png\" alt=\"\" class=\"wp-image-3484\" srcset=\"https:\/\/www.airsupervision.com\/wp-r\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-28-091008-1.png 753w, https:\/\/www.airsupervision.com\/wp-r\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-28-091008-1-300x115.png 300w\" sizes=\"(max-width: 706px) 89vw, (max-width: 767px) 82vw, 740px\" \/><\/a><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"meaning-of-operators-you-may-see\"><strong>Meaning of operators you may see<\/strong><\/h2>\n\n\n\n<p>The exact operators vary by field type.<br>For example,&nbsp;text fields offer text operators,&nbsp;while date\/number fields offer range operators.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>Operator<\/th><th>Meaning in plain language<\/th><th>Typical use<\/th><\/tr><\/thead><tbody><tr><td><code>eq<\/code> (equals)<\/td><td>Exactly matches value<\/td><td>Find one exact value<\/td><\/tr><tr><td><code>ne<\/code> (not equal)<\/td><td>Different from value<\/td><td>Exclude one exact value<\/td><\/tr><tr><td><code>lt<\/code> (less than)<\/td><td>Smaller\/earlier than value<\/td><td>Dates before X, values below X<\/td><\/tr><tr><td><code>le<\/code> (less or equal)<\/td><td>Smaller than or equal to value<\/td><td>Up to and including a limit<\/td><\/tr><tr><td><code>gt<\/code> (greater than)<\/td><td>Bigger\/later than value<\/td><td>Dates after X, values above X<\/td><\/tr><tr><td><code>ge<\/code> (greater or equal)<\/td><td>Bigger than or equal to value<\/td><td>From a threshold and above<\/td><\/tr><tr><td><code>cn<\/code> (contains)<\/td><td>Text includes this value<\/td><td>Partial name\/email search<\/td><\/tr><tr><td><code>nc<\/code> (not contains)<\/td><td>Text does not include this value<\/td><td>Exclude text fragments<\/td><\/tr><tr><td><code>bw<\/code> (begins with)<\/td><td>Text starts with this value<\/td><td>Surname prefix, code prefix<\/td><\/tr><tr><td><code>bn<\/code> (does not begin with)<\/td><td>Text does not start with value<\/td><td>Exclude prefixes<\/td><\/tr><tr><td><code>ew<\/code> (ends with)<\/td><td>Text ends with this value<\/td><td>Domain endings, suffixes<\/td><\/tr><tr><td><code>en<\/code> (does not end with)<\/td><td>Text does not end with value<\/td><td>Exclude suffixes<\/td><\/tr><tr><td><code>in<\/code> (in list)<\/td><td>Value is in selected list<\/td><td>Multi-choice list filtering<\/td><\/tr><tr><td><code>ni<\/code> (not in list)<\/td><td>Value is not in selected list<\/td><td>Exclude list choices<\/td><\/tr><tr><td><code>nu<\/code> (is empty)<\/td><td>No value present<\/td><td>Missing data checks<\/td><\/tr><tr><td><code>nn<\/code> (is not empty)<\/td><td>Value is present<\/td><td>Data completion checks<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.airsupervision.com\/wp-r\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-28-091604.png\"><img loading=\"lazy\" decoding=\"async\" width=\"288\" height=\"308\" src=\"https:\/\/www.airsupervision.com\/wp-r\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-28-091604.png\" alt=\"\" class=\"wp-image-3486\" srcset=\"https:\/\/www.airsupervision.com\/wp-r\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-28-091604.png 288w, https:\/\/www.airsupervision.com\/wp-r\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-28-091604-281x300.png 281w\" sizes=\"(max-width: 288px) 100vw, 288px\" \/><\/a><figcaption class=\"wp-element-caption\">Operator dropdown expanded for a text field<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"view-the-generated-query-optional\"><strong>View the generated query (optional)<\/strong><\/h2>\n\n\n\n<p>The dialog includes an&nbsp;<strong>SQL<\/strong>&nbsp;view button for advanced users who want to inspect the generated logic.&nbsp;You do not need this for normal daily use,&nbsp;but it helps confirm complex grouped filters.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.airsupervision.com\/wp-r\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-28-091008-Copie.png\"><img loading=\"lazy\" decoding=\"async\" width=\"760\" height=\"288\" src=\"https:\/\/www.airsupervision.com\/wp-r\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-28-091008-Copie.png\" alt=\"\" class=\"wp-image-3489\" srcset=\"https:\/\/www.airsupervision.com\/wp-r\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-28-091008-Copie.png 760w, https:\/\/www.airsupervision.com\/wp-r\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-28-091008-Copie-300x114.png 300w\" sizes=\"(max-width: 706px) 89vw, (max-width: 767px) 82vw, 740px\" \/><\/a><figcaption class=\"wp-element-caption\">SQL\/query preview area in Advanced Search dialog<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"save-a-search-as-a-preset-query-template\"><strong>Save a search as a preset (query template)<\/strong><\/h2>\n\n\n\n<p>If you use the same search regularly,&nbsp;save it once and recall it later.<\/p>\n\n\n\n<ol class=\"wp-r_indent50\">\n<li>Build your filter in Advanced Search.<\/li>\n\n\n\n<li>Click&nbsp;<strong>Save<\/strong>&nbsp;in the left side of the Advanced Search dialog.<\/li>\n\n\n\n<li>Enter a preset name.<\/li>\n\n\n\n<li>Click&nbsp;<strong>Save<\/strong>&nbsp;in the popup.<\/li>\n<\/ol>\n\n\n\n<p>If you already selected a saved preset,&nbsp;you can tick the overwrite option to update that preset instead of creating a new one.<\/p>\n\n\n\n<figure class=\"wp-block-gallery has-nested-images columns-default is-cropped wp-block-gallery-1 is-layout-flex wp-block-gallery-is-layout-flex\">\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.airsupervision.com\/wp-r\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-28-091407.png\"><img loading=\"lazy\" decoding=\"async\" width=\"756\" height=\"295\" data-id=\"3490\" src=\"https:\/\/www.airsupervision.com\/wp-r\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-28-091407.png\" alt=\"\" class=\"wp-image-3490\" srcset=\"https:\/\/www.airsupervision.com\/wp-r\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-28-091407.png 756w, https:\/\/www.airsupervision.com\/wp-r\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-28-091407-300x117.png 300w\" sizes=\"(max-width: 706px) 89vw, (max-width: 767px) 82vw, 740px\" \/><\/a><figcaption class=\"wp-element-caption\">Save query<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.airsupervision.com\/wp-r\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-28-091441.png\"><img loading=\"lazy\" decoding=\"async\" width=\"420\" height=\"174\" data-id=\"3491\" src=\"https:\/\/www.airsupervision.com\/wp-r\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-28-091441.png\" alt=\"\" class=\"wp-image-3491\" srcset=\"https:\/\/www.airsupervision.com\/wp-r\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-28-091441.png 420w, https:\/\/www.airsupervision.com\/wp-r\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-28-091441-300x124.png 300w\" sizes=\"(max-width: 420px) 100vw, 420px\" \/><\/a><figcaption class=\"wp-element-caption\">Load query<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.airsupervision.com\/wp-r\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-28-091943.png\"><img loading=\"lazy\" decoding=\"async\" width=\"639\" height=\"286\" data-id=\"3492\" src=\"https:\/\/www.airsupervision.com\/wp-r\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-28-091943.png\" alt=\"\" class=\"wp-image-3492\" srcset=\"https:\/\/www.airsupervision.com\/wp-r\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-28-091943.png 639w, https:\/\/www.airsupervision.com\/wp-r\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-28-091943-300x134.png 300w\" sizes=\"(max-width: 639px) 100vw, 639px\" \/><\/a><figcaption class=\"wp-element-caption\">Overwrite or new query<\/figcaption><\/figure>\n<\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"recall-and-reuse-a-saved-preset\"><strong>Recall and reuse a saved preset<\/strong><\/h2>\n\n\n\n<ol class=\"wp-r_indent50\">\n<li>Open&nbsp;<strong>Advanced Search<\/strong>.<\/li>\n\n\n\n<li>In&nbsp;<strong>List of saved queries<\/strong>, choose the preset you want.<\/li>\n\n\n\n<li>Verify conditions loaded in the dialog.<\/li>\n\n\n\n<li>Click&nbsp;<strong>Search<\/strong>.<\/li>\n<\/ol>\n\n\n\n<p>Saved presets are personal&nbsp;(linked to your account)&nbsp;for this page.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"delete-a-preset\"><strong>Delete a preset<\/strong><\/h2>\n\n\n\n<ol class=\"wp-r_indent50\">\n<li>Open&nbsp;<strong>Advanced Search<\/strong>.<\/li>\n\n\n\n<li>Select the preset in&nbsp;<strong>List of saved queries<\/strong>.<\/li>\n\n\n\n<li>Click&nbsp;<strong>Delete<\/strong>.<\/li>\n\n\n\n<li>Confirm deletion.<\/li>\n<\/ol>\n\n\n\n<p>Only custom saved presets can be deleted&nbsp;(not the default entry).<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"resetclear-behavior\"><strong>Reset\/Clear behavior<\/strong><\/h2>\n\n\n\n<ul class=\"wp-r_indent50\">\n<li><strong>Clear<\/strong>&nbsp;removes conditions currently set in the Advanced Search dialog.<\/li>\n\n\n\n<li>If filters are already active in the grid, use the List navbar&nbsp;<strong>Clear all filters and refresh<\/strong>&nbsp;button to fully reset the displayed list.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.airsupervision.com\/wp-r\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-28-090620-Copie-2.png\"><img loading=\"lazy\" decoding=\"async\" width=\"457\" height=\"74\" src=\"https:\/\/www.airsupervision.com\/wp-r\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-28-090620-Copie-2.png\" alt=\"\" class=\"wp-image-3496\" srcset=\"https:\/\/www.airsupervision.com\/wp-r\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-28-090620-Copie-2.png 457w, https:\/\/www.airsupervision.com\/wp-r\/wp-content\/uploads\/2026\/02\/Capture-decran-2026-02-28-090620-Copie-2-300x49.png 300w\" sizes=\"(max-width: 457px) 100vw, 457px\" \/><\/a><figcaption class=\"wp-element-caption\">Clear all filters and refresh<\/figcaption><\/figure>\n","protected":false},"featured_media":0,"parent":3397,"menu_order":2,"template":"","doc_tag":[],"_links":{"self":[{"href":"https:\/\/www.airsupervision.com\/wp-r\/wp-json\/wp\/v2\/docs\/3451"}],"collection":[{"href":"https:\/\/www.airsupervision.com\/wp-r\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/www.airsupervision.com\/wp-r\/wp-json\/wp\/v2\/types\/docs"}],"version-history":[{"count":9,"href":"https:\/\/www.airsupervision.com\/wp-r\/wp-json\/wp\/v2\/docs\/3451\/revisions"}],"predecessor-version":[{"id":3497,"href":"https:\/\/www.airsupervision.com\/wp-r\/wp-json\/wp\/v2\/docs\/3451\/revisions\/3497"}],"up":[{"embeddable":true,"href":"https:\/\/www.airsupervision.com\/wp-r\/wp-json\/wp\/v2\/docs\/3397"}],"next":[{"title":"Open Member Information","link":"https:\/\/www.airsupervision.com\/wp-r\/docs\/organization-staff\/members-center\/open-member-information\/","href":"https:\/\/www.airsupervision.com\/wp-r\/wp-json\/wp\/v2\/docs\/3414"}],"prev":[{"title":"Search and Navigate in the List","link":"https:\/\/www.airsupervision.com\/wp-r\/docs\/organization-staff\/members-center\/search-and-navigate-in-the-list\/","href":"https:\/\/www.airsupervision.com\/wp-r\/wp-json\/wp\/v2\/docs\/3413"}],"wp:attachment":[{"href":"https:\/\/www.airsupervision.com\/wp-r\/wp-json\/wp\/v2\/media?parent=3451"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/www.airsupervision.com\/wp-r\/wp-json\/wp\/v2\/doc_tag?post=3451"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}