nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to search issues based in a customfield name value that must contain some text? Via API REST

Ian Carlos

Hi everyone! Hope you're fine

I'm trying to perform some report automations based on my Jira Issues and I would like to perform an Issue search via API REST whithin a time frame (I've already achieved this) and ONLY if a certain customfield name value contains a text

I know that this works:

"https://xxxxx.atlassian.net/rest/api/2/search?jql=created >= START_DATE_VAR AND created <= END_DATE_VAR AND "...

So I would like to add after the last AND something like

"CustomFieldXX".name ~ "TEXT"

Hopefully you could give me a hand

Thank you so much for your time!

Best regards,

Accepted answers

Ian Carlos

I found the answer!

If anyone interested, is this:

Since my customfield was an Asset Object, I did it using AQL mixed with JQL

This:

"CustomFieldXX" in aqlFunction('name LIKE TEXT')

Hope this could be useful for you

All comments

Vamsi Kandala

Hi @Ian Carlos

Instead of

"CustomFieldXX".name

Can you try with

customfield_xxxxx ~ "TEXT"

Where xxxxx is the custom field id of the associated custom field

Basically, your API call would be like

"https://xxxxx.atlassian.net/rest/api/2/search?jql=created >= START_DATE_VAR AND created <= END_DATE_VAR AND customfield_xxxxx ~ 'TEXT'"

Hope this helps.

Thanks,
Vamsi

Ian Carlos

Hi Vamsi

Thanks a lot for your fast reply

I tried what you say and it gives me the following error:

The operator '~' is not supported by the 'CUSTOMFIELDXX' field

Do you have any idea of what to do?

Thank you so much for your time

Vamsi Kandala

Hi @Ian Carlos

What is the type of the custom field 'customfield_xxxxx'?

The "~" operator is used to search for issues where the value of the specified field matches the specified value (either an exact match or a "fuzzy" match — see examples below). For use with text fields only, i.e.:

Summary
Description
Environment
Comments
custom fields that use the "Free Text Searcher"; this includes custom fields of the following built-in Custom Field Types
- Free Text Field (unlimited text)
- Text Field (< 255 characters)
- Read-only Text Field

Please refer to this article for more help:

https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-operators/

Hope this helps.

Thanks,
Vamsi

Ian Carlos

Hi Vamsi, again, thanks for your fast reply and sorry for my late one (I was taking lunch)

mmm, the customfield is related to an Asset, that's why I thought there it could be a "object.name" or something like that

I don't know how to do it with AQL and how to mix this with JQL

Sorry

And thanks a lot for the documentation! I will give it a look

Ian Carlos

I found the answer!

If anyone interested, is this:

Since my customfield was an Asset Object, I did it using AQL mixed with JQL

This:

"CustomFieldXX" in aqlFunction('name LIKE TEXT')

Hope this could be useful for you

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

issue

jira

cloud

rest-api

python

jira-service-management-cloud

jira-service-management