On Tuesday, June 30, 2015 at 12:10:48 AM UTC-7, Mo wrote: > > So did I get this right? > Users with REPORT_ADMIN permission can create reports and all these > reports are available to all users? >
Yes, that should be the case. REPORT_CREATE should be sufficient for creating reports. http://trac.edgewall.org/wiki/TracPermissions#Reports > Where can I see the default set of reports that are available after plain > install, or can those be modified and deleted just like any other report? > Reports 1 - 8, or 1 - 9 (I can't remember the exact number) are the default reports. They can be modified and deleted like any other report. > What is the difference between reports and custom queries? Or can any > query be created from a query dialog (listboxes, editboxes...) OR from SQL > commands (with the higher SQL flexibility)? > Right, a report can contain SQL or query syntax. Try saving a query as a report and then edit the report for that query. You will see that the text box that normally contains SQL instead contains a query string. SQL has the downside that it may not be portable across databases. This is a concern if you are, for instance, on SQLite now and later move to MySQL and PostgreSQL, in which case your reports may need to be modified when you migrate. It's also a concern because some SQL for reports that users have posted, for instance to this mailing list, may be specific to a database. So beware when copying and pasting. You should see a //Save query// button on the Query page. http://trac.edgewall.org/wiki/TracQuery#SavingQueries - Ryan -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/trac-users. For more options, visit https://groups.google.com/d/optout.
