Question Warren Oyco · Aug 3, 2023 Calculate and Update Value on SQL for Existing Data Hi, Any recommendations on how i can add a logic if an incoming record that is already existing in the table but different total amount value. I need to subtract the totalamt value on the input file vs the totalamt value on the table and update the table with the difference of totalamt. Any help is much appreciated. Thanks! #ObjectScript #SQL #InterSystems IRIS 0 1 0 121
Question Warren Oyco · Jun 13, 2022 Comparing Dates Hi, Any suggestion on how to compare dates? Below is my code but it does not seem to work. USER>w $zdate(zdateh(x,8),1) > $zdate($zdateh(y,8),1) When I set x to "06/01/2022" and set y to "04/01/2022" gives me an output of 1 When I set x to "09/01/2019" and set y to "04/1/2022" still gives me an output of 1 Any help is appreciated. Thanks! #ObjectScript #HealthShare 0 7 0 568
Question Warren Oyco · Jul 27, 2021 How To Pass Custom Class I've created a custom class that extends to the standard HS.Message.PatientSearchRequest. Inside the custom class i just want to pass the data as input only. But i am getting ERROR #6277: Type attribute, s01:AcoPatientSearchRequest, does not specify valid type for XML input tag: pRequest (ending at line 5 character 171)</error> I tried adding Parameter XMLIGNOREINVALIDTAG = 1; and #Code Snippet #SOAP #XML #HealthShare 0 8 0 481
Question Warren Oyco · Jul 16, 2021 Setting filename and file target folder in Business Process class Hi! I am working on a project where I use record map to transform a flat file and split it into two output text file and in the future will need to split four output files. I only want to use one target business operations instead of multiple. Is there a way to set the output file and the target folder path in my business process class? Any advice on how I can achieve this or is this possible? Thanks! #Business Process (BPL) #Coding Guidelines #HealthShare 0 5 0 390
Question Warren Oyco · May 20, 2021 Transform data output into a batch flat file text pipe delimited I am working on tweaking our current patient load process. The roster input is in text pipe delimited format, parsed out and transforms it to a standard HS.Message.PatientSearchRequest, and send to business process for patient matching. Result is transformed into a standard ADT HL7 message using EnsLib.HL.Message class. I would like to know if there is another class I can use that will transform my output to a text flat file pipe delimited instead of HL7 format? any advice on how to do this is greatly appreciated. Thanks! #DTL #HL7 #ObjectScript #HealthShare 0 2 0 322
Question Warren Oyco · Jul 18, 2019 cache basics date conversion How can I convert date format ddmmmyyyy to yyyymmdd in cache?example: 14JAN1991 to 19910114 #Code Snippet #Caché 0 2 0 453
Questions