It's all about the answers!

Ask a question

Download query


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

 

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 (63.1k33645) | 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.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.