Hall of Fame Ad-Hoc Query page

[cabert]

Doing the counts isn't hard with sql but I figured you liked doing the report each update.

actually I like looking at the tables and seeing that they fill up nicely.
But I wouldn't be angry if the table gave the info out without any action on my part.

 

[Misotu]

Well, I always check your #1 thread Cabert. It's nice to have the reminder

The ad hoc query tool is *so* useful, it's brilliant. I've been using it a lot over the last few days - it's just excellent.

Um. I wonder. Several times recently I've only wanted to look at BtS games and you can't do this. You can only choose everything or Vanilla/Warlords. Would it be very hard to enable you to just see BtS? Or would that be huge amounts of work? It's probably not something that the people are crying out for, I know

The other thing is that I looked up this thread intending to post a question and found it had already been answered. It was how to deselect selected options. It's not intuitive and it would be helpful to have some prominent instructions on this on the ad hoc query screen itself (ie at the top of the page, not under the results table) and also instructions on selecting multiple options (which I had *no* idea would be possible! What a great option). Anyone fresh to the site wouldn't realise that this could be done (unless that person happened to be a software engineer, in which case I suppose it would be obvious But not all of us are from that background ... )

Anyway, the tool is brilliant. Thanks ever so

 

[Methos]

It's not intuitive and it would be helpful to have some prominent instructions on this on the ad hoc query screen itself (ie at the top of the page, not under the results table) and also instructions on selecting multiple options

Good point. We'll see about getting that done.

(which I had *no* idea would be possible! What a great option)

The same thing can be done when selecting/deselecting files in your computers folders.

 

[Misotu]

Good point. We'll see about getting that done.

Thanks. I'm sure it will help people to realise what a great tool this is and also (which is the point) really to use it.

The same thing can be done when selecting/deselecting files in your computers folders.

I know, and I use it all the time ... but I just didn't realise that you could apply that to the options in ad hoc queries. The instructions will really help people. Thanks for considering the suggestion.

 

[Denniz]

Um. I wonder. Several times recently I've only wanted to look at BtS games and you can't do this. You can only choose everything or Vanilla/Warlords. Would it be very hard to enable you to just see BtS? Or would that be huge amounts of work? It's probably not something that the people are crying out for, I know

I had forgotten to make that change. Thanks for reminding me. You can now select any expansion.

 

[Kamino]

An additional feature that I would love is a historical #1 list to see the progress of play, and better, to see who make those breakthroughs.

What do you think about ?

 

[Denniz]

An additional feature that I would love is a historical #1 list to see the progress of play, and better, to see who make those breakthroughs.

What do you think about ?

The is a publish date dropdown to look different updates. Is that what you were thinking?

 

[Kamino]

The is a publish date dropdown to look different updates. Is that what you were thinking?

An enhancement :
- only games that were #1 when published (or submitted)
- all in one table

A checkbox "#1 history" would be in the interface.

 

[Denniz]

An enhancement :
- only games that were #1 when published (or submitted)
- all in one table

A checkbox "#1 history" would be in the interface.

There are over 1700 #1 spots. I am afraid that one would be extremely difficult to produce efficiently.

 

[ParadigmShifter]

More enhancement suggestions:

* OCC only filter
* Any non-Ancient start filter (since 100 points up for grabs for best)

 

[Mesix]

Non acnient starts do not genearlly get you 100 points since they compete against ancient starts in the same table. If classical starts were only compared to other classical starts then it would be easy for everyone to get a 200 in the Rock of Ages. As it is now, starting in later eras tends to reduce the Q score rather than being a "up for grabs" hole to fill in the HOF tables.

 

[cabert]

Non acnient starts do not genearlly get you 100 points since they compete against ancient starts in the same table. If classical starts were only compared to other classical starts then it would be easy for everyone to get a 200 in the Rock of Ages. As it is now, starting in later eras tends to reduce the Q score rather than being a "up for grabs" hole to fill in the HOF tables.

I guess he wants to see which non ancient starts hold #1 positions. Those games do compete vs non ancient, but for EQM matters the #1 position may just as well be empty.

 

[m4gill4]

I second the OCC filter, that is a cool setting, and it would be cool if we could compare OCC games directly to other OCC games instead of seeing them ranked against normal games with a modifier or whatnot.

 

[Denniz]

More enhancement suggestions:

* OCC only filter
* Any non-Ancient start filter (since 100 points up for grabs for best)

I guess by "Any non-Ancient start" you mean anything other than an Ancient start. That puzzled me for a bit at first since we have the Era drop down. That is doable. I will look at it.

OCC is a more interesting question. We don't store the game options as separate columns so there is no way to index on a game option. We use a single integer value to store the game options (i.e. each bit represents an option being off/on). A lot of query combinations could be very inefficient (i.e. slow). Not to mention, if I do it for OCC, I will end up doing it for the other games options. It is technially possible but if it slams the database, I would prefer to stay away from it. I will check it out at some point.