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

  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.

Tags
The elements that get you up and running in a matter of days, from pre-built content types, to modules, to landing pages.

Content types
Modules
Landing pages
Everything you need to manage and administer content within Brightspot CMS, including plug-and-play integrations.

Dashboards
Authoring content
Workflows
Admin configurations
A guide for installing, supporting and administering code on the Brightspot platform, including integrations requiring developer support to use.

Field types
Content modeling
Rich-text elements
Images