You don't need a function.

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

Best Regards.

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?

"AdmitDateTime.timeofanevent" is the correct specification.

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

Don't rely too much on this !

w $System.SQL.CEILING(1.000000000000000001)

2

w $System.SQL.CEILING(1.0000000000000000001)

1

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")

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.

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.