| Issue 78: | Advanced Search | |
| 1 person starred this issue and may be notified of changes. | Back to list |
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
Labels:
-Milestone-Release1.5 Milestone-Release2.0
Mar 29, 2011
(No comment was entered for this change.)
Labels:
-Priority-Medium Priority-Low
May 7, 2011
(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
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
- 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. |