Worksheet criteria syntax

[MarCur]

I'm trying to make a function that should return me with total length of some walls, by height criteria.

 

but It seems that the height criteria is nowhere.

 

So, I've the walls object laying on the class: Z_Esterni-CORDOLI_CONFINI

some walls are 22 cm and some others 36 cm tall.

 

so I would expect to write down somethin like:

 

=LENGTH((C='Z_Esterni-CORDOLI_CONFINI', 'height=0,220m'))

but it does not work.

 

Any clue?

 

VectorWorks Architect 2023 ITA

[Pat Stanford]

Height (and Width) of Walls can't be used as a criteria.

 

Your best option is probably to attach a record to the walls to specify which are which.  Or make them separate Wall Styles which can be used as criteria.

 

If you go the Record direction, you may be able to use the Data Manager to automatically populate the record.field with the height.

[MarCur]

On 10/20/2023 at 12:01 AM, Pat Stanford said:

Height (and Width) of Walls can't be used as a criteria.

 

Your best option is probably to attach a record to the walls to specify which are which.  Or make them separate Wall Styles which can be used as criteria.

 

If you go the Record direction, you may be able to use the Data Manager to automatically populate the record.field with the height.

Thx Pat,

right before reading your reply I did acknowledge what you said. 

So I bypassed the "criteria" issue by placing different eight walls in different classes.

 

Was considering the record option too but ended up with class choiche.

By your point of view what are the pro and cons of using one method rather than another?

 

P.S.

are you aware of any reason for not allowing for some kind of designelements the use of such parameters like Height (and Width) as criteria in the sheets?

[Pat Stanford]

I BELIVE (my opinion, not based on anything other than programming for a long time) that the main reason you can't use object values as criteria is speed.

 

If you had a big drawing and every time the worksheet had to recalculate it had to look at the object value of every object in the drawing that would likely be a very slow operation. I think that the things that you can make into criteria are (or can be) cached as an index so the overall speed is improved.

 

But then there is the Field Value criteria that kind of blows that idea out of the water.

 

So I don't really know, but my guess is speed.