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.

Our robust, flexible Design System provides hundreds of pre-built components you can use to build the presentation layer of your dreams.

Asset types
Module types
Page types
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