I'm currently implementing an interface solution to send through data to community pharmacies here in the UK from our hospital PAS system. As part of this project i have created a BPL which calls a SQL operation to infiltrate our Data warehouse and add to the message - this is all done and working as i expect.
What I now need to implement is something through Workflow- the idea is the hospital pharmacy team wish to approve and authorise the message before it is sent onto the outbound operation, so i have set up the workflow, set up the actions to enable the pharmacist to approve / reject., and as part of that i have taken some of the fields within the HL7 message, set to context variables and then im able to pull those into the workflow task request as %Formfields and %formValues, which works great for single fields. This is then arranged via a custom form/ csp page.
What im wondering is if it is possible at all to "tabulate" a repeating HL7 segment (in this instance OBX) and then display that within the form e.g:
HL7 Message example (its all test data)
Custom workflow form: (note not finished so ordering all over the place, and just put the HL7 message into the form just so i could see it.)
Ive assigned the values within the custom form to context variables, and they can then be pulled into the form which works great
How (if possible) can i do similar with a repeating segment within the HL7 Message - can i "tabulate" that information and display it at all?
Open to suggestions of course- first time I've used BPL and workflow, certainly the first time workflow has been considered in our trust so not a lot of knowledge out there.
Thanks in advance - happy to give further detail where required.