Article Matthew Giesmann · Jan 28, 2022 2m read Embedded SQL Bug and Workaround We recently encountered an Embedded SQL issue while upgrading to IRIS 2021.1, and thought the issue and workaround might be interesting to share. Key takeaway: Host variables in an ORDER BY clause of an embedded SQL query that is inside of a method don't work as expected. IRIS versions starting with 2020.1 are affected. As a workaround, add the host variable to the Method's PublicList list and "new" them so the embedded query has access to them. #SQL #InterSystems IRIS 6 1 0 319
Article Matthew Giesmann · Nov 20, 2020 6m read Leveraging Queries and ObjectScript with the AppS.REST Framework Earlier this year, the AppS.REST package was released. AppS.REST is a framework for easily exposing existing persistent classes in IRIS as REST resources. AppS.REST-enabled classes support CRUD operations with little effort from the developer, bridging the gap between persistent data in IRIS and data consumers, such as an Angular front end application. But IRIS classes are much more than just a definition for loading and saving individual records! This article aims to highlight a few ways to leverage the power of IRIS in your REST applications. Using the Phone.Contact sample app, we'll look at out-of-the-box query support, use of class queries and finally ObjectScript methods. #REST API #InterSystems IRIS 4 6 1 386
Article Matthew Giesmann · Nov 8, 2016 4m read Introduction to Outlier Selectivity Beginning in Caché 2013.1, InterSystems introduced Outlier Selectivity to improve query plan selection involving fields with one atypical value. In this article, I hope to use an example 'Projects' table to demonstrate what Outlier Selectivity is, how it helps SQL performance and a few considerations for writing queries. #SQL #Caché 3 1 0 602