JQL for searching json child element

[Yida Li]

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 = JIRA

How do I filter based on the above field?

[Kseniia Trushnikova]

Hi @Yida Li,

What is the type of your field customfield_1234? Is it a text field or a cascading select list?

[Yida Li]

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.

[Kseniia Trushnikova]

@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]

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'