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.

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.