All
Accepted answers
Michel Bruyère · Oct 3, 2019 go to post

Maybe a "stupid" answer

But 

You need perhaps to specify "/directorya/directoryb" without the slash.

I have checked where I am working with have around 10 ftp connections and all specifications without the slash.

Michel Bruyère · Sep 30, 2019 go to post

1) $replace(pRequest.GetValueAt("MSH::MessageType.MessageType),"^","") instead of pRequest.GetValueAt("MSH::MessageType.MessageStructure",,tSC)

2) $e($zdt($h,8),1,8) instead of $tr($zdt($h,3),"-: ","")

Michel Bruyère · Sep 12, 2019 go to post

SELECT TOP ALL FirstName||' '||LastName AS DisplayName, UserType, IsActive, RoleName, DOB FROM LISDB.ExternalUsers
Where FirstName||' '||LastName Like '%Praja%'

Michel Bruyère · Sep 9, 2019 go to post

You don't need a function.

Length(HL7.{PIDgrpgrp().ORCgrp().OBXgrp().OBX:ObservationIdentifier.identifier},)=0

Best Regards.

Michel Bruyère · Aug 23, 2019 go to post

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?

Michel Bruyère · Aug 21, 2019 go to post

"AdmitDateTime.timeofanevent" is the correct specification.

Also is better to write ="0000" but it's work your way.

Michel Bruyère · Aug 9, 2019 go to post

Don't rely too much on this !

w $System.SQL.CEILING(1.000000000000000001)

2

w $System.SQL.CEILING(1.0000000000000000001)

1

Michel Bruyère · Feb 27, 2019 go to post

The solution is for a "EnsLib.HL7.Service.FTPService" service :

Method OnProcessInput(request As %Stream.Object, Output response As %RegisteredObject) As %Status
request.Attributes("FTPDir")

Michel Bruyère · Feb 26, 2019 go to post

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.

Michel Bruyère · Jan 9, 2019 go to post

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 operation

Nothing to do with the reponse parameter.

Best Regards.

Michel Bruyère · Nov 9, 2018 go to post

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.