Door Schedule Filter - Mark has a value

[zwebber24]

I'm asking out of curiosity, because I know can filter my schedule by other means and get the same result. I'm curious if I've run into a glitch or if there is a hidden behavior I'm unaware of. 

The issue I've found is that if I set a schedule to filter out any doors without a value in the Mark parameter, doors are still showing in the schedule that shouldn't. 

Is Revit still reading a hidden value here that isn't shown? Is this one of those cases where once there's been a value input, deleting said value fails to reset the parameter to null?

I've attached a screenshot for clarity. 

[ToanDN · Accepted solution]

---

@zwebber24 wrote:

Is Revit still reading a hidden value here that isn't shown? Is this one of those cases where once there's been a value input, deleting said value fails to reset the parameter to null?

---

Possibly.  I only use [Has a value] or [Has no value] for non-text field filters.  For text field filters, I use this:

[barthbradley]

Same here.  

Try Does Not Equal blank.

[zwebber24]

hmm... I hadn't considered that it may only work for numerical values. I think I was just surprised to find that a blank parameter was still considered to "have a value" oh well. I'll just chalk it up as another Revit oddity.

Thanks. 

[barthbradley]

I think the behavior is similar to Yes/No Parameters.  It has to be manually activated to be report as a "Yes" or "No".  Until it is "activated", the value is NULL. 

Try this test:

Create a Text-Type Project Parameter named "Mark 2" and assign it to  the Door Category. Then add the "Mark 2" Parameter Field to your Door Schedule and Filter Schedule  using "Mark 2" + "Has no value".  See results.

Next, remove Filter and enter a value into one or more of the Doors' "Mark 2" Parameter Field -- and then turn around and remove the value, leaving the "Mark 2" Field completely blank.  Now Filter again using the same "Mark 2" + "Has no value". See results.