go to post Robert Cemper · Dec 1, 2021 Judging: (from AoC) Below is the Advent of Code 2021 overall leaderboard; these are the 100 users with the highest total score. Getting a star first is worth 100 points, second is 99, and so on down to 1 point at 100th place. so you collect stars
go to post Robert Cemper · Nov 30, 2021 it is in row #12,I write the name of the package and the title of my review(as a link)and not every review goes immediately to the monthly list if I'm still in doubts as it may change
go to post Robert Cemper · Nov 30, 2021 what I understand from your description: you have an input file with records (rows) with delimited fields (columns) you expect to see this file as a table (like in Excel) you expect to sort your rows by various columns you expect to include/exclude rows by various criteria This is all standard SQL and fully included IRIS (MUMPS was almost stone-age) The only question left is your input format as Excel has a proprietary format,but reads many others as well (CSV, HTML, XML, ..??)
go to post Robert Cemper · Nov 30, 2021 If you have a complex object, then add %JSON.Adaptor to the class,and do an %JSONExportToStream as you did with %XML.Adapter
go to post Robert Cemper · Nov 30, 2021 or simply ClassMethod Login(ByRef streamReturn As %GlobalBinaryStream, user As %String, pass As %String) As %Status [ ProcedureBlock = 1 ] { set streamReturn=##class(%GlobalBinaryStream).%New() set cswReturn="{""success"":1}" set sc=streamReturn.Write(cswReturn) quit sc }
go to post Robert Cemper · Nov 30, 2021 suggestion ClassMethod Login(ByRef streamReturn As %GlobalBinaryStream, user As %String, pass As %String) As %Status [ ProcedureBlock = 1 ] { set streamReturn=##class(%GlobalBinaryStream).%New() set cswReturn={} set cswReturn.success=1 ; set format=##class(%JSON.Formatter).%New() set format.Indent=0 set format.LineTerminator="" set sc=format.FormatToStreamFromObject(cswReturn,.streamReturn) quit sc }
go to post Robert Cemper · Nov 30, 2021 I have to add a few personal remarks.This issue of the monthly reviews is exceptional as there is no package rated below 5*In that sense, you may feel it be a Christmas edition. And that's true for me.It points out that the quality of contributions has significantly improved.And as I try every package myself I find problems and sometimes solutions too,that I post as Pull Request on GitHub.Pls understand, if I place Pull Request it is meant as help, suggestion but never as critics.Some of you have already consumed this support as a kind of field testing.And I offer it again to you to improve the quality of your package also before publishing.My resources at home are of course limited and connections to external systems are not available.I don't have medical devices or a machine park at home.In addition, I'd like to thank you for your trust and your examples.And over time I learned a lot about Docker configurations and various tricks to run them.And there are areas where I just have no expertise. I skip these subjects.Finally.You are an exceptional society and I enjoy again and again to work with you
go to post Robert Cemper · Nov 29, 2021 case sensitivity of packages is an ongoing challenge.top-level := developer is ok.but who should use top-level dc ?I ask because every template uses dc for the example packages. which is ok.but users follow this example (often).
go to post Robert Cemper · Nov 28, 2021 this is the method description it seems that you should your call parameters differently method ExecuteProcedure(ByRef pResultSnapshots As %ListOfObjects, Output pOutputParms As %ListOfDataTypes, pQueryStatement As %String, pIO As %String, pInputParms...) as %Status [ Language = objectscript ] The pOutputParms list returns the output values of all scalar output and input/output parameters.This would result in this order SET tSC = ..Adapter.ExecuteProcedure( , .outparm, SQLQuery2 , "io*", pRequest.StringValue ) >> 1st par - skipped>> 2nd par = output byRef>> 3rd par = SqlQuery>> 4th par = io>>par 5 ... query input parameters This explains the log
go to post Robert Cemper · Nov 28, 2021 pass outparm by reference .outparm SET tSC = ..Adapter.ExecuteProcedure(,,SQLQuery2,"io*",pRequest.StringValue,.outparm )
go to post Robert Cemper · Nov 28, 2021 intersystemsdc/irishealth-community:2021.1.0.215.3-zpm should do itor simply the latest docker run --name my-iris -d -p 9091:1972 -p 9092:52773 intersystemsdc/irishealth-community
go to post Robert Cemper · Nov 26, 2021 BINGO! that''s the way to go. I typically use from Terminal >SET ^GO=0 and in code SET ^JOB($h)=$JOB FOR x=1:0 HANG 1 IF $GET(^GO) QUIT and of course Studio to attachor I use $system.CSP.Shell() as described here
go to post Robert Cemper · Nov 26, 2021 as official documentation tells you:https://docs.intersystems.com/iris20211/csp/docbook/DocBook.UI.Page.cls?KEY=GSQL_langelements#GSQL_langelements_ops_precedence USER>SET status=$SYSTEM.SQL.Util.SetOption("ANSIPrecedence",1,.oldval) USER>do $system.SQL.Shell() SQL Command Line Shell --------------------------------------------------- [SQL]USER>>SELECT 1+2*3+4*5 1. SELECT 1+2*3+4*5 Expression_1 27 ^^^^----------------------------------------------- [SQL]USER>>q USER>SET status=$SYSTEM.SQL.Util.SetOption("ANSIPrecedence",0,.oldval) USER>do $system.SQL.Shell() SQL Command Line Shell --------------------------------------------------- [SQL]USER>>SELECT 1+2*3+4*5 3. SELECT 1+2*3+4*5 Expression_1 65 ^^^^---------------------------------------------- [SQL]USER>> .
go to post Robert Cemper · Nov 26, 2021 Even the possibility of changing this elementary rule after 60+yearshas the power and the risk of breaking millions of lines of code worldwide.It's for people like you that are not willing to accept these rules thatthe introduction of Embedded Python is encouraged. With the same mindset,you may demand to revert from Italian, French Spanish, Portugueseto pure Latin as spoken by Cesar. Or for French to Occitan ?
go to post Robert Cemper · Nov 26, 2021 Forget about the week and put your long query into a subselect SELECT Sum(Dicos),Sum(Gen),Sum(Philo),Sum(Religion), Sum(SHS), .... FROM ( .... your long query )
go to post Robert Cemper · Nov 24, 2021 Just another strong argument for embedded PythonOr calling Py over $ZF() or CPIPE for older versions The code to convert XML to JSON is quite simple, just two lines.The xmltodict. parse() method will convert the XML to a python objectthat can then be converted to JSON. How to convert XML to JSON in Python – Step by Step guide(found by Google)
go to post Robert Cemper · Nov 23, 2021 I have not heard of that but it could be a good reason to use an existing solution based on Python or C++ or other as offered herehttps://developer.ibm.com/apis/catalog/aspera--fasp-manager-sdk/downloads/downloads.json
