In JQL, is there any way to list all projects containing a certain word?
For example, there are many projects in our JIRA contain a word "Tony", and I can not list all of them in JQL by Project Key, because there are more than 1000 characters. I also don't want to separate the JQL, because I want to use a dashboard to represent all of them.
I think there is a way like use * or ? to replace the different word in the project title, but I think maybe I did wrong? or it doesn't allow me to use * and ? i Project. I wrote like this "Project in ("*Tony")".
Any thoughts about this?
If I understood your question you are looking for a JQL to list projects right? Being that the case I have to say you that the JQL are meant just for searching issues within projects, so you can't search only for projects. But you can use an SQL query on your database to search them. It would be like this:
select pname as "Project Name" from project where PNAME LIKE '%Tony%';
On this example I'm searching for all projects beggining with "Tony" on it's name.
Please note that this is mysql query so you may have to customize it to your db.
Also if you don't want to use an SQL query you can take a look on some add-on on JIRA marketplace, an example would be this
Hope this helps and let me know if you have any other question about this!
This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.Read more
Hi Community! My name is Amir and I’m on the Jira Service Desk product marketing team at Atlassian. Our team would love to understand how you’re leveraging our ecosystem for Jira Service Desk. Wha...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs