You may remember that we built a multiple-rule search for “people who are leaders at Big Shop” in a previous help article. Imagine that you now need a similar search that will find leaders at either “Big Shop” or “Small Shop”.
The rules in this search might be stated this way:
Find people who…
1. have a leadership role
2. work at Big Shop OR work at Small Shop
Rule #1 is easy (it’s the same as in the earlier multiple rule search article), but rule #2 is really a clause composed of two rules about two different shops. Broadstripes calls such a clause a “group”.
Learn how to build a search with a group in this video:
Video: Add rule groups to your search
Build a search with groups (clauses)
- To get started, click the Advanced button to the right of the search box at the top of the page.
- A search builder panel will appear below the search box.
- We’ll start by creating our three rules first and construct the group last.
- The search builder panel automatically creates a rule as it’s opened. Initially, the panel will offer to search for people by Name, but we’ll change that for our first rule.
- To search for leaders, we’ll select “Leadership role” from the drop-down list on the left just as we did in the Search with multiple rules article.
- In the middle drop-down box, we’ll choose “has any value” to see everyone with a leadership role.
- Next, we need to add our second rule, filtering the results to show leaders at “Big Shop.” (We’ll add a rule to see leaders at “Small Shop” next).
- We’ll add the second rule by clicking the +Add rule button in the upper right corner of the search builder.
- We’ll specify that for this rule Employer (in or below) should contain the words “Big Shop.”
- Next, we’ll add our third rule by clicking the +Add rule button again.
- We’ll specify that we’d also like to see records where Employer (in or below) contains the words “Small Shop.”
- Now we need to create a group for our rules about employment since we want Broadstripes to search for people who are leaders at either “Big Shop” or “Small Shop” (not both).
- To create a new group, the +Add group button in the upper right corner of the search builder. The search builder allows you to add groups wherever you want. (You can even add groups within groups, but let’s not go there right now.)
- You’ll notice that the new group already contains an automatically-generated rule that defaults to search by Name. Delete that rule since it won’t be needed in this search by clicking the red Delete button to the right of the rule drop-down menus.
- Now let’s build the group.
- One at a time, drag and drop the two employment rules into the new group.
- Once you’ve moved both rules into the group, your search panel will look like this:
- We’re almost done, but before running the search, we need to check our boolean operators.
What’s a Boolean operator?
Boolean operators are used in searches to connect and define the relationship between search rules. Broadstripes uses two Boolean operators: AND and OR.
Use “AND” to run a search where all of the rules are true.
Use “OR” to run a search where at least one of the rules is true.
- Since our search depends on people being employed at either “Big Shop” OR “Small Shop” AND having a leadership role, we need our operators to match that.
Above the leadership rule, leave “AND” selected. Click “OR” in the top left corner of the employment rules group to toggle it on (a dark blue background indicates that it’s selected).
Your completed search will look like this:
- Finally, click the Search button to run your search.
- Everyone with a leadership role at either Big Shop or Small Shop will appear in the Search Results panel.
Want to go back to the basics and learn about simple searches or searching with just one or two rules? Check out these articles: