How to find who approved a Test from XRAY history

[sdutta11]

i was trying to create a JQL to find the approver of Test case , which is captured in history.
how can I create a JQL to search information from XRAY history.

any help will be appreciated.

Thanks

Sammy

[Rayan ali]

Hi Sammy,

Thank you for reaching out! It sounds like you're looking to create a JQL query to find the approver of a Test Case, with the information being captured in XRAY's history. While I'm not able to provide you with the exact JQL query, I can certainly guide you on how to approach this:

1. Open the JIRA Search Bar: First, navigate to the search bar in JIRA where you input your JQL queries.

2. Choose the Right Project: Make sure you're working within the correct project where your Test Cases are located.

3. Add the Issue History Function: In your JQL query, you'll want to use the `issueHistory` function. This function allows you to search for issues based on their change history.

4. Specify the Field and Value: Within the `issueHistory` function, you'll specify the field you want to track (in this case, the field related to approval status) and the specific value you're interested in (which would indicate approval).

5. Adjust for Your Use Case: Depending on how approval history is tracked in XRAY, you might need to adjust the field and value accordingly.

Remember, JQL can be quite versatile, and the specific query might vary based on how your data is structured in XRAY. If you have access to any documentation or resources related to XRAY's data structure or JQL usage, those could be helpful.

If you encounter any challenges or need further guidance, feel free to provide more details, and I'd be happy to assist you. Your determination to improve your processes is commendable, and any progress you make is a step in the right direction!