Many reporting tools are available to generate reports from SQL databases (Crystal comes to mind). Two of the gripes I have heard against object databases are: 1) They are hard to query (no powerful SQL like querying available - bound to what you defined in the catalog). 2) Creating reports are hard or there are no tools available (basically again a reporting problem). Is there something in Zope to (really quickly) create generic type reports on the attributes of objects. Eg. create a report where all the invoice objects' totals are above $100 and the invoice has not been paid yet. Yes, it's easy "to quickly write a script" to do it (for a programmer), but (so it was claimed) there are tools in SQL that would create the above query very quickly (5 minutes) and sometimes with drag and drop interfaces. Are there something like that for Zope and what is the "best of breed" query/reporting product/s available for Zope. Etienne
Etienne Labuschagne wrote at 2004-1-12 15:57 +0200:
... Is there something in Zope to (really quickly) create generic type reports on the attributes of objects.
Eg. create a report where all the invoice objects' totals are above $100 and the invoice has not been paid yet.
To get it efficient, you must have indexes for the involved attributes. Then you could use "Z Search Interface" (you would need to adapt the generated templates, though).
Yes, it's easy "to quickly write a script" to do it (for a programmer), but (so it was claimed) there are tools in SQL that would create the above query very quickly (5 minutes) and sometimes with drag and drop interfaces.
There is "VisualQuery" (or something like that). I think it is for relational databases. But could probably be adapted. I think (up to beauty) that I would make it in 5 minutes with "Z Search Interface". Some related products (I think all for relational databases with Zope): "ZDataQueryKit", "ZSQLnolkWizzard". -- Dieter
participants (2)
-
Dieter Maurer -
Etienne Labuschagne