go to post Robert Cemper · Jul 5, 2023 #1 is correctYour calculation #2 is seriously wrong.reasonreading documentation you seedformat -2 $ZDATETIME returns an integer specifying the count of seconds from a platform-specific origin date/time. This is the value returned by the time() library function, as defined in the ISO C Programming Language Standard. For example, on POSIX-compliant systems this value is the count of seconds from January 1, 1970 00:00:00 UTC And that's the mistake:Your BirthDate is obviously considered as LOCAL timeAnd therefore the difference you see reflects the time offset of your machine to UTC-19800 sec => -5.5 hrssystem variable $ZTZ will show your offset to UTC in minutes => -330my guess: your machine is running at local time in India
go to post Robert Cemper · Jun 30, 2023 for $ZTDH:https://docs.intersystems.com/iris20231/csp/docbook/DocBook.UI.Page.cls?KEY=RCOS_fzdatetimehfor $ZDT:https://docs.intersystems.com/iris20231/csp/docbook/DocBook.UI.Page.cls?KEY=RCOS_fzdatetime USER>r x 1997-08-09 10:38:39.700000000 USER>w $ZDTH(x,3,,9) 57199,38319.7 USER>w $zdt($ZDTH(x,3,,9),3,7) 1997-08-09T08:38:39Z USER>w $zdt($ZDTH(x,3,,9),3,7,9) 1997-08-09T08:38:39.700000000Z USER>
go to post Robert Cemper · Jun 28, 2023 what you describe is explained in detail in the documentation:%SQL.StatementResult For a SELECT statement, if the cursor is positioned after the last row, the value of %ROWCOUNT indicates the number of rows contained in the result set.At any other time, %ROWCOUNT contains the number of rows retrieved thus far. rfm
go to post Robert Cemper · Jun 26, 2023 win docker desktop not just consumes fast-growing vhdxbut also a lot of temp files, that get never deleted or shrinkednot even with deinstall / reinstalltypically in C:\Users\<usename>\AppData\Local\Temp\docker-scout\sha256 C:\Users\<username>\.docker\scout\sbom\sha256C:\Users\<username>\AppData\Local\Temp\ *.ico, *.vhdx
go to post Robert Cemper · Jun 17, 2023 in Caché it is %installdir%/mgr/cconsole.logand you can see it from MgmtPortaland it would be helpful if you uncover the primary language you use
go to post Robert Cemper · Jun 17, 2023 in your namespace you can map not just full Globals to a different Database but also parts of a Global.This works over Global Subscript DetailsIF your structure is ^HISTORY(yyyymm, ....) [yyyymm as first subscript ]? eventually also your IDKEY ?this is a possible way to set ^HISTORY(201606) >> 201606_HIPAA.dat ^HISTORY(201607) >> 201607_HIPAA.dat But if yyyymm is just somewhere in your data, you need to reorganize your globalI assume this is something you have to do anyhow with your history ATTENTION: this is total static.so for 120 DBs you need 120 mapping lines
go to post Robert Cemper · Jun 9, 2023 If not disabled all global SET and KILL and also transactions are documented in JOURNALthere are also related search utilities available in %SYSthere is no equivalent feature for Global READ.if you just look for the fact that there was a SET or KILL at object levelDSTIME could be an option see example: https://community.intersystems.com/post/synchronize-data-dstimeit is easier to handle than JOURNAL
go to post Robert Cemper · May 20, 2023 see doc on Variable Number of Parameters Summary: args = number of params passed args(n) = n-th param modify as you need, it's just a local variable
go to post Robert Cemper · May 16, 2023 Just to rephrase your issue: you expect a JSON array of JSON objects [{..},{..},{..} ] but you get a JSON object containing that array {"cursos": [{..},{..},{..} ]} ;; asssumptio input holds the received obj set jobj={}.%FromJSON(input) ; convert to obj set jarray=jobj.%Get("cursos") ; content of "cursos" = [..] set output=jarray.%ToJSON() ; convert to string docu: %Library.DynamicObject
go to post Robert Cemper · May 10, 2023 ClassMethod SortVersion(input As %DynamicArray) As %DynamicArray { Set sorted = [] Set val = "" Kill order For i=1:1:input.%Size() Set order(input.%Get(i-1))="" For { Set val=$o(order(val)) Quit:val="" do sorted.%Push(val) } Quit sorted }
go to post Robert Cemper · Apr 26, 2023 I have a straight Caché only Docker available for you:Here is the GitHub Repo until publication on OEX is approved
go to post Robert Cemper · Apr 25, 2023 If you need Caché in Docker you may use this examplehttps://community.intersystems.com/post/using-ecp-across-iris-and-cach%C3%A9An individual license is only required if you want to use ECPIt's the single user version 2018.* and should fit your needs
go to post Robert Cemper · Apr 16, 2023 MUCH more simple and shorter kill set a=##class(Sample.Person).%OpenId(2) set b=##class(Sample.Person).%OpenId(12) set c=##class(Sample.Person).%OpenId(111) set obj=$zobjref("2@Sample.Person") ;; BINGO zw a=<OBJECT REFERENCE>[1@Sample.Person] b=<OBJECT REFERENCE>[2@Sample.Person] c=<OBJECT REFERENCE>[3@Sample.Employee] obj=<OBJECT REFERENCE>[2@Sample.Person]
go to post Robert Cemper · Apr 7, 2023 I just saw this. if accepted tenantnow it's clear what is expected processand now my deployments are visible, FIXED.
go to post Robert Cemper · Mar 27, 2023 if you take a look to method ##class(EnsLib.HL7.Segment).getAtFromArray(...)you see that the segment data is assembled in row 1008 of the class by Set data=data_value without checking the size.So it is designed to fail with large documents as your Base64 encoded PDF (~+33% of original)So just using a reference to an external stored file as you suggested should work. BTW datatype %VarString is just a shortcut of %String(MAXLEN="") and a sometimes appropriate SQLTYPE.
go to post Robert Cemper · Mar 17, 2023 by using {} your Jsonobj is already a %Library.DynamicObjectUSER> ZWRITE JsonobjJsonobj=<OBJECT REFERENCE>[1@%Library.DynamicObject]no need for Set Dynjsonobj=##class(%Library.DynamicObject).%FromJSON(Jsonobj)
go to post Robert Cemper · Mar 15, 2023 I found an acceptable workaround. installed telnetd into the container and started it mapped some external port to port 23 set this external port in my cube started the IRIS Terminal BINGO ! You may raise all concerns on Security and Container Isolation. Accepted! And ignored!Since THIS solves my issues on optical verification of the user interface.
go to post Robert Cemper · Mar 6, 2023 $system.Util.InstallDirectory()classmethod InstallDirectory() as %String Returns the location of the installation directory, i.e. that which is displayed by ccontrol on Unix and VMS, where the .cpf configuration file is kept.
go to post Robert Cemper · Mar 3, 2023 If you are not afraid of using basic COS functionality:your reload method raises a LOCK ^myRELOAD and drops it with completion LOCK -^myRELOAD Your check utility does the same but with a timeout LOCK ^myRELOAD:0if it fails - signaled by $TEST=0 you loop and hang around and retryfor success $TEST=1 you go on but release your successful LOCK immediatelynot to block anyone else.