Running a JQL to find the child account name listed under a parent type

[Steve McEvoy]

Am very new to Jira, and trying to run a query that will output all of the Account Names for Customer A, that are linked to multiple JIRA cases

I can run a JQL for the CustomerA, which lists all the Type=Requests but some of the queries also capture the second customer, CustomerAB

Type: Request
Status:In Progress
Priority: Medium
Resolution:Rejected
Component/s:None
Labels:
RFE:Yes
OS:All
3rdPartyIntegration:Yes
Req. Accounts:
     Account name Account Type Region
     CustomerA Customer US
     CustomerAB Customer EMEA

Thoughts?

[Vikrant Yadav · Accepted solution]

Hi @Steve McEvoy Req Accounts is a custom field ?

[Steve McEvoy]

I believe so. and the field I am looking to search on is a child of that field.

The Account Name can contain multiple entries. 

[Vikrant Yadav]

is it a text field or cascading field ? i want to know the field type.

[Steve McEvoy]

Good question, I believe from looking at it the account names are a list under the column ID

So I believe a text field.

[Vikrant Yadav]

@Steve McEvoy  For Text field JQL search doesn't work like Dropdown field or any other field in which the value is fixed. 

Search for issues where the description contains particular text.

Checkout these link to search issue using text field

https://support.atlassian.com/jira-software-cloud/docs/search-syntax-for-text-fields/

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

[Steve McEvoy]

Hi Vikrant,

Thank you for your reply and links, they look useful. Will look into them further.

As a side note, if the field was cascading. Would you have details on how the query should be constructed?

[Vikrant Yadav]

@Steve McEvoy  For cascading try this :- 

customfield in cascadeOption(parentOption,childOption)

https://confluence.atlassian.com/jiracoreserver073/advanced-searching-functions-reference-861257222.html#AdvancedSearchingFunctions-cascadeOption%28 

[Steve McEvoy]

OK thank you, appreciated.

[Vikrant Yadav]

Cool, glad to hear it helps!