Can you create a local variable in JRS?
Hi,
I've been working with editing the SQL Query in JRS to create a more advanced report. I've been looking online but haven't found anything on this topic - I apologize if I missed something. I was wondering if there was a way to define a local variable inside the SQL query in JRS. I get a lexical error when I try to use an "@" sign, and continue to get errors with anything else I try. I am trying to use this variable in a CASE statement. Please let me know if there is a way to successfully define this. Thank you! |
One answer
Hello Sarah,
this sounds similar to what was discussed in this thread: How can I declare a temporary table in the Jazz Reporting Service? https://jazz.net/forum/questions/218354/how-can-i-declare-a-temporary-table-in-the-jazz-reporting-service and it's most likely currently not possible. Best Regards Francesco Chiossi |
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.