why are empty windows and doors showing up?

[Dave Brach]

I am trying to get my window schedule to show all doors and windows, but NOT show empty doors and windows, doors and windows with an ID of "*", and doors with a letter as an ID (the interior doors all have letters). Everything is working except the empty doors and windows are showing up on the schedule, and I cannot figure out why???

[Karl Ottenstein]

Wow. That's some criteria. 😉

I cannot remember if there is an operator precedence enforced in the Criteria window (e.g. - 'and' binding tighter than 'or') - but go ahead and try putting the three window conditions inside one set of parentheses (click in the left paren column for the first criteria and the right paren column for the 3rd) - and do the same for the three door conditions. Should work then?

Cheers,
Karl

[Karl Ottenstein]

Without testing, but reading the manual, I think the parentheses should do the trick. The Reference Guide says the following:

The and/or operator determines the relationship between adjacent criteria

which means that there is no default grouping (precedence).

You should also have parentheses grouping the four 'ID starts with' tests together if I'm seeing straight. 😉

I think you want generically these parentheses:

((window-criteria) OR (door-criteria)) AND (ID starts with 0, 1, 2, 3)

note that the window OR door is itself grouped so that the AND applies to the group, not just to doors....although maybe the numeric ID prefix does only apply to doors...