Thank you for your reply, this was very useful as I could not figure out why Status='Suspended' was not returning any rows in the raw mode. You have saved me a lot of time :)

Thanks again.

Salma

Hi 

I am looking for something very similar to this as I would like to pick up suspended messages and resubmit them using SQL.  Are you able to advise how I could modify the SQL in your code to filter suspended messages?

Thank you for your help.

Kind Regards,

Salma

Hi 

This is great thanks, it's exactly what I was looking for.  Thank you so much.

Kind Regards,

Salma

Hi 

Thank you for your reply, I am already using the gitlab hook within Studio, what I wanted to do was export all the files with the relevant folder paths which I have done so using ##class(%SYSTEM.OBJ).ExportAllClassesIndividual however, if I create a project and try to export the files from within studio I can't find an easy way of maintaining the folder structure, it just exports all the classes in to one folder.

Kind Regards,

Salma

Hi Jenna,

I was interested in doing something that you are mentioning.  Do you have anything that could start me off?

Thank you.

Kind Regards,

Salma

Hi,

Thank you for your comment are you able to provide me with an example? My assumption is that you are suggesting to define a class and create a list of objects which then get passed back to the BPL. At the moment I have a SQL resultset which I have assigned to a snapshot and returned it to the BPL. 

Kind Regards,

 

Salma

 

Salma

Hi

 

This is what my business operation looks like method looks like.


Method GetResultspRequest As GOSHPackage.Messages.PPID.Request.MyRequest, Output pResponse As GOSHPackage.Messages.PPID.Response.MyResponse) As %Status
{
Set tSC = $$$OK
Set pResponse = ##class(GOSHPackage.Messages.PPID.Response.MyResponse).%New()

Try
{
Set tSC = ..Adapter.Connect()
Throw:($$$ISERR(tSC))
Set tSC = ..Adapter.SetAutoCommit(1)
Throw:($$$ISERR(tSC))
$$$LOGINFO("2")

Set tQuery = "SELECT top 3 surname, forename FROM [dbo].[tblTest]"

//set tQuery =..Adapter.Query
$$$LOGINFO("3")
Set tSC = ..Adapter.ExecuteQuery(.tResults,tQuery,)


Throw:($$$ISERR(tSC))

set snap=##class(EnsLib.SQL.Snapshot).%New()
set tSC = tResults.GetSnapshot(.snap)
set pResponse.TestRS =snap
Throw:($$$ISERR(tSC))
$$$LOGINFO("5")
}
Catch tException
{
Set tSC = ##class(%SYSTEM.Status).Error(tException.AsStatus,tException.Name_" Threw an Error "_tException.DisplayString)
}                                                                          
Quit tSC
}

This populates the snapshot however when I am trying to get the response back in to the BPL I get the following error

 

ERROR <Ens>ErrBPTerminated: Terminating BP PPID Shadow Processor # due to error: ERROR <Ens>ErrException: <INVALID OREF>zOnResponse1+2^GOSHPackage.Process.PPID.PPIDShadowProcess.Context.1 -- logged as '-' number - @' Set status=1,context.TestRS=callresponse.TestRS' > ERROR <Ens>ErrException: <INVALID OREF>zOnResponse1+2^GOSHPackage.Process.PPID.PPIDShadowProcess.Context.1 -- logged as '-' number - @' Set status=1,context.TestRS=callresponse.TestRS'

 

I am unsure whether this is the right approach, any help would be appreciated.

 

Thank you.

 

Salma

Hi All,

 

Thank you all for your comments, I am currently using 2017.1 of Healthshare/Healthconnect, I am assuming I can use Atelier with this version.  How different is Atelier to studio and are there downsides to using Atelier.  Thank you so much for your help.

 

Kind Regards,

 

Salma

 

 

Salma

Hi Both,

Thank you for the suggestions, the fundamental requirement is that the PDF file needs to reach the target folder before the xml.  Also these files come in pairs so before processing it is important to check that the matching xml actually exists.  What I ended up doing was once the check was complete move the xml file in to a secondary folder which was getting polled by another business service, the xml would only reach the secondary folder once the PDF had been processed and archived this resolved the issue but again I am not sure whether it was the right solution.

I will give your suggestion a go too.  Thanks again for your help.

Kind Regards,

Salma