Door schedule disorder

[P Retondo]

My window schedule has automatically sorted the windows based on ID label number. My door schedule seems to be randomly sorted - is there any way to cause it to sort on the ID label?

[Robert Anderson]

Pete, to learn how to sort worksheets, go to the "Worksheet commands" page of the VectorWorks online help. All is revealed. (And, if you don't mind, submit this as a bug.) Thanks!

[wezelboy]

If you click on the database header line, there should be little sort icons in the worksheet tool bar. You just drag one of these to the column you want to sort on.

[P Retondo]

Robert and wezel, thanks - got it!

One final question. Now that I can see my doors in order, I find that doors which are incorporated into a symbol have tags on the drawing, but they don't show up in the schedule. The criteria argument for the database is:

=DATABASE(((R IN ['Door']) & (Door.OnSched=TRUE)))

How do I edit this to include door objects with ID tags that are part of a symbol in a wall? My workaround is to copy the door PIO instance to another layer.

[Robert Anderson]

Try the following:

=DATABASE(((R IN ['Door']) & (Door.OnSched=TRUE))&INSYMBOL)

[wezelboy]

How do you get your door in symbol to have a unique tag? Or are you scheduling by general type?

[Robert Anderson]

If you are using symbols, you have to be using type-scheduling.

[wezelboy]

Exactly. That's why I was wondering. :-)

[P Retondo]

The symbols are unique. I use them when I have to add a non-standard muntin pattern to the PIO instance.

Robert, thanks for the tip. I had considered doing exactly that but my uncertainty regarding how "&" and "|" are processed stopped me. By the way, the worksheet automatically rearranged the argument as follows:

=DATABASE((INSYMBOL & (R IN ['Door']) & (Door.OnSched=TRUE)))

Also, this spontaneously caused the sorting to revert to the previous random arrangement, and I had to reapply sorting to the ID Label column.

Could you explain when "&" acts as an inclusive versus exclusive operator? It seems to me in the above argument that the first "&" is inclusive, while the second operates to exclude those objects for which the statement is false.

[Robert Anderson]

Insymbol is kind of a misnomer. It means, to VectorWorks, "look inside of symbols as long as you're looking..."

Remember that it's a criteria, which doesn't strictly follow Boolean logic.

HTH.