Advanced search with aggregations

[Raffa]

Hi all

I have to create a page where I insert some cascade combobox  that fill dynamically through which I perform aggregations on the db records.

For example I want to know how many pants I still have in all Italian stores. I select from the combobox that contains the field "area" the "Italia" value, then I click on "Calculate pants":  the result I get is the sum of the pants of all records with area = Italy.

How can I perform that?

Thank in advance

Raffaella

[M Hashmi]

Kindly provide some details like what are your models so people can understand what you are trying to do according to the available models.

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django...@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/98495fe4-258a-41c8-a57d-f1e1cecc63cf%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[C. Kirby]

Hi Raffa,
I've built a third-party app that builds an "advanced search" style form. From the posted form it builds an query against your model which you can then aggregate on (either statically with a defined field, or you could provide a second for asking which field the user would like to aggregate on).

You can find the project at https://github.com/ckirby/django-modelqueryform (with docs on readthedocs and published to pypi)

Take a look at it, I think it will get you pretty close to where you want to be.

[Raffa]

Hi Kirby, unfortunately my project is developed on Django 1.6, I have to upgrade it....

But I think that your project is good for me.  I'll try it. Many thanks!