Download query
Carlos Musich (15●2)
| asked Mar 26 '19, 6:49 p.m.
edited Mar 27 '19, 3:41 a.m. by Ralph Schoon (61.8k●3●36●43)
Hi,
I have a query in RTC. Is it possible to download the output results in a csv using a command in a batch file?
May be passing the URL as parameter.
Thank you.
Best regards,
Carlos
|
One answer
Ralph Schoon (61.8k●3●36●43)
| answered Mar 27 '19, 3:44 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER See https://github.com/jazz-community/work-item-command-line use /asrtceclipse to get the values similar to RTC's CSV export.
-exportworkitems
repository="value"
user="value"
password="value"
projectArea="value"
query="value"
querysource="value"
exportFile="value"
/allColumns
/asrtceclipse
/suppressAttributeExceptions
/headerIDs
/ignoreErrors
[encoding="UTF_16LE"]
[delimiter=";"]
[columns="Type,Id,Planned For,Filed Against,Description,Found In"]
[querysource="JKE Banking(Change Management),JKE Banking(Change Management)/Business Recovery Matters"]
[timestampFormat="MMM d, yyyy hh:mm a"]
|