Issue 78: Advanced Search
Project Member Reported by dmbs...@gmail.com, Feb 5, 2011
Django admin search is good most of the time. However some reports may required a more advanced search with Boolean logic.
Mar 16, 2011
Project Member #1 dmbs...@gmail.com
(No comment was entered for this change.)
Labels: -Milestone-Release1.5 Milestone-Release2.0
Mar 29, 2011
Project Member #2 dmbs...@gmail.com
(No comment was entered for this change.)
Labels: -Priority-Medium Priority-Low
May 7, 2011
Project Member #3 dmbs...@gmail.com
(No comment was entered for this change.)
Labels: -Type-Defect -Priority-Low -Milestone-Release2.0 Type-Enhancement Priority-Medium Milestone-Release2.1
Apr 7, 2012
Project Member #4 dmbs...@gmail.com
Proposed solution:
You can actually do a lot of filtering by manipulating the url. For example ?date__le=2011-10-10
you can string these together and look at sub fields. 

- Create Advanced Filter GUI where user can add ANY field and subfields
--- Overlay, no additional views except to support ajax calls
--- GUI basically translates between url and fields. 
- Some system should check for view or edit permissions on related fields. By default django doesn't give any such permission unless you explicitely mark it allowed in the admin class
- Allow users to save searches (literally the search url) for later usage. If django-admin-export is installed this would allow users to create one click reports directly to xls if desired.

Should be a seperate project but can work with django-admin-export if installed. 

This project will remove the need to have a robust integrated reports system. A skilled user could generate such reports themselves. The report builder will be maintained as a easy to use school specific generator. It will continue to rely on presets.
Apr 7, 2012
Project Member #5 dmbs...@gmail.com
- Should include special field for relative dates when saving reports. Like
date__lt= today - 30 days

We can't put this into the url. We can store it in the database with a translation layer.
Database = 'date__lt=$(TODAY - 30)'     
an ajax view on admin edit would translate this to the actual date to feed into the url. Then reverse this on save. It would detect date fields and add the option for this automatically

Any other special cases? I don't want this to be an everything possible report builder...but a decent one.