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