Labor Insight™ offers many filter options that allow you to report on the postings most relevant to your research. Once you’ve added the filters you’re most interested in, you can use AND and OR controls to narrow and widen your search as necessary.

As a general rule of thumb, OR expands your result set, while AND restricts it.

Let’s take the query below as an example. In the first version, we are searching for jobs in 2019 that request applicants have skill in either Python OR Java: 19,202 postings are returned.

Once we change the OR to an AND, we get a much more limited set of job postings, 3,016, that request skill in both Python AND Java.

Labor Insight usually defaults to using an OR operator between filters from the same category, but you can adjust this as needed in order to refine your search. Remember to hit 'Update' once you have changed the operators in your query.

The following are examples of queries that use a combination of AND/OR functions to refine results. Please consider the following table as the sample:

A or B or C = 10 listings

This query will create a sample pool of listings that contain at least one of the three variables.
​

A and B and C = 3 listings

This query will create a sample pool of listings that contain all the three variables.

(A and B) OR C = 7 listings

This query will create a sample pool of listings that either request both A and B, or listings that request C.

Listings that only request A will not be included if the listing has not also requested B.

Listings that contain all three variables will be included.

If the listing has requested B and C but not A then it will still be included as C is a standalone field.
​

A and (B or C) = 6 listings

This query will create a sample pool of listings that must contain A as well as either B or C.

Listings that only request A will not be included.

Listings that request B or C and not A will not be included.

A and B and not C = 2 listings

This query will create a sample pool of listings that contain both A and B as long as C is not requested.
Listings requesting all three skills will not be included.

Listings that only requests A without B will not be included.

(A and B) OR (C and D) = 6 listings

This query will create a sample pool of listings that contain A with B, or C with D, or all four.

Listings requesting only B and C will not be included as they are not grouped within the brackets.

Listings must contain at least one of the defined variable groups.

(A or B) AND (C or D) = 5 listings

This query will return listings that contain at least one of the variables within each defined skill group.

Listings only requesting A and C will be included.

Listings only requesting A and B will not be included as there needs to be a skill included within each grouping.

​