15 + years Solutions-oriented Integration Interface Specialist with notable success directing a broad range of corporate IT initiatives while participating in planning and implementation of Integrated solutions in direct support of business objectives. Specialties: Design/Development of MS and Oracle SQL Databases, HL7 Ancillary Solutions, and Intersystem Ensemble Solutions. Integrating it all together to create a more robust environment.
While working with Intersystems Ensemble and now IRIS, I have greatly expanded my knowledge of Ensemble and Cache Object Script by asking questions and watching the Developer Community. I tend to ask questions, then figure out the answers on my own or with a little help from others.
Before Intersystems Ensemble, I spent many years as an eGate developer. Specializing in DART, JDBC, and other out of the normal odds and ends.
I was able to get it to work. I found that in Cache I need to call %Get("<column>") name vs what I am doing in a BPL.
s Loc = ""
s tStatement = ##class(%SQL.Statement).%New()
s execall= "CALL osuwmc_Utils_EnterpriseDirDb.InterfaceCheckConnectMedCtrID(?)"
s qStatus = tStatement.%Prepare(execall)
if $$$ISERR(qStatus) {write "%Prepare failed:" do $SYSTEM.Status.DisplayError(qStatus) quit}
set rset = tStatement.%Execute(pInput)
while rset.%Next() {
set Loc = rset.%Get("OSUguestRoleDTL")
}
if $Length(Loc) = 0 {
set Loc = "OSUWMC"
}The Class name is osuwmc.Epic.Clarity.DepartmentMaster and it is storing data in
- Data - ^E2C8.D9IS.1
- BitmapExtent Index - ^E2C8.D9IS.2
- IDIndex Index - ^E2C8.D9IS.3
- IDKey Index - ^E2C8.D9IS.1
- Indexes - ^E2C8.D9IS.I
- Stream - ^E2C8.D9IS.S
I am not sure what to put in as the Global Name, would that be E2C8? and then the subscript to be mapped would be D9IS.*?
I have an Identifier that I receive in an HL7 MFN message, I need to take this Identifier and find the Locations that the Identifier is associated with, so I can set the Sending Facility value within the HL7 message to help filter out specific locations from being sent to the Health Share Provider Directory.
for example... ID1 might be associated with Site 1, Site 3. IF site 1 is valued and equals xxx, then send on else do not send on.