django-qbe
by versae

Django implementantion for Query By Example (QBE)

Admin tool in order to get custom reports. The objective of django-qbe is provide a assited and interactive way of making complex queries with no technical knowledge (or minimal) to get custom reports from the objects of Django models. Based on QBE proposal from IBM®, django-qbe is intended to remove the limitations of Django QuerySets objects and to use the whole expresive power of the subjacent SQL.

Features

  • Multi-database support.
  • View and autodiscover relations among the models in a visual way (ForeignKey fields are green and ManyToMany ones are red).
  • Tabular creation of queries with fields to show, criterias, lookups and order (only AND conditions by now).
  • Auto adition of right fields when ForeignKey or ManyToMany fields are selected.
  • No models in the project, so you can add django-qbe whenever you want with no syncdb.
  • Pagination of results.
  • Bookmarklet to save and share the queries.
  • Export results to .csv, .odt and .xls, but it's extensible by the user.
  • Access restricted to users through a customizable function.
  • Links to admin views (if available) in the results objects.
声明：本站所有文章，如无特殊说明或标注，均为本站原创发布。任何个人或组织，在未征得本站同意时，禁止复制、盗用、采集、发布本站内容到任何网站、书籍等各类媒体平台。如若本站内容侵犯了原著者的合法权益，可联系我们进行处理。