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 · Accepted solution]

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

[YHAN04]

Hello Edmer,

Thanks so much for your reply.  I know how it works in word. but we are looking forward the excel template. it is more easy to review the detail traceability.

would you let know when the "if" function can be available for excel?