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

Nice panel in admin to show two-tier categories? #1092

Open
osfameron opened this issue Apr 15, 2015 · 0 comments
Open

Nice panel in admin to show two-tier categories? #1092

osfameron opened this issue Apr 15, 2015 · 0 comments

Comments

@osfameron
Copy link
Contributor

e.g. , if Oxfordshire want to know which categories are sent to a district council, I believe I have to do:

select 
    category,
    array_to_string(array_agg(body_name), ',')
from (
    select
        body.name body_name,
        category
    from contacts c
    join body on body.id=body_id
    where body_id in (2418,2417,2420,2421,2419)
    and c.confirmed
    and not c.deleted
    order by c.category, body.name
) s
group by category;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants