Hi,
is it possible to share custom queries or reports with users, user groups or globally? From the users perspective that would mean to have an overlay of inherited queries and user-owned custom queries.
On Thursday, June 25, 2015 at 7:20:24 AM UTC-7, Mo wrote:
is it possible to share custom queries or reports with users, user groups or globally? From the users perspective that would mean to have an overlay of inherited queries and user-owned custom queries.From what I can see the saved custom queries are available to all users.
So did I get this right?
Users with REPORT_ADMIN permission can create reports and all these reports are available to all users?
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?
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)?
is it possible to share custom queries or reports with users, user groups or globally? From the users perspective that would mean to have an overlay of inherited queries and user-owned custom queries.From what I can see the saved custom queries are available to all users. You could restrict access to certain reports (saved queries) using TracFineGrainedPermissions (1). See comments about that (2).
Am Freitag, 26. Juni 2015 06:00:28 UTC+2 schrieb RjOllos:is it possible to share custom queries or reports with users, user groups or globally? From the users perspective that would mean to have an overlay of inherited queries and user-owned custom queries.From what I can see the saved custom queries are available to all users. You could restrict access to certain reports (saved queries) using TracFineGrainedPermissions (1). See comments about that (2).
Hi, taking this topic up again... are there plans to rework the whole custom query section? Currently it is not very flexible, if I don't miss some things:
What is the difference between custom queries and reports? AFAIK queries can be created with the gui while reports are plain SQL? But sometimes editing a custom query I end up with SQL as well. And the "View tickets" view shows reports and queries without notes which entry is a query or a report.
Is it possible to clone a query/report? I tried creating a new report and copy the SQL from another report, but even then I need to adapt report= which feels very lowlevel.
According to the initial question there is no difference between user specific custom queries and shared queries. Currently all queries that are created by report admins are visible to all.
Most users coming from Bugzilla like to have their own queries for their own projects. Then creating all available queries for all projects globally will increase the list a lot. Then having fixed ids in the report list will lead to wholes after removing reports.
Perhaps slightly off topic, but related to your comment about not
having the queries in SQL:
I have a trac site that started life with SQL search queries. As I add
new queries, they are in a more TracQuery language. But the old
original queries stay as SQL. I would like to have all the queries in
the non-SQL syntax. What is the easiest way to do this? Editing the
search seems not to do this. Do I have to delete the query and then
add it again new?
My queries are all a mess. I really need to do a bit of housekeeping.
Maybe I could dump all the defined queries somehow, edit this, and
then re-import the queries?
Yes. Reports. They are a mix of SQL and TracQuery. I want to move them
all to TracQuery.
But what I would like to do is get them somewhere where I can clean
them up, reorder them, and all that fun housekeeping.And then reload
all reports into a fresh table.
Doing this in the web interface would be tedious.
I agree it is a valuable feature, however we are really lacking contributors these days and the few of us that are working on the projects can't implement every nice-to-have feature in the limited time we have available. I'd like to get more people involved in the project, but that is difficult even someone commits to working some patches. Hopefully things will pickup in the coming year.
The difference between reports and queries gets even more confusing if I change a custom query and save it, which leads to a "Edit Report" dialog and "Save Report" button, where I can review the SQL behind my custom query and save it. So behind the queries engine there is always a SQL report as well?
What about if I like to re-arrange the queries? For now they have fixed index and inserting another custom query in the list is not possible easily, for example if I like to have the list sorted by project.