JQL for searching json child element

Question

We have a custom field 1234 that I need to filter issues from a project on.  My jql is such:

"jql":  "project=JIRA and created < 2023-07-07 "

But I only want results that have the following attribute: customfield_1234.type.name = JIRAHow do I filter based on the above field?

Yida Li · Answer

That worked!  So in summary if you have a custom field mapped already in JIRA when filtering using JQL use the alias name

customfield_1234.requestType.name was mapped to 'Custom Field Name'

so in JQL i queried for 'Custom Field Name' ~ 'JIRA'

Kseniia Trushnikova · Answer

@Yida Li, that's the field Customer Request type, right?

If so, the only way to search for it with JQL is by name or description, see more info here. You JQL should look like

project = JIRA and created < 2023-07-07 and "Customer Request Type" = "JIRA"

Yida Li · Answer

Hi @Kseniia Trushnikova the format of customfield_1234 is as follows:

customfield_1234: {
   requestType: {
      id: 1
   }
}

I need to get the customfield_1234.requestType.id to filter from the search API.