I was never able to get this to work, and now I have another case where I need to do something similar as I have a linked table that is dynamic and need to use as a filter in a router. Can someone see what I might be doing wrong?
ERROR <Ens>ErrException: <UNDEFINED>zTransform+134 ^osuwmc.EpicOMStoMatSysTecsysBkLoad.1 *%Ensemble("FeederScottRouting") -- logged as '-' number - @' set bp = %Ensemble("FeederScottRouting")'
I think I found a way to handle it but I am struggling on how to send an Ens.Request message to another Operation in the middle of a DTL. I tried this through a function, but Ensemble does not recognize the SendRequestSync that I am trying to send.
Is it possible to send another message to another Business Operation using Code/Function in the middle of a DTL?
For those that do not know what those tools are and are just getting into SQL, navigating around the tool within IRIS/HealthShare can be difficult at times. Even trying to use those tools can be complicated in setting up the necessary connections and settings.
go to post
I was never able to get this to work, and now I have another case where I need to do something similar as I have a linked table that is dynamic and need to use as a filter in a router. Can someone see what I might be doing wrong?.png)
Thanks
Scott
go to post
I am not quiet sure your syntax is correct is probably should be
..Piece(source.{PV1:AlternateVisitID},"~",*)
or
source.{PV1:AlternateVisitID(~).IDNumber}
https://docs.intersystems.com/healthconnectlatest/csp/docbook/DocBook.UI.Page.cls?KEY=EEDI_virtual_property_paths
go to post
One way you can do this is using the function Piece.
https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=RBAS_fpiece
go to post
I keep getting the following...
ERROR <Ens>ErrException: <UNDEFINED>zTransform+134 ^osuwmc.EpicOMStoMatSysTecsysBkLoad.1 *%Ensemble("FeederScottRouting") -- logged as '-'
number - @'
set bp = %Ensemble("FeederScottRouting")'
go to post
So...
%Ensemble("%Process") should be the Business Process (aka Router) that is calling the original DTL?go to post
I think I found a way to handle it but I am struggling on how to send an Ens.Request message to another Operation in the middle of a DTL. I tried this through a function, but Ensemble does not recognize the SendRequestSync that I am trying to send.
Is it possible to send another message to another Business Operation using Code/Function in the middle of a DTL?
go to post
You could use Piece to separate the values in Par_Locations.
go to post
For those that do not know what those tools are and are just getting into SQL, navigating around the tool within IRIS/HealthShare can be difficult at times. Even trying to use those tools can be complicated in setting up the necessary connections and settings.
go to post
I would like to see a more modern SQL management/editor within IRIS.
go to post
Ok thanks.