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

Forum|Forum|1 year ago
March 6, 2025
1 reply
1306 views

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!

Best answer by EvaBertalan

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.

E

EvaBertalan

12-Amethyst

Hello @vjub58 ,

What is the content of the original wikitext field?

Is it a text? Is it a computation?

V

vjub58

Author

6-Contributor

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!