Question Warren Oyco · Feb 21 SQL Table - Data Cleanup Hi Community, I've created a method in my File Service to do a cleanup for every file load. Currently, I've set it to delete data when LastUpdated date is greater than maxdate. However, I want to do a cleanup for every new file load. Any suggestions or advice on how to do this? Thanks! Method Cleanup(){ #Business Service #SQL #HealthShare 0 0 0 39
Question Warren Oyco · Sep 19, 2024 Schedule Setting on Business File Service Hi, Is there a way to set the SettingSchedule on a EnsLib.File.PassthroughService at 9:00 am to 9:30 am but only end of the month? #Beginner #Business Service #Frontend #Tips & Tricks #Ensemble #Health Connect 0 4 1 82
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 199
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 793
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 598
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 492
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 440
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 483