Conversion: list of the links / references on the items TO the list of names of the referenced items

[vjub58]

Hi dear Community,

in the wikitext field of my current tracker I have the references' list to the items of another tracker, like

"[ISSUE:123456] Here is the name of referenced item 1, Created: ...., Modified...., Status.,, "

"[ISSUE:654321] Here is the name of referenced item 2, Created: ...., Modified...., Status.,, "

etc.

I need to convert this references' list to the list of NAMES of referenced items from another tracker, so that in new computed field (also wikitext) I'll get the NAMES' list like:

"Here is the name of referenced item 1, Created: ...., Modified...., Status.,, "

"Here is the name of referenced item 2, Created: ...., Modified...., Status.,, "

etc.

Which computation function / formula should be used to make this conversion? (I suppose, the function List (....) and some projections should be used).

Thank you in advance for your support!

[EvaBertalan]

Hello @vjub58 ,

What is the content of the original wikitext field?

Is it a text? Is it a computation?

[vjub58]

Hi @EvaBertalan ,

The content of original wikitext field is the text in form of reference / link on the item of another tracker: "[ISSUE:123456] This is my issue...". I.e., if you click on this reference in this original wikitext field, you will come to the item of another tracker this link pointed / referenced to (in my example to the ISSUE number 123456 with the name "This is my issue"). I need to extract the name "This is my issue" as a text, and so for every item in this references' list

For me it looks like (or similar to) HTML link tag : [link https://some.example] That is my text [/link].  In this example I would need to extract the link text "That is my text" from the whole HTML tag.

Thank you in advance for any further help!

[EvaBertalan]

Hi @vjub58 ,

Is this how the wikitext look like?:

In edit mode with markup:

[vjub58]

Hi @EvaBertalan ,

not exactly. In Editor mode:

, and in markup:

Thank you in advance! 👍

[EvaBertalan]

Hi @vjub58 ,

Sorry I have so many questions, but I'd like to clarify it.

Is this what you'd like to achieve?

[vjub58]

Hi @EvaBertalan ,

exactly! Is the field "Converted" of type "Text" / "Wikitext"?

But the problem in my case could be, that in markup form your links are containing the link text ("Points of Interest" etc). In my use case the Issue-links don't containing the link text. The link text, which we need here in target "computed field", should be extracted from the name of the item in another tracker, where Issue-link points to. 

For example: In my 1. screenshot instead of "[ISSUE:272.....] Tracker Key...." in target "computed field" it should be converted to "Umsetzer EEPH Modul BE-Team..." etc. "Umsetzer EEPH-Modul... " is the name of the item from another tracker (and even from another project), where the [ISSUE:272...] points to.

[EvaBertalan · Accepted solution]

Hi @vjub58 ,

I've built the formula. I'm not sure it will work in all cases, so it might need tailoring later.

join(List(split(customField[1], ']')).{x| Item(Integer(trim(replace(replace(x, '[ISSUE:', ''), ']', '')))).name}.toArray(), "\\\\")

where customField[1] is the wikifield containing the links.

[vjub58]

Hi @EvaBertalan ,

thank you so much for your effort!

I will check this formula on my site and then immediately let you know here, whether the formula can be adjusted further.

Just for the case I repeat my question: is the new "computed field" "Converted" of the type "wikitext"?

Thank you and see you later! 👍

[EvaBertalan]

Hi @vjub58 ,

Yes, it is wikitext:

[anursingh]

Hi @vjub58,

I wanted to see if you got the help you needed.

If so, please mark the appropriate reply as the Accepted Solution. It will help other members who may have the same question.
Of course, if you have more to share on your issue, please pursue the conversation. 

Thanks,
Anurag 

[vjub58]

Hi @anursingh ,

sorry, I was on sick leave and now I'm on vacation leave. Therefore I couldn't access the codeBeamer Instance I'm just working on.

I will report the results on investigating of the topic's problem as soon as I return to work.

Thank you for your understanding!

Best regards,

vjub58