Can't search for unknown platform or media

Posted in

#1 by atlantima
2013-01-20 at 21:46
< report >There are lots of releases with no platform or media specified but it's impossible to do a search for them to easily find and fix them. You can search for unknown age rating/resolution/voicing/etc., so why not unknown platform/media?
#2 by yorhel
2013-01-21 at 12:46
< report >Fixed, you can now search for unknown platform and media, too.

The reason was that a release can have multiple platforms and media, so the filtering question isn't "I want a release for which one of its platforms is x", but "I want a release for which there are no platforms specified at all". This requires some special care in the code. For the other filters, "unknown" is really just a special value: "I want a release where the age rating is unknown" is internally just a very minor modification of "I want a release where the age rating is 18+", so those didn't need much care.Last modified on 2013-01-21 at 12:47
#3 by atlantima
2013-01-21 at 16:43
< report >Thanks.

Although if I check both Unknown and Other platforms, it brings up releases with all platforms.

Speaking of platforms, I was wondering if you might want to add more platform options for some older platforms. For example:

Original XBOX
r1702
r11366
r11367
r11368
r12614
r12616
r24713

Game Boy Color
r218
r219
r7311
r7952
r7953
r7955
r8701

PC-FX
r4248
r8798
r9228
r9232
r12839
r12871
r12896
r17192
r17194
r17200
r17201
r23982

PC-88
r11636
r17962
r18190
r18792
r18811
r18908
r18951
r19001
r19019
r19042
r19044
r19051
r19054
r19055
r19058
r19069Last modified on 2013-01-21 at 18:14
#4 by yorhel
2013-01-21 at 18:30
< report >
Although if I check both Unknown and Other platforms, it brings up releases with all platforms.
Hmm? Are you sure you're not selecting all of them (Unknown and other being at opposite ends of the selection list). If I only select both of them, I get the results I'd expect: releases which have no platform associated, and releases that have an entry for "other".

Judging by the number of releases you've found for those platforms, I'll add those to the list when I have the time.
#5 by atlantima
2013-01-21 at 20:41
< report >I just tried it again and it is working fine. I don't know what the deal was. Maybe I did select them all... Never mind.
#6 by harag
2013-01-21 at 21:14
< report >While we are at the topic of searching. Is there a way to filter characters who are in a VN without an english translation?
#7 by yirba
2013-01-22 at 03:50
< report >Currently there isn't even a way to search for VNs without English translations, let alone searching for characters that belong to them.

This is the sort of situation that I feel being able to perform custom SQL queries would be helpful.

I mean, from a database perspective, all the data is there to do so, but I don't think the web interface currently allows that sort of search operation.

Reply

You must be logged in to reply to this thread.