Rally Software

Expand all | Collapse all

Custom query - Operation on rally fields

  • 1.  Custom query - Operation on rally fields

    Posted 11-22-2016 05:05 PM

    One of the rules of custom query is that the right hand side of the operation should not be a rally field,  nevertheless did anyone try a workaround operation to do  ( "AcceptedDate") - ("InProcessDate") ?  Thank you!



  • 2.  Re: Custom query - Operation on rally fields

    Broadcom Employee
    Posted 11-23-2016 12:16 PM

    Have we tried comparing two fields in a query, sure. But as all of the documentation indicates it can't be done in the UI. Your best option is to extract the data and analyze it elsewhere; we run regularly scheduled extracts to a SQL database for BI reporting. Hope that helps.



  • 3.  Re: Custom query - Operation on rally fields

    Posted 11-23-2016 12:31 PM

    Thank you Eric.  At present I am encouraging our users to export the relevant views to Excel for such operations.   I was wondering whether anyone did it as a custom query.  I guess we can also use WSAPI to do it....  Since these outside activities are increasing, our users are asking for another tool that supports these operations within the tool...