Use the "And" or "Or" Logic on Filters in Reports
As it stand, the Reporting feature only supports the "And" logic when adding filters to a report. This is a request to have the option to use the "Or" logic when having multiple filters.
We know it’s been two years since the last update to this suggestion, so it feels like we need to update it.
We still would like to do it, but the effort investment is quite large and we feel like it is better put in working toward a tool that is better suited to support the modern workplace than to improve our current reporting tooling which works quite well.
We do keep this initiative close as we still want to do it eventually, not just in a near future.
It would be very nice to be able to, in one report, locate all video files in different formats/extensions within a site collection. Customers have multiple video files throughout their site collection in none asset libraries which in SP 2013 On premise was not a big deal but now they are in the cloud, they need to be all moved to a asset library. However, now I know I need to do one report at a time.
Scott T commented
I support adding this important functionality to ShareGate
This would be really helpful as for us to work around it we at our company are having to rename a lot of things in SharePoint in sometimes weird ways to get reports to pull what we want. The correct way is to add the or logic in the reports.
Would like the ability to user AND or OR on filters for reports.
e.g. Searching for users from multiple domains that have permissions on sites. Using User object type and filter is Account Contains. Seems to automatically use AND but would like to use OR on multiple filters.
There is already a possibility to search for documents using a specific type of extension with Sharegate. Simply create a new report with the Object type "Documents" then use the "File extension" filter.
But from what I can see, your scenario would need a "OR" logic (ex: docx or pdf or xls). Therefore I will merge your suggestion with the appropriate one.
Matt Hawkins commented
When creating a report it would be good to be able to specify criteria using OR logic.
For example I've got 2 reports to find filenames with Comma or Plus characters. It would be good to create a report that would find files with either Comma OR Plus characters.
At the moment I have to run two reports separately.
After more than a year: What is the state of implementation of this essential feature?
Being able to find .docx, .js, etc..
Now if you write .docx or .js you won't get results
if you run a report with "docx" "js" you will get results
I would like to be able to make a report using OR. For example: I want to find all documents with Passport in the name, OR with License in the name OR with Identification in the name.
Next to that, I would like to be able to start multiple reports to run on one Site collection. We do a lot of capacity management reporting and for every site collection I now need to click a lot to run the 20 different reports. It would be great to be able to select the different reports, select the site collection once - and get an excel file with all the information.
I opened a ticket for this question, and got the response that the functionality is not available in reporting currently. My question was how to put an OR criteria into a report. For instance documents created OR modified by a user.