How to Display Jobs Where Any One of Several Properties Is Missing (OR Logic in Selections)?

The situation

Maintmaster 8 selections apply AND logic when you add multiple conditions — meaning a job must meet all conditions to appear. This is useful in most cases, but sometimes you want OR logic: show a job if any one of several conditions is true.

A common example is tracking completion of extended properties. You might want to see all jobs where property A, property B, or property C has not been filled in — rather than only jobs where all three are missing at once.

This article explains how to achieve that using a two-selection approach.

How it works

The trick is to build the logic in reverse:

1. Create a helper selection that finds jobs where all the properties are filled in.
2. Create a working selection that shows jobs not in the helper — in other words, jobs where at least one property is still empty.

Maintmaster 8 runs the helper selection automatically in the background whenever the working selection is opened. You only ever interact with the working selection.

Step by Step

Step 1 — Create the helper selection

This selection identifies jobs where all the relevant properties are complete. It runs in the background and does not need to be visible to users.

1. Go to Settings → Selections and create a new Jobs selection.
2. Give it a descriptive internal name, for example: "XP Properties — All Complete (helper)".
3. In General Settings, do not assign any roles under Assigned to roles and users — this keeps it out of user menus.
4. Click the Conditions tab.
5. In the search box, type the name of your first extended property and select it from the list.
6. In the operator dropdown on the right, select "Is not empty".
7. Repeat steps 5–6 for each additional property you want to check.
8. Save and close.

This selection will now show only jobs where every one of the specified properties has been filled in.

Note: The helper selection will appear under the same selection group as your other selections. Since no roles are assigned to it, it will not be visible to regular users — only administrators will see it in Settings.

Step 2 — Create the working selection

This is the selection users will actually see and use.

1. Go to Settings → Selections and create a new Jobs selection.
2. Give it the name you want users to see in their menu.
3. Assign it to the appropriate roles under General Settings → Assigned to roles and users.
4. Click the Conditions tab.
5. In the search box, search for a job reference field (such as "Job number") and select it.
6. In the operator dropdown, select "Not in Selection".
7. A second field will appear — select the helper selection you created in Step 1.
8. Save and close.

Result

The working selection will show all jobs that are not in the helper selection — meaning any job where at least one of the specified properties is still empty. This is the OR behaviour: the job appears if property A or property B or property C is missing.

Maintenance

If you add a new extended property to the check in future, open the helper selection and add a new "Is not empty" condition for that property. The working selection will automatically reflect the change the next time it is opened.

• Creating and editing selections
• Using extended properties on jobs
• Condition types in Maintmaster 8