User bio
404 bio not found
Member since Aug 30, 2018
Posts:
Replies:
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.
Certifications & Credly badges:
Lyle has no Certifications & Credly badges yet.
Global Masters badges:
Lyle has no Global Masters badges yet.
Followers:
Lyle has no followers yet.
Following:
Lyle has not followed anybody yet.
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.