'Do Not Include' option for 'Search' based criteria

70 votes

You can build searches that are made up of other searches, but you can't exclude events that are in a particular search. Where I would find this helpful is when I want my final search to include all events EXCEPT those that are missing space assignments. (So build the search for the events missing the space assignments, but then exclude those from the bigger search.)

Done ** 25Live Pro Search Criteria Searching Suggested by: Mike C (CollegeNET) (22 May, '20) • Upvoted: 01 Nov, '23 • Comments: 13

Comments: 13

15 Jul, '20
Roseanne Shaw Admin Merged
Custom attribute values can be searched with the following operators:

-contains
-is equal to
-starts with

as well as two general checks for "exists" and "does not exist". But there is nothing that allows a user to exclude a specific custom attribute value from search results.
23 Jul, '20
Pamela Mason Merged
To be more in line with current verbiage this should be called Does Not contain.
10 Aug, '20
J. Brent Morrison
I would upvote this twice if I could.
04 Sep, '20
sean samis
I've been programming for -- like-- 40 years. I cannot see how this filtering can be all that difficult.
15 Jan, '21
Jennifer Kirby Indiana University
This would be very helpful for the location search as well. Ability to exclude specific locations in the search.
20 Jan, '21
Michelle Bright (Indiana University)
This would be very helpful for those of us with lots and lots of data! Pretty please?
10 Feb, '21
Mike C (CollegeNET) Admin
""Does not include" search criterion for custom attributes" (suggested by Wes H (CollegeNET) on 2020-07-15), including upvotes (9) and comments (1), was merged into this suggestion.
15 Feb, '21
Mike C (CollegeNET) Admin
The ability to not include the results of another space search would be very nice. I'd really like to see the option to exclude any time we provide the option to include ALL or ANY.
28 May, '21
Michelle Bright Merged
As I'm setting up some advanced searches for users, it has become apparent that it would be helpful to be able to designate "not" in some situations. For example, bring back all rooms in a building EXCEPT for keyword "Conference". Otherwise I'm spending a lot of time copying and pasting room numbers into a very long SeriesQL string.
28 May, '21
Maggie Admin
"Advanced searching - add ability to include "not" in query" (suggested by Michelle Bright on 2021-05-28), including upvotes (1) and comments (0), was merged into this suggestion.
04 Aug, '21
Ayodele Bond
This would be a huge help. I would also like to see this for locations. I also use SeriesQL as a work around but not everyone in my organization has the time to do so.
25 Aug, '21
Pam Lau
Yes, having the ability to "do not include" would be very helpful. I just ran into this issue this weekend when running end of term/ beginning term reports. A new building was being built, but not usable yet for the Summer term. Running reports with All spaces produced the new building in the set, however, the building didn't have occupancy yet for Summer term. Would have been great to have all rooms except that 1 building.
When doing events it also would be great to include all sections but "do not include" (for eample) Music 17x2 (where x is any number). :) Thanks for considering this possible feature to "Does Not Include" .
01 Sep, '21
Walt M (CollegeNET) Admin
"Do Not Include in Specific Location Search when using Advanced Search" (suggested by Sarah Barber on 2021-08-24), including upvotes (1) and comments (0), was merged into this suggestion.