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.

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.

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.

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?