CS1 Posted November 7, 2008 Share Posted November 7, 2008 I have a worksheet with a database. The selection criteria is all objects whose layer is X whose class is Y and whos Record is Z. On layer X there are 5 objects that meet that criteria. There are no VPs on the layer. In the worksheet howvere it brings up results including all the instances on VPs, by this I mean if there are 5 objects on that layer and that layer is shown on 10 viewports it tells me there are 50 objects that meet that criteria. How can i make my criteria more specific??? Quote Link to comment
CS1 Posted November 7, 2008 Author Share Posted November 7, 2008 PS to clarify further, once I have entered the criteria info the "criteria" panel says "objects that meet the criteria" 5", when I click OK and go back to the worksheet there are 50 objects. Quote Link to comment
gmm18 Posted November 7, 2008 Share Posted November 7, 2008 i am assuming the box that says "Including components of: Viewports" is UNchecked... Quote Link to comment
Dieter @ DWorks Posted November 7, 2008 Share Posted November 7, 2008 i am assuming the box that says "Including components of: Viewports" is UNchecked... That button is for SLVP and not for DLVP. worksheets do not treat DLVP as VP but as the objects in the VP like there was no VP. If you think about it, it's all simple and clean: DLVP are there for other reasons that SLVP are. DLVP are meant to show things multiple times and draw them once. So when you draw one room, and that room is 12X in a building, you just use a DLVP to that room 12x in your drawing. If you then make a worksheet, that worksheet will find the objects 12x if the original was in another file and 13x if the original was in the same file. If you want to get rid of them in worksheets and get only the original, then place them on other layers and let the criteria not look on those layers. Quote Link to comment
CS1 Posted November 9, 2008 Author Share Posted November 9, 2008 I have told the worksheet to select only those objects on a particular layer, that layer only has those particluar objects and no VPs. What can I do? Quote Link to comment
Dieter @ DWorks Posted November 10, 2008 Share Posted November 10, 2008 And you still get the objects from the viewports? Then I think you'll need to make a viewport to a layer and set that layer in your criteria. But it's very strange. Quote Link to comment
CS1 Posted November 10, 2008 Author Share Posted November 10, 2008 Yeah I tried that and it seems no matter how specific I am with the layer reference ( layer with only 1 VP, or model with just objects) the criteria pallette says I have Z number of those objects that meet the criteria but when I exit It says I have Z x "number of layers". Hope that makes sense. Quote Link to comment
Vectorworks, Inc Employee Hugues Posted November 10, 2008 Vectorworks, Inc Employee Share Posted November 10, 2008 CS1, This is strange. Try again and double-check to make sure that the worksheet lists only objects that meet the layer criteria. To check that, add a column in the worksheet and enter =L to return the object's layers. Also, are you comparing the results from the Custom Selection command and those from the worksheet database ? You may see differences in the number of objects that meet the criteria. The reason is that because DLVPs objects are not selectable, no search is performed in DLVPs when running Custom Selection. Thanks Hugues NNA Quote Link to comment
CS1 Posted November 10, 2008 Author Share Posted November 10, 2008 Yeah I have checked this. In the column headed "=L" I get a list containing only the one layer name. I also have a column giving me the length and that just hos duplicates of the same value. Basically Im using the worksheet to give me the info for engineered beams. If I have 10 beams named "beam one, beam two etc" and 5 layers. The beams are only on "layer one". And there is one VP on each of the other 4 layers. I get something like the following. Beam 01 5.010m Layer One Beam 01 5.010m Layer One Beam 01 5.010m Layer One Beam 01 5.010m Layer One Beam 01 5.010m Layer One Beam 02 4.090m Layer One Beam 02 4.090m Layer One Beam 02 4.090m Layer One Beam 02 4.090m Layer One Beam 02 4.090m Layer One etc etc etc My criteria for the worksheet says all objects whose layer is "layer one" whose type is "framing member" whose record is "eng". Quote Link to comment
Vectorworks, Inc Employee Hugues Posted November 10, 2008 Vectorworks, Inc Employee Share Posted November 10, 2008 Strange behavior. I have no explanation for that. Please feel free to send me the file and I'll take a look at it. Thanks, Hugues NNA htsafak@nemetschek.net Quote Link to comment
CS1 Posted November 10, 2008 Author Share Posted November 10, 2008 Thanks Hugues, what size file can I send? Quote Link to comment
Jonathan Pickup Posted November 11, 2008 Share Posted November 11, 2008 if you use www.yousendit.com you can send files up to 100mb Quote Link to comment
Dieter @ DWorks Posted November 11, 2008 Share Posted November 11, 2008 Also check if the criteria you see IN the worksheet says '&' and not '|' between the different criteria! I had this once in a file when making criteria and this will result in having all objects from criteria x and all from criteria y. Quote Link to comment
Vectorworks, Inc Employee Hugues Posted November 11, 2008 Vectorworks, Inc Employee Share Posted November 11, 2008 How big is your file ? Quote Link to comment
CS1 Posted November 11, 2008 Author Share Posted November 11, 2008 All good I have been able to replicate in a new file so have just emailed it now and is only around 3Mb. Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.