<former librarian, current SQL DBA>Could they maybe update this with "packs to include"/"packs to exclude" and then we could choose whether we want anything with the word X in it (perhaps using pack Y) regardless of packs, and whether to exclude packs we don't own? IOW both an inclusive and exclusive function?</former librarian, current SQL DBA>
select * from gallery
where (description like '$X$' and packs in ('Y'))
and packs not in ('Z','V','A')
(I mean, I get that if you're using a relational database it's more complicated than that and you have a user table, a pack table, etc., but you know.)
Example of what I mean: Let's say that I don't like the Amicable Acolytes' house in Glimmerbrook and would like to replace it with a house in the gallery. I want my search to include Realm of Magic so it'll feel cohesive with the rest of the neighborhood, but I don't own Dine Out or Strangerville and I don't want to see things with those packs. I would like to search for "Amicable Acolytes" or something like that so I get houses designed for that lot, include Realm of Magic, and EXCLUDE Dine Out and Strangerville.
Right now, the way it works is similar to as described except that there's no exclude function. I think that's what's missing.
Edit: https://answers.ea.com/t5/General-Discussion-Feedback/Feature-request-include-exclude-packs-in-Gallery-search/m-p/11383499#M60918
