·¬ÇÑÉçÇø

Brightspot CMS User Guide

Performing advanced query search


Using the advanced query builder, you can compose retrievals to almost any level of complexity. For example, the advanced query builder can construct queries in the following MySQL patterns:

SELECT fieldnames WHERE field1 = A;
SELECT fieldnames WHERE field1 = A AND field2 = B;
SELECT fieldnames WHERE field1 = A AND field2 <> B;
SELECT fieldnames WHERE (field1 = A AND field2 = B) OR (field3 LIKE '%philosop%' AND field4 <> D);

The following procedure describes how to build a query that retrieves all articles containing the word Critique and authored by Immanuel Kant.

To perform an advanced query search:

  1. In the search panel, in the Filters widget, in the Advanced Query field, click edit. The Advanced Query Builder widget appears.

    Advanced Query Search.png Advanced Query Search.png

  2. From the drop-down list, select Match All (AND). This selection ensures Brightspot retrieves items that match all of the criteria you enter.
  3. Click Add Another Match All (And). A set of fields appears.
  4. Do the following:

    1. From the top drop-down list, select Comparison.
    2. From the next list, select Article.
    3. From the next list, select Any Fields.
    4. From the next list, select Contains Text.
    5. From the next list, enter Critique.
  5. Click Add Another Match All (AND). A new set of fields appears.
  6. Do the following:

    1. From the top list, select Comparison.
    2. From the next list, select Article.
    3. From the next list, select Author(s).
    4. From the next list, select Is:.
    5. Click the selection field, and select Immanuel Kant.
  7. Click Search.

The Advanced Query Builder widget closes, and the matching items appear in the search panel.

Previous Topic
Using collections as a search filter
Next Topic
Performing integrated searches in Brightspot
Was this topic helpful?
Thanks for your feedback.
Our robust, flexible Design System provides hundreds of pre-built components you can use to build the presentation layer of your dreams.

•
•
•
Brightspot is packaged with content types that get you up and running in a matter of days, including assets, modules and landing pages.

• Content types
• Modules
• Landing pages
Everything you need to know when creating, managing, and administering content within Brightspot CMS.

• Dashboards
• Publishing
• Workflows
• Admin configurations
A guide for installing, supporting, extending, modifying and administering code on the Brightspot platform.

• Field types
• Content modeling
• Rich-text elements
• Images
A guide to configuring Brightspot's library of integrations, including pre-built options and developer-configured extensions.

• Google Analytics
• Shopify
• Apple News