Yes, I would like to change Year1 and Year2 from the example to "Jul"_xFiscalYear and "Jul"_xFiscalYear+1

If this is not doable, then maybe a different kind of class query?

Thank you.

We are using an order version of Cache (2012) so I am not sure this newer way to write objectScript-based class queries is available. We are planning to move to 2017 sometime this year.

Basically we are using the class queries as stored procedures to be called by Logi reports. All the developer has to do is perform a call method within the reports and get back a record set of data for the report.

Example:

Call SAT.ReportQueries_GLReportYearToYearTrend('2017') From SAT.ReportQueries

If there is a better way of doing this that would be great but this was the only way I knew how to do it at the time.

I tried Benjamin's suggestion (Select within a Select) but it doesn't work with a call Statement.

Thanks!

I did try this but it's not working because Authorize.net requires use of TLS 1.2 and Cache 2012.1.4 doesn't allow this configuration when creating the SSL configuration in the Management portal. I found another way using C# and creating a web service to call from Cache.

Hopefully we will be upgrading soon, I could use the built JSON support.