How to search for projects that include a word

We have many projects for the one customer.

We include the customers name in the title of the project.

I would like to do a filter/search that looks at all projects and returns the ones that includes the customers name.

However, I do not see any way to include text. It looks to only be text that is equal or not equal to the full sting of the project name.

Would love some help on how I can do what I am looking for.

Thanks,

2 answers

Hey Emma just a few questions to clarify what you intend to do.

Whats the purpoose of this project filter? You want just a list of projects of a determined customer? Or a dashboard with all issues of a specific customer?

If the case is that you want all issues from a company(customer) you could do a jql filter like this:

company=company_name

if you want a list of projects from a determined customer i'm afraid that you will have to use an SQL query like this one :

select pname from project where pname='project_name';

Hope it helps :D

I hope this helps in clarifying what I am after.

Regardless of the item I am looking for (e.g. customer name) I am wanting a filter that is able to use an ‘includes’ argument.

E.g. <Field> ‘includes’ <word>

Where <Field> is any field within JIRA and <word> is any word that is found within the values of the field.

With your comment about an SQL query, are you saying that I can use an SQL query in the JQL filter query, or is there another way to achieve this?

0 vote

Hi Emma,

JIRA actually has a "includes" operator which is the ~ operator but this is only available for certain fields.

You can find information about the operator and the fields where you can use it here.

JIRA doesn't have a feature to run SQL queries directly in JIRA, so the SQL would need to be queried directly in the JIRA database.

You could run something like this to search for projects with "word" in the project name

select pname from project where pname LIKE '%word%';

To look for a custom field value, you could use the same LIKE operator above using the custom field tables (customfield, customfieldvalue and customfieldoption) in the database too.

Hope this helps.

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Posted Wednesday in Jira

Join our webinar: How 1B+ feature flag events helped us build the new Jira

Every time you release software, there's a bit of risk – that there's a bug, that something breaks, or that the feature doesn't resonate with customers. Feature flagging helps make high stakes s...

143 views 0 3
Join discussion

Atlassian User Groups

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!

Find my local user group

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

Groups near you