On Wed, Jul 29, 2009 at 7:36 PM, mike<mkimm...@gmail.com> wrote: > >> I've written an app called django-filter which seems like it may be >> what you want:http://github.com/alex/django-filter/tree/master. >> Here's an example of it in use with a ticketing >> appliation:http://imgur.com/BPpmf.png >> >> Alex > > > Alex, > > Thanks for the input! > > django-filter looks close. However, it appears as django-filter is > based on pre-defined filters for pre-defined querysets, whereas I need > an interface that lets the user define the querysets and > filtersets...on the fly. Is this correct? > > I really need a full-blown query builder that essentially allows an > end user to query any or all tables (defined in models + auth_user) > with the capability of joins, where clauses, ordering, etc. Maybe my > idea is a 'pipe dream', but none the less, it's a goal of mine to find/ > build a decent web-based query builder tool. > > Tools like mysql-admin connect to a db and read the schema which then > allows you to query the db. I'd like to do the same but as a django > app, it would read the 'schema', so to speak, from the django > project's models.py. This part, I have mostly working. Providing a > useful, organized and efficient web interface seems to be the real > challenge. > > Regards, > > Mike > > > > > > > >
django-filter can work using predefined filters, however it's also possible to build them up a little more dynamically (but probably not to the extent you want). For example piano-man (the app I linked) builds up filters dynamically based on the available options: http://github.com/alex/piano-man/blob/db6f723dfc15155d7b2f900519d6ca3292a95f76/piano_man/tickets/filters.py Alex -- "I disapprove of what you say, but I will defend to the death your right to say it." -- Voltaire "The people's good is the highest law." -- Cicero "Code can always be simpler than you think, but never as simple as you want" -- Me --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
