search

wesnoth / wesnoth-multiplayer-data-dashboard

This is a dashboard that allows you to query and visualize data that the Wesnoth Project collects about multiplayer games played on the official server.
2 stars 0 forks source link

Allow filtering on BIT fields #22

Open soliton- opened 2 weeks ago

soliton- commented 2 weeks ago

Currently on http://replays.wesnoth.org/dashboard/query when you filter the table for 0 or 1 in the RELOAD field for example nothing matches. I assume that is because in the DB those fields are not the character 0/1 but the ASCII value 0/1 (i.e. NUL/SOH).

max-torch commented 1 week ago

I was able to get it working using "="

It seems that for categorical type data, simply typing the category suffices (such as the version field), while for numeric data type fields, you have to use operators.

image

Possible to filter for short and long games in the Game Duration

image

soliton- commented 1 week ago

Ok, I didn't try to find the filter documentation. Would be nice if there was a link to it and if it is a bit dense then would be good to add a direct note with some filter examples.

max-torch commented 2 days ago

I do link to the documentation that explains this in the User Guide in the section on Filtering; However, I do agree that it is, in fact, a bit dense to find and understand the information inside the official documentation page, given how it currently looks like and is written.

Thank you so far for this report and discussion and I'll assign this issue to myself.