go to post Joseph Thottungal · Nov 2, 2016 Hi Alex, I added a new entry in OID registry under AA. So based on OID the code will be populated in the Patient Number field. I have a written a Custom SQL code to pull just the code for our downstream systems. The issue that I have is there are existing data in the DB with the OID instead of Code in the Patient Numbers field and I am looking for a way to update them without reprocessing all the files. RegardsJoseph
go to post Joseph Thottungal · Jun 16, 2016 Thanks Steve. Looks like the example has what I needed. I will try it and come back here if I run in to something that I am unable to foresee.
go to post Joseph Thottungal · Jun 16, 2016 Code sample for looping by creating new instance of the object in DTLHi,I am trying to use data transformation (DTL) to map a JSON to SDA. My elements in the source JSON is not one to one with SDA object. That means I have to add code to loop through these objects in order to complete the mapping. Can someone send me a sample that can look to create that? I am not very comfortable with scripting language used in Health Share. Appreciate your help.RegardsJoseph
