© 2026 InterSystems Corporation. All rights reserved.Privacy & TermsGuaranteeSection 508Contest TermsCode of ConductModeration PolicyCookies Settings
Roles
Various code snippets for InterSystems Iris
If ZPM the current instance is not installed, then in one line you can install the latest version of ZPM.
s r=##class(%Net.HttpRequest).%New(),r.Server="pm.community.intersystems.com",r.SSLConfiguration="ISC.FeatureTracker.SSL.Config" d r.Get("/packages/zpm/latest/installer"),$system.OBJ.LoadStream(r.HttpResponse.Data,"c")
If ZPM is installed, then ZAPM can be set with the command
zpm:USER>install utils-code-snippets
Make sure you have git and Docker desktop installed.
Clone/git pull the repo into any local directory
$ git clone https://github.com/eduard93/Utils
Open the terminal in this directory and run:
$ docker-compose build
$ docker-compose up -d
Open IRIS terminal:
$ docker-compose exec iris iris session iris USER>set sql=##class(Utils.SQL).getSQL("Comments",0,.desc) write !,sql,!!,descSELECT c.cid AS Id, c.nid AS Nid, ... node.status = 1 AND node.type IN ('code_package', 'documentation', 'learning_track', 'video', 'post') GROUP BY c.cid
test query stored in xdata