idea Re: WebConnector for JIRA - Connection Type field - Status changed to: Delivered in Suggest an Idea

WebConnector for JIRA - Connection Type field

mariusbirk — Fri, 23 Oct 2020 16:19:12 GMT

Hello all,

in the WebConnector for JIRA it is possible to get the connection type via the "IssueAsRawXML" query, but not with the "issues" query. It's necessary for many users to get this important field and the "issues" query is here the best query to work with JIRA.

Re: WebConnector for JIRA - Connection Type field

chrisbrain — Mon, 12 Oct 2020 07:38:07 GMT

Hi - Can you just clarify by what you mean by 'connection type'?

An example of how this looks in the XML version of the response would also be useful.

Re: WebConnector for JIRA - Connection Type field

mariusbirk — Mon, 12 Oct 2020 08:07:45 GMT

In JIRA it is possible to connect issues with each other. Therefore different connection types could be used. For example: issue1 "relates to" issue 2 or issue3 "blocks" issue4. In the data from the webconnector its possible to see which issues are linked with each other (issue1 and issue2) but the connection type (relates to) is missing.

In screenshot you see that via the webconnector with query "IssueAsRawXML" it is possible to get the "name", but with query "issues" it is not possible..

Re: WebConnector for JIRA - Connection Type field

chrisbrain — Mon, 12 Oct 2020 11:03:32 GMT

Thanks - I think the reason these aren't included in the current issue is there is only a single row per issue and there could be multiple links.

Do you have an idea how you would represent all of these links in a single (or multiple) columns for a single issue?

Re: WebConnector for JIRA - Connection Type field

chrisbrain — Mon, 12 Oct 2020 11:04:40 GMT

The alternative would be to add some sort of LinksForIssue table which takes an issue ID.

Re: WebConnector for JIRA - Connection Type field

Steffi — Tue, 13 Oct 2020 08:52:58 GMT

Hello @chrisbrain ,

I would suggest a separate table that could look like this:

The statement that there is only one line per issue is not 100% correct.
I also assumed this 😉 but I know the following case.
Create a custom field of the type checkbox with multiple selections.
If several options are clicked, several data records will be created for the issue with the same ID!

Re: WebConnector for JIRA - Connection Type field

chrisbrain — Wed, 14 Oct 2020 07:53:40 GMT

@Steffi Thanks for this.

We could add a LinksForIssue table - my only concern is that you would then have to construct a for/next loop to run this for potentially 1000s of issues which could be slow and it's to get data which was already present in the API responses used to build the Issues table.

Would it be useful to add an 'InwardIssues' column to the existing issues table which for example concatenated together the links using a format something like:

Re: WebConnector for JIRA - Connection Type field

mariusbirk — Mon, 19 Oct 2020 08:22:51 GMT

@chrisbrain

this sounds great! It would be very useful for us to have two columns (InwardIssues & OutwardIssues) as you described. What would be the further process for this feature request?

Regards,

Marius

Re: WebConnector for JIRA - Connection Type field

chrisbrain — Mon, 19 Oct 2020 12:56:52 GMT

Hi,

Thanks - nothing else you need to do your side for now 🙂

Re: WebConnector for JIRA - Connection Type field

mariusbirk — Mon, 19 Oct 2020 13:27:06 GMT

Hi, this means that potentially with the next WebConnector Version this is possible? 😉

Re: WebConnector for JIRA - Connection Type field

chrisbrain — Tue, 20 Oct 2020 09:52:39 GMT

@mariusbirk Yes possibly - I am actually looking at it today.

I realised the Issues table does already have fields_issuelinks_ids and fields_issuelinks_keys columns which concatenate these values together.

I guess this is not sufficient - Is it both the inward/outward and linkType you are missing?

Re: WebConnector for JIRA - Connection Type field

mariusbirk — Tue, 20 Oct 2020 09:58:38 GMT

Yes, you're totally right. The link type of the inward & outward connection is our missing piece 😉

Re: WebConnector for JIRA - Connection Type field

chrisbrain — Tue, 20 Oct 2020 11:39:01 GMT

@mariusbirk So for the concatenated value for:

issue1Id,issue1Key,issue1Type

I think I should pick on of these - Would you say 'name' is OK or should I select the inward/outward value depending on the direction for this string value?

Re: WebConnector for JIRA - Connection Type field

chrisbrain — Tue, 20 Oct 2020 12:04:46 GMT

I think it will be clearer to take the relevant inward/outward text so I will do that.

Re: WebConnector for JIRA - Connection Type field

mariusbirk — Tue, 20 Oct 2020 14:28:55 GMT

Yes, it would be better to take the relevant inward/outward text.

Re: WebConnector for JIRA - Connection Type field - Status changed to: Open - In Development

P-O_Davidson — Fri, 20 Nov 2020 22:09:51 GMT

Re: WebConnector for JIRA - Connection Type field

chrisbrain — Wed, 09 Dec 2020 12:04:45 GMT

@mariusbirk Just to let you know this is now available in the December 2020 release.

Re: WebConnector for JIRA - Connection Type field - Status changed to: Delivered

P-O_Davidson — Wed, 09 Dec 2020 13:12:44 GMT

Re: WebConnector for JIRA - Connection Type field

mariusbirk — Wed, 09 Dec 2020 13:56:43 GMT

Thank you! I will test this the next days.