Can I search for issues using values within JSON custom fields?

dmatijasevic

I am trying to search for issues using values within a custom field that is a JSON object. Here is an example:

"customfield_15000": {
    "data": {
      "text": "blabla",
    },
    "identifiers": {
      "id": "18",
      "name": "Main location",
      "value": "Left of centre"
    }
}

I want to search using REST API (/rest/api/3/search) for all issues that have value of customfield_15000.identifiers.id = 18 (in JSON-speak). I tried using cf[15000].identifiers.id = 18 but I'm getting an "Error in the JQL Query: Expecting operator but got '.identifiers.id'. etc" message.

Is this even possible using JQL/REST?

Thanks in advance for any suggestions!

Michael Raj_18ewee

Hi @dmatijasevic ,

I'm not an expert but JSON is a result of the search, not the search parameters.

Check if JQL recognizes this particular customfield_15000 and/or value/name/id. If it does, you can use it in the request sent to API.

If not, search for all issues (most accurate you can be, maybe use other filters) and in the code check if issue has the value you're looking for. I know it may be time consuming but I believe it would work.

 

Best,

Michael