Search the Knowledge Base Report a bug
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.   printer-friendly view   .    ArchiCAD-Talk Forum Index >>> Tips and Tricks >>> AC 13+ Logical Expressions in Schedule Criteria (and Find)
View previous topic :: View next topic
Author Message
Karl Ottenstein
Moderator
Moderator

Joined: 28 Oct 2003
Posts: 7770
Location: Bozeman, Montana USA

PostPosted: Sun Sep 06, 2009 6:44 pm    Post subject: AC 13+ Logical Expressions in Schedule Criteria (and Find) Reply with quote

ArchiCAD 13 has strengthened the interactive schedule criteria (and find) panel to allow parenthesized logical expressions that use both the AND and OR operators - not just AND as in prior versions - and which allow criteria fields to be re-used arbitrarily.

With this new power, comes the possibility for remarkable things - but also (a) potential confusion about how to express a query, and (b) potential errors from not understanding full boolean logic.

Anyone who had Logic 101 or who has done software programming need not read further.

Otherwise, take a look at this Wikipedia article:
http://en.wikipedia.org/wiki/Boolean_logic
and in particular the section on Properties.

I'll rewrite a few of those formulas here, using ArchiCAD terms to make them familiar.

The most important things that are likely new to many users are:

de Morgan's laws - distributing a unary 'not'

Suppose you want to filter all elements which, among other things, are on any story other than stories 1 and 2:

Quote:
NOT (story=1 OR story=2)

is the same as

(story <> 1) AND (story <> 2)


In ArchiCAD, we do not have a unary NOT operator as in the first expression, so we need another way of expressing it. De Morgan's laws give that to us. So if you think in terms of the first expression as you come up with your query, it is the second, equivalent one that you would actually enter.

In ArchiCAD, the parentheses would be entered like this:

Code:
(story <> 1 and
story <> 2 )


The other case of de Morgan's laws is illustrated here, where we want to filter elements other than those that are on Story 1 and have their ID set to "x":

Quote:
NOT (story=1 AND ElementID="x")

is the same as

(story <> 1) OR (ElementID <> "x")


In ArchiCAD, the parentheses would actually be entered like this:

Code:
(story <> 1 or
Element ID is not x )


Distributivity and other properties listed on that Wiki page will also be of interest.

The potential for errors is great in ArchiCAD 13 and above. You have the possibility to ask for things like walls with height = 3m AND height = 4m, which of course can not match any walls.

But, the potential for improved scheduling, and element location (and reservation for Teamwork), is just tremendous.

Cheers,.
Karl



de_morgan.png
 Description:
First example as seen in the Scheme Settings dialog ... if filtering for walls.
 Filesize:  19.04 KB
 Viewed:  822 Time(s)

de_morgan.png



_________________
AC 20 US, Artlantis 5, Adobe CS 6, Piranesi 6, Final Cut Pro X, etc.
8 Core 2.8 Mac Pro/12GB RAM, SSD, ATI 5770/1GB, 27" LED Cinema/Dell U2415: OS 10.11.6


Last edited by Karl Ottenstein on Sun Sep 06, 2009 9:47 pm; edited 4 times in total
Back to top
View user's profile Send private message    
Karl Ottenstein
Moderator
Moderator

Joined: 28 Oct 2003
Posts: 7770
Location: Bozeman, Montana USA

PostPosted: Sun Sep 06, 2009 6:50 pm    Post subject: Re: AC 13+ Logical Expressions in Schedule Criteria (and Fin Reply with quote

Attached is a screenshot of the new Find and Select dialog in 13, showing the same use of de Morgan's law as in the last example.

Annoyingly, we still cannot filter by Story in this dialog (the Scheme Settings allow much more powerful filtering ... and so remain a superior method for simply locating certain kinds of elements).

So, in the screenshot, I use the layer field to illustrate. Note that there are no parentheses in Find and Select. This also limits its power compared to Scheme Settings as you do not have full boolean logic here. All comparisons related to any particular field must be adjacent and are assumed to be enclosed in parentheses.



find_and_select.png
 Description:
 Filesize:  16.28 KB
 Viewed:  776 Time(s)

find_and_select.png



_________________
AC 20 US, Artlantis 5, Adobe CS 6, Piranesi 6, Final Cut Pro X, etc.
8 Core 2.8 Mac Pro/12GB RAM, SSD, ATI 5770/1GB, 27" LED Cinema/Dell U2415: OS 10.11.6
Back to top
View user's profile Send private message    
Display posts from previous:   
View previous topic :: View next topic
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.   printer-friendly view       ArchiCAD-Talk Forum Index >>> Tips and Tricks >>> AC 13+ Logical Expressions in Schedule Criteria (and Find) All times are GMT + 1 Hour
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum


Powered by phpBB 2001, 2005 phpBB Group
Copyright 2012 - Graphisoft SE. All rights reserved worldwide. Terms of Use | Privacy Policy