go to post Michel Bruyère · Sep 9, 2019 You don't need a function.Length(HL7.{PIDgrpgrp().ORCgrp().OBXgrp().OBX:ObservationIdentifier.identifier},)=0Best Regards.
go to post Michel Bruyère · Aug 23, 2019 I don't have a great knowledge about InterSystems plans.But, generally, you just should first delete your plan and then recreate the index.35 seconds were quite important!How much records or mostly probably different jointures on tables?
go to post Michel Bruyère · Aug 21, 2019 "AdmitDateTime.timeofanevent" is the correct specification.Also is better to write ="0000" but it's work your way.
go to post Michel Bruyère · Aug 9, 2019 Don't rely too much on this !w $System.SQL.CEILING(1.000000000000000001)2w $System.SQL.CEILING(1.0000000000000000001)1
go to post Michel Bruyère · Feb 27, 2019 The solution is for a "EnsLib.HL7.Service.FTPService" service :Method OnProcessInput(request As %Stream.Object, Output response As %RegisteredObject) As %Statusrequest.Attributes("FTPDir")
go to post Michel Bruyère · Feb 26, 2019 These files require transformation. They are HL7 messages and need segment changes according to the directories.I don’t see any property that will also give a directory name: Attributes ("filename") is not the solution, unfortunately>>> They should be deleted from the sftp server once transferred?It’s already been done.Any COS example will be very helpful.
go to post Michel Bruyère · Jan 9, 2019 Your "SendRequestAsync" method is only available for Process.And to be purist, in that case, it must be:set tSC = ..SendRequestAsync(..JSONOperation,stream,"0",,..MetadataContext) /// send the stream to operationNothing to do with the reponse parameter.Best Regards.
go to post Michel Bruyère · Nov 9, 2018 Thanks for your answer.The second possibility is the one I use but we are never sure that the field will be fulfil (SetIDOBX).The first one, I didn’t know that “RawContent” is available this way. That’s the one that definitely I choice.