Jira R4J export function

YHAN04

Hello,

we are using R4J to manage requirement. now we want to export the traceability between user needs and design input. 

Export format: Excel 

1. only export linked issue(design input) which derives form user needs

2. export content should include key, summary, description 

3. below is the template i am using in excel now, but "design input" and "design input description" still not working.

 

User Needs ID	User Needs Description	Design input ID	Design Input Description
[[key]] [[summary]]	[[description]][[/wiki]][[\if description = “”]]No Description available.[[/if]]	[[\each $.linkedissues]][[\if $.type = “Derives”]][[\if $.out]][[linkedissues]]  [[/if]][[/if]][[/each]] [[linkedissues.summary]]	[[linkedissues]] [[\each $.linkedissues]][[\if $.type = “Derives”]][[\if $.out]][[linkdissues.summary]]  [[/if]][[/if]][[/each]]

Edmer John Sarmiento

Hi @YHAN04

I'm Edmer from EaseSolutions, vendor of R4J plugin. Currently, our Excel Template Based Export expressions and statements are very limited. You may use "if" statement as similar as your given example with our Word Template based Export.

 

[[\jql project = “$selectedProject” and issue in requirementsPath(“$selectedProject.name”) order by

key asc]]

[[\apply-template issueDetails]] [[/apply-template]]

[[/jql]]

[[\template issueDetails]]

User Needs ID:	User Needs Description:	Design input ID:	Design Input Description
[[$.key]] - [[$.summary]]	[[\wiki $.description]][[/wiki]][[\if $.description = “”]]No Description available[[/if]]	[[\if $.linkedissues.count > 0]][[\each $.linkedissues]][[\if $.name = “derives”]][[$.issue.key]]- [[$.issue.summary]]	[[$.issue.description]][[\if $.issue.description = “”]]No Description available[[/if]] [[/if]][[/each]][[/if]]

 

[[/template]]

 

If none of these help, we'd be glad to help you at our service desk portal for further investigation.

Best regards,

Edmer