creating universal custom queries

Added by Stephen Womack over 7 years ago

i know that you guys get sick of me asking question but i have 2 more that are related to custom queries.

1. is there a place to go inside the redmine administration section to create a custom query that all projects have.

2. how do you remove a query once it is created for a certain project. I know i can do it through the database, but i would like to be able to remove those without making manual changes to the live database.

Thanks in advance! :)

Replies (6)

RE: creating universal custom queries - Added by Felix Schäfer over 7 years ago

  1. At least as an administrator I have a checkbox for all projects when creating a custom query.
  2. When I click on a custom query, there are two links at the top right (context menu): edit and delete.

Check your permissions to make sure you have enough rights.

RE: creating universal custom queries - Added by Stephen Womack over 7 years ago

As usual Felix you are awesome. I did not realize the edit/delete button was for that query. Thanks again for all your help with this matter. I just wanted to say that this forum is one of the best forums i have ever been a member of!

RE: creating universal custom queries - Added by Felix Schäfer over 7 years ago

The menu at the top right is always in the context of the "object"/thing you are viewing :-)

Happy to help, and thanks for the praise :-)

RE: creating universal custom queries - Added by Robin McKenzie about 7 years ago

As an addendum to the above - how can one stop a custom query being available "for all projects"? (i.e. uncheck the box - it's now greyed out in the original project)

Also, is there a way from copying a custom query from one project to another (I want all my custom queries available in my newly-created subprojects.)

Many thanks!

RE: creating universal custom queries - Added by Felix Schäfer about 7 years ago

Robin McKenzie wrote:

As an addendum to the above - how can one stop a custom query being available "for all projects"? (i.e. uncheck the box - it's now greyed out in the original project)

Not, as it won't know what project to attach it to, you can only delete it.

Also, is there a way from copying a custom query from one project to another (I want all my custom queries available in my newly-created subprojects.)

Not yet, but there's been a request and I submitted a patch for it, can't remember the issue ID though. Why don't you have the queries being global if you use them for so many projects though?

RE: creating universal custom queries - Added by Robin McKenzie about 7 years ago

Thanks Felix.

I don't want the queries as global because my whole company uses this system, and I'm just one small part of it. We probably have about 40 projects, and I use about 6 of them. The custom query also orders by a field that only exists in my 6 projects, so it doesn't even work for the other projects.

As an aside, this custom field is a numeric field called "Pri" (which we assign a value from 0-99) which we use in order to order tickets - we don't use the Priority field at all because it doesn't have enough granularity. However, I suspect that there may be a better way to do what we want - how can we achieve ordering of tickets without a custom, granular field like this?

(1-6/6)