[Zope] Reporting in Zope

[Dieter Maurer]

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