go to post Robert Cemper · Nov 3, 2021 Utils.GetNumber('456') is a static expression and not depending on rows so it is calculated only once. do this changes: ClassMethod GetSomeNumber(intInput As %Integer, id ) As %Integer [ SqlName = GetNumber, SqlProc ] and your query SELECT Utils.GetNumber('456',ID), .... by adding ID you force a recalculation by a row dependency
go to post Robert Cemper · Nov 1, 2021 not so clear what you mean by MUMPS routine.if it is an .INT routine you just create an object from one of the ResultSet classes and execute the queryif it is a .MAC routine you may also use Embedded SQL which I don't prefer so much. And BTW. what is an IDX routine ??? What do expect by a VIEW? It is just a kind of store SQL statement.
go to post Robert Cemper · Nov 1, 2021 This total ODD ! But it works.The list doesn't allow Carret ^ for the positive Globalsfor globals to skip Carret ^ is required !!! ENS>set list="Ens.*.GBL,'^Ens.Me*.GBL,'^Ens.C*.GBL" ENS>ENS>set sc=$system.OBJ.Export(.list) ;; output skipped ;; ENS>ZWRITE ;processed Globals list("^Ens.ActiveMessage.gbl")="" list("^Ens.AppData.gbl")="" list("^Ens.BP.ContextD.gbl")="" list("^Ens.BP.ThreadD.gbl")="" list("^Ens.BP.ThreadI.gbl")="" list("^Ens.BusinessProcessD.gbl")="" list("^Ens.BusinessProcessI.gbl")="" list("^Ens.Debug.gbl")="" list("^Ens.DocClassMap.gbl")="" list("^Ens.JobStatus.gbl")="" list("^Ens.Mirror.gbl")="" list("^Ens.Queue.gbl")="" list("^Ens.Rule.gbl")="" list("^Ens.Util.IOLogD.gbl")="" list("^Ens.Util.IOLogI.gbl")="" list("^Ens.Util.LogD.gbl")="" list("^Ens.Util.LogI.gbl")="" list("^Ens.Util.ScheduleD.gbl")="" sc=1 My interpretation:First, a local array is collected, and then the negated subscripts are deleted (requiring now ^ !!)
go to post Robert Cemper · Nov 1, 2021 'Ens.Message*.gbl Exclusion does not work with * and GBL should be upper case
go to post Robert Cemper · Nov 1, 2021 Hi Dan ! ADD / CREATE is just wishful thinking. It is only able to EDIT an already EXISTING link.If it exists you get asked: "Overwrite ?" otherwise "Not Found" as you have seen. You must create first a dummy of type *.link.DFI that you have to import by DeepSee Folder Manageror better directly in Studio. You must then assign the correct name already there.Folder Manager can't rename or move it !! only Import/Export Here is a dummy link to start with. <?xml version="1.0" encoding="UTF-8"?> <Export generator="IRIS" version="26" zv="IRIS for Windows (x86-64) 2021.1.0PYTHON (Build 237U)" ts="2021-11-01 13:54:36"> <Document name="dummy.link.DFI"> <link xmlns="http://www.intersystems.com/deepsee/library" name="dummy" folderName="Links" shared="true" public="true" locked="false" href="" title="" description="" keywords="" owner="" resource="" timeCreated="" createdBy="" category="" bookCover="" > </link> </Document> </Export> Feel free to place a PRODLOG on that bug.I will not do it. I'm not willing to wait so long. I just recently received a closing message on another PRODLOG I had placed in early 2017.
go to post Robert Cemper · Nov 1, 2021 If this "HL7.{PID:AlternatePatientIDPID(1).ID}" just doesn't exist CONTAINS must fail.You could put your HL7 messages as input to a dummy DataTransformation to seethe available parts and their addressing and then apply it here
go to post Robert Cemper · Nov 1, 2021 WRC download > Components > ODBC Drivers hasODBC Driver, Cache and Ensemble, 2018.1.... several build for all supported Platforms
go to post Robert Cemper · Nov 1, 2021 CONTAINS wraps ObjectScript $FIND() and just checks raw characters.So no code conversion or Upper/Lower or anything else happens.Suggestion:dump the value you expect into a TRACE message and see what it really is
go to post Robert Cemper · Oct 29, 2021 that's correct.I see the need to understand the potential and the possibilitiies to apply if appropriate.Actually, we do this with SQL and it is totally normal [hopefully]It should be as normal also for Embedded Py
go to post Robert Cemper · Oct 29, 2021 In past, I have seen so many "re-invented wheels" on COS that were mostly kind of remakes ofexisting packages or solutions. Though this is impressive from a coding point of view,it is just a waste of energy from point of view of a project AND its maintenance.I had similar experiences with SQL that was refused by "experienced" programmersinsisting on horrible $ORDER() / $QUERY() constructs almost un-supportable, to gaina few microseconds of performance on a weekly report. The deeper reason: nobody explained it and trained them.That's the behaviour to avoid.
go to post Robert Cemper · Oct 29, 2021 some hints. use the opportunity to separate data from code. So you have already a new IRIS.DAT with all globals create a fresh IRIS.DAT to be used just for routine (classes, ... ) now you should have a clean start of your IRIS instance check if the globals are visible as expected, but neither classed not routines. now open 1 Studio on Caché and 1 on your target IRIS namespace next you can move all classes, routines, ... by drag&drop from Caché Studio to IRIS Studio this last step could also be an XMLExport of all code and XML input but you miss eventually required adjustments.
go to post Robert Cemper · Oct 28, 2021 I followed the first 3 sessions and just can strongly recommend following it.To my opinion, it is MUST to follow them for anyone developing in IRIS in the future.
go to post Robert Cemper · Oct 28, 2021 you set content-type application/x-www-form-urlencodedBUTis your content really urlencoded ? If NOT, decoding it may create some chaotic nonsense and definitely no XML
go to post Robert Cemper · Oct 28, 2021 It's definitely not me.As you seem to have not much background on IRIS you are probably on the wrong forum.It's neither the place for PHP nor MySQL
go to post Robert Cemper · Oct 27, 2021 @Olga Zavrazhnova@Lena Evsikova @Anastasia Dyubaylo Just watched your presentation. It was really GREAT !!You raised the level of presentation significantly.The most attractive presentation for me so far.It will be hard to top you.CONGRATULATIONS !
go to post Robert Cemper · Oct 27, 2021 4 questions: What is your experience in Intersystems ObjectScript ? Did you see this post? UPS - Webservice Integration UPS API is country-specific. Which country ? Which service do you plan to implement?
go to post Robert Cemper · Oct 27, 2021 code sniplet: set test="CONcatenate".url="" for i=1:1:$l(test) s url=url_"%"_$zhex($a(test,i)) write i=11 test="CONcatenate" url="%43%4F%4E%63%61%74%65%6E%61%74%65"
go to post Robert Cemper · Oct 26, 2021 Hi @Vic Sun , @Akshay Pandey :Just to complete this discussion.From Terminal I could run Py also from a JOB, and over CPIPE without problems.From Studio Output all this FAILS.Which makes clear that the process behind Studio is far away from being a normalIRIS/Caché process and just good for editing and compiling. FullStop.I would even assume that running COS commands was not planned but rather an accident that happened 20 yerars ago.
