It's all about the answers!

Ask a question

Download query


Carlos Musich (152) | asked Mar 26 '19, 6:49 p.m.
edited Mar 27 '19, 3:41 a.m. by Ralph Schoon (61.6k33643)

 

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



permanent link
Ralph Schoon (61.6k33643) | 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"]

Your answer


Register or to post your answer.