Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Ability to filter rows & columns for admin views #1032

Open
4 tasks
scarroll32 opened this issue Oct 22, 2018 · 0 comments
Open
4 tasks

Ability to filter rows & columns for admin views #1032

scarroll32 opened this issue Oct 22, 2018 · 0 comments

Comments

@scarroll32
Copy link
Contributor

scarroll32 commented Oct 22, 2018

  • then export as CSV
  • sort by fields
  • Leaderboard needs a round filter
  • A precanned top-n report for multi-challenges would also be useful (with parameters), eg:
SELECT 
l.row_num, 
p.name, 
p.email,
c.challenge, 
r.challenge_round, 
r.challenge_id, 
r.id 
FROM  
challenge_rounds r, 
challenges c,
leaderboards l,
participants p
WHERE c.id = r.challenge_id
AND r.challenge_id IN (31,28,40,39) 
AND r.id IN (47,55,57,56)
AND l.participant_id = p.id
AND l.challenge_round_id = r.id
AND l.challenge_id = r.challenge_id
ORDER BY 4,1

@scarroll32 scarroll32 self-assigned this Oct 22, 2018
@scarroll32 scarroll32 removed their assignment May 28, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant