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:
In the search panel, in the Filters widget, in the Advanced Query field, click . The Advanced Query Builder widget appears.
- From the drop-down list, select
Match All (AND)
. This selection ensures Brightspot retrieves items that match all of the criteria you enter. - Click Add Another Match All (And). A set of fields appears.
Do the following:
- From the top drop-down list, select
Comparison
. - From the next list, select
Article
. - From the next list, select
Any Fields
. - From the next list, select
Contains Text
. - From the next list, enter
Critique
.
- From the top drop-down list, select
- Click
Add Another Match All (AND)
. A new set of fields appears. Do the following:
- From the top list, select
Comparison
. - From the next list, select
Article
. - From the next list, select
Author(s)
. - From the next list, select
Is:
. - Click the selection field, and select
Immanuel Kant
.
- From the top list, select
- Click Search.
The Advanced Query Builder widget closes, and the matching items appear in the search panel.