search

iftechfoundation / ifdb-suggestion-tracker

Bugs and feature requests for a future IFDB update
10 stars 0 forks source link

Searches that exclude a tag only includes games with tags #432

Closed dfabulich closed 6 months ago

dfabulich commented 6 months ago

Find a game listing with no tags. As I write this, https://ifdb.org/viewgame?id=nmqnzyi8iiwatwrt has no tags.

select id from games left join gametags on gameid=games.id where gameid is null order by created desc limit 1;

You can also go to the Browse page, sort by Newest Listing First https://ifdb.org/search?sortby=lnew&searchfor=&browse=1 and find a few candidates.

Search for the game by name. The game comes right up. https://ifdb.org/search?searchbar=Mondes+r%EAv%E9s Search for it excluding a tag, e.g. tramway -tag:horror. https://ifdb.org/search?searchfor=Mondes+r%EAv%E9s+-tag%3Ahorror

Expected: The game should come up, because it isn't tagged horror. Actual: The game is missing from search results.

dfabulich commented 6 months ago

Fixed in https://github.com/iftechfoundation/ifdb/pull/285