Skip to content
New issue

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

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

Already on GitHub? # 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
# for free to join this conversation on GitHub. Already have an account? # to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant