Jeremiah Russell Posted December 28, 2018 Share Posted December 28, 2018 Good evening everyone. I'm hoping this is an easy one for the group. I need to segregate my window schedules by building and by floor. For example, my window tags are labeled W1-101, W8-101, etc. I need to have a window schedule that only populates the W1 windows, then another for the W8, etc. I added a criteria for Field Value, ID Prefix (under windows), but it won't remove the others. It brings them all in for that floor. Any thoughts? Thanks! Quote Link to comment
Pat Stanford Posted December 28, 2018 Share Posted December 28, 2018 If it is showing more than you expect, then you did not get the criteria correct. When you say set the criteria you mean you are right clicking on the database header row and choosing Edit Criteria? What are the criteria you are setting? Layer is "your layer" Field Value "ID Prefix" is "W1-" Since the option is for the field value EQUAL to what you type in, make sure you include the dash. Can you screen shot your criteria and post it for us to take a look at? Quote Link to comment
Jeremiah Russell Posted December 28, 2018 Author Share Posted December 28, 2018 Pat, thanks for your response. What you've described is what I have in my criteria. See screenshots of criteria and result attached. I appreciate your help! Quote Link to comment
Jeremiah Russell Posted December 28, 2018 Author Share Posted December 28, 2018 I figured it out. The stacked order of my criteria was wrong. I deleted the 'Field Value-On Schedule' criteria and kept the ID Prefix criteria. Works great! Now to create individual schedules for 10 buildings and 4 floors....*bangs head on desk*. Quote Link to comment
Pat Stanford Posted December 28, 2018 Share Posted December 28, 2018 Yep. Remember that all items with the same criteria type are OR'd together. So your screen shot says give me all of the windows whose OnSchedule OR IDPrefix is 'W1-' If you really need to be this complicated, you can manually edit the criteria in the data bar, but you will lose the ability to edit using the criteria builder. After you edit the criteria and click OK to the criteria builder dialog box, take a look at the data bar. When I do that with a slightly simpler set of criteria (only one layer), I get Quote =DATABASE(((L='Design Layer-1') & (R IN ['Window']) & (('Window'.'IDPrefix'='W1-') | ('Window'.'OnSchedule'=TRUE)))) Notice the vertical bar character between the IDPrefix and OnSchedule sections of the criteria. That specifies the logical OR function. That means the criteria will return every window on Design Layer-1 which has the OnSchedule checked OR has a prefix of 'W1-'. Click in the data bar and edit the formula to replace the vertical bar with a '&' ampersand and you will now only get windows that are BOTH On Schedule AND have a prefix of 'W1-'. It used to be that if you tried to edit a criteria that had been manually edited you would get a warning that you could not use the criteria builder. In VW2019, it appears that the criteria builder will open an just overwrite any manual changes you have made, so be careful. 1 Quote Link to comment
Jeremiah Russell Posted December 28, 2018 Author Share Posted December 28, 2018 Pat, thank you! I actually didn't need the "on schedule" criteria, so it's gone now. The way I have to build the windows is complicated, so only those that will be on the schedule are checked in the OIP. Everything else is left off. This was an interesting learning experience. I appreciate your help! Cheers. 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.