Jump to content
Sign in to follow this  
JoshW

worksheet criteria for exterior door schedule

Recommended Posts

I am trying to create separate door schedules for interior and exterior doors, but I am having trouble with the criteria settings to get the worksheet to function properly.

The criteria I have currently looks something like this:

Layer is 0-Basement

Record Door is present

Field Value On Schedule = TRUE

Field Value Location = EXTERIOR

It seems that the last piece of criteria is not being used. No matter what I type in for the Location field, it will not cull out the doors that say "interior"

Am I missing something, or should they be in a different order?

Share this post


Link to post

I think this is a problem with the GUI in the database criteria.

The worksheet interprets your criteria like this:

Layer is 0-Basement

AND

Record Door is present

AND

(Field Value On Schedule = TRUE OR Field Value Location = EXTERIOR)

It only needs one field value to be true.

There's no way in the Edit Criteria dialog box to choose if you want both field values or either one.

The way to fix it is to get to that Edit Criteria… dialog box.

Click Cancel.

Look in the formula bar. It will say something like = DATABASE(…

Look for the part that says

(('Door'.'OnSched'=TRUE) | ('Door'.'Location'='Interior'))))

Change the '|' to '&'

[in logic speak, '|' (called a pipe) = OR and '&' (ampersand) = AND]

That will force the database criteria to select doors that have BOTH 'on schedule' and Interior

Keep an eye on it. I haven't kept track of what future changes in the database criteria will cause it to revert back to '|'. But it can happen.

hth

mk

Share this post


Link to post

Thanks!!

I'm glad that's an intuitive and easy to find solution... :/ :tired:

Share this post


Link to post

i think we'll be moving to ifc properties instead of concentrating on data records.

where can i find some explanations on the ifc props in the worksheets/database?

thx in advance.

rob

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

 

7150 Riverwood Drive, Columbia, Maryland 21046, USA   |   Contact Us:   410-290-5114

 

© 2018 Vectorworks, Inc. All Rights Reserved. Vectorworks, Inc. is part of the Nemetschek Group.

×