How to query the database independently from the game search
Moderator: Alastair
How to query the database independently from the game search
Example: return BBC Micro games without an attached image.
Thanks.
Thanks.
Re: How to query the database independently from the game se
I don't know if these options are needed for the general user, but I also would like to have options like:
-Which games for the c64 don't have a year, company, author,genre etc
It would make it a lot easier to update the database where needed.
May be more interesting for general users:
-Which games are currently played by others (or not)
-Which games have a rating of 6 and above
Note that even when you rate a game with a 1 the site tells you liked playing it when you look at another game which you also have rated
-Which games for the c64 don't have a year, company, author,genre etc
It would make it a lot easier to update the database where needed.
May be more interesting for general users:
-Which games are currently played by others (or not)
-Which games have a rating of 6 and above
Note that even when you rate a game with a 1 the site tells you liked playing it when you look at another game which you also have rated
Re: How to query the database independently from the game se
Alex, I can't help with most of the queries but you can sort search results tables by year simply by clicking on 'Year' at the top of the year column with a second click reversing the order, as shown in this example for the C64/128.Alex wrote:Which games for the c64 don't have a year, company, author,genre etc
It would make it a lot easier to update the database where needed.
Re: How to query the database independently from the game se
Ok the year was a bad example as you point out correctly this can be done, but I think Aran's point as well as mine is it would be nice to have some more tools of finding information gaps in the database.
- Gunness
- Site Admin
- Posts: 1826
- Joined: Tue Dec 07, 2004 7:04 pm
- Location: Copenhagen, Denmark
- Contact:
Re: How to query the database independently from the game se
The search routine can't handle such queries - but I'll be happy to do an extract from the database and upload it somewhere appropriate. Then you can filter and sort in Excel, Google Docs or what have you. Would that be an option?
Re: How to query the database independently from the game se
It would be for me, but don't hurry because soon I'll be off in search of some inca ruins but after Easter it would be fine.
Re: How to query the database independently from the game se
Yes, that would be good as a one-off. Whichever format is easiest for you is fine for me.
- Gunness
- Site Admin
- Posts: 1826
- Joined: Tue Dec 07, 2004 7:04 pm
- Location: Copenhagen, Denmark
- Contact:
Re: How to query the database independently from the game se
Oh but you can't - there are 320 entries in the queue and as you know, you're not allowed to go off on irregular activities until such entries have been removed!Alex wrote:It would be for me, but don't hurry because soon I'll be off in search of some inca ruins but after Easter it would be fine.
.... but have a nice trip anyway
Re: How to query the database independently from the game se
Luckily trekking through Bolivia isn't an irregular activity for meGunness wrote: you're not allowed to go off on irregular activities until such entries have been removed!
Thank you, but I'm still around for a few more weeks, just very occupied in the ultimate preparations.