Has anyone ever integrated test complete with Zephyr squad. It fails with invalid credentials.

[David Theroux]

Hello All, I have a customer who is integrating Test complete into Zephyr Squad. The customer seems to be able to Log into test complete just fine but when they try to log into Zephr squad which is one of the apps in Jira, through the preferences in test complete it fails and says wrong username and password. Usually we log into Jira via WSSO in our facility. We have their windows credentials as backup in case we cannot use WSSO. Has anyone ever done this before? Please Advise! I will try and contact smartbear the manufacturer of the product next. I just don't think they can help because they have nothing to do with our users and passwords in our facility.

[Daniel Eads · Accepted solution]

For the casual reader, just noting that the issueFunction clause here comes from the Scriptrunner plugin.

Try this query, which matches just Epics that aren't closed but all the issues inside them are. Presumably this is to inform you which Epics should be moved to a Done state.

issuetype = EPIC AND status not in (Closed, Done, SOLVED) AND NOT (issueFunction in linkedIssuesOf("status not in (Closed, Done, SOLVED)", "has Epic"))

Also note that I've used the three Done statuses you had in your original query (Closed, Done, SOLVED). You could also try "Resolution IS NOT EMPTY" if you've got multiple Done statuses and are setting a resolution when issues transition to done. Just make sure to clear Resolution via post-function if you've got a Reopen transition.

Cheers,
Daniel

[ashok 1234]

I am receiving several outstanding epics. I am looking e.g. for Tribe-241 with all issues in epic marked as done.

I am struggeling with getting the right query, would it be possible to update it?

 

[Andy Heinzer]

There is a flaw in your original query.   Specifically this part:

issueFunction in linkedIssuesOfAll("issuetype = story AND status = Done AND status = Closed AND status =SOLVED")

This function will look at all the linked issues of the epic that match the JQL you have nested inside.  The problem is that Jira issues can only have a single status at a time.  So you have 3 different status values joined with an AND.  No issue could possible match all three status values at the same time.  Instead try this JQL query to see if it returns what you want:

issuetype = EPIC AND Project in (xxx, xxx,xxx) AND status = "In Progress" AND issueFunction in linkedIssuesOfAll("issuetype = story AND status in (Done, Closed, SOLVED)")

This way the linkedIssuesOfAll function will look for story type issues that have any one of those 3 statuses, and if all the linked issues match this, then it should return your epic.

If you find this is not the case, then I would also be concerned to see if other issues are linked to the epic, such as subtasks, or other issue links (ie not in the epic itself).  I believe that linkedIssuesOfAll includes more than just the child issues of an epic potentially.