Filter a Schedule using a logic "OR" instead of "AND"

[IAN~JAMES]

Is there any way of building a schedule that is filtered using a logic "OR" instead of "AND"

We want to schedule out Rooms that satisfy a limited range of parameter values initially just two will do, but it begs the question whether it is possible to filter using a list of acceptable values such as

...Where Parameter.Value IN(ValueA, ValueB, ValueC, ValueD...)

I seem to remember this from SQL many moons ago!

Any suggestions appreciated.

Cheers

[Anonymous]

It's now 2020. How is 'OR' not a function in the schedule properties?? This would be such a simple change. If Autodesk spent as much effort giving users what they want, as they do trying to convince users to go through convoluted roundabout 'solutions', Revit would be as easy to use as an iPhone. How is the most expensive software license in my office also the most frustrating? 

[bastian.malmhaug-solem]

Its now 2021. This should have been addressed. 

[SzyKo]

Maybe it will be done to celebrate a millenium of Revit development by Autodesk in 3002 😋 🤣?

[ToanDN]

You can choose to wait, or you can use a workaround.

[Andre_Malan]

Hi, its 2021, it would be great if we could have an "OR" operator for filtering Schedule Properties! 

[HADENSMITH3534]

I'm not being political here, but just sayin'... "Four more years (NOT)! Four more years (NOT)!

Sorry... I meant to quote this post (which I guess didn't include OR for schedules):

‐‐----------------------

MESSAGE 21 OF 26

 loboarch

 

in reply to: peterchrien

‎02-16-2018 05:29 AM

OR filters are currently being worked on.  Check the Revit Roadmap.

http://blogs.autodesk.com/revit/2017/08/31/revit-roadmap-update-august-2017/

[HADENSMITH3534]

OR filters are currently being worked on.  Check the Revit Roadmap.

http://blogs.autodesk.com/revit/2017/08/31/revit-roadmap-update-august-2017/

[hedbr]

What I did to get around this was to create my view filter in 3D to show only what I want in the schedule; this filtering will allow OR's to be used.

Now you can select everything and add a comment to it.

Next go back to your schedule filter and and the "Comments" field (Note: if you don't want this as a column showing in your table, all you need to do is go to the Formatting tab, select the Comments field, then check the box Hidden Field.

Lastly go back to the Filter tab, filter by Comments with Contains and then type in the same thing you added to all the selected parts.

Hope so this helps!

[JennSen]

Autodesk come on, 11 years since the start of this thread and we're still asking for Or functionality in schedules...

[dyakovenko73GY8]

Are you **** kidding?! 11 years have passed and still no "OR" logical filter for schedules!!!!!!! Guys, really, the quality of your product doesn't corresponds to it's price

[emorrisCX4Z7]

Bump. 

Still looking for OR option in Schedules

[Lance.Coffey · Accepted solution]

The following Revit Idea was posted for this topic: “Or” in filter rules of schedules

If you would like to see this feature implemented, please vote up this idea!

(292 Votes as of 7/19/2022)

If you are interested in other improvements around this area, see the following (Revit Idea) search (for more items to vote on): Schedule AND Filter

[tlagardeAJBTA]

I voted for that function to be implemented but lord, a filter without OR condition seems ridiculous

[malagonEWK87]

This was discussed in 2011 and probably by then it had been requested for years. It is February 2023 and I am just testing with Revit 2023, there is still no way to filter with "OR", I just can not understand this lack of functionality at this software price range

[tlagardeAJBTA]

Nothing new ? Still no "Or" command ?

[ConstantineC]

Is this not in the features yet? Still in Roadmap?

[tlagardeAJBTA]

Yes, we are still waiting on this game changing line of code. Who would have thought that implementing an or parameter would take so long.

[bpl-cz]

Still worked on?

[russellvee]

I only took a couple semesters of programming but I would have probably failed if my projects were missing this many basic features.

[Alfredo_Medina]

I did some research on this, and this is my report: Reading the history of this idea since it was proposed, I see that it was proposed as "OR in filter rules" but the idea did not specify if it was for View Filters or for Schedules or for both. Then in 2016 the status changed to "Under Review", then soon after the status changed to "Approved", then it was implemented in Revit 2019 but only for View Filters. I don't see that "OR" feature for schedules has gone through the same process in the roadmap. And I just checked the current roadmap and I did not see OR for schedules there.

[Rambazamba73]

I think we have to wait until AI takes over the coding...