Question Christine Nyamu · Oct 9, 2024 SQL Query Help Hello all, I need help with coming up with a SQL query that pulls only one value. I have a case where two providers share the exact same name. Each has a different NPI number and IdentityTypeId. I tried the below query - output is also below. #SQL #InterSystems IRIS for Health 0 18 0 112
Question Christine Nyamu · Mar 22, 2024 Comparing Two Lists/ Variables Is there a way to compare the content of two variables/ lists and if they share a common element/ value return 1? Example the two below both have "Yellow": Set y = "Red, Green, Orange, Yellow" Set x = "Purple, Black, Yellow, Pink" The lists I am working with have over 30 elements/values that vary so it is difficult to hard code it to say look for "Yellow". #InterSystems IRIS for Health 0 12 0 284
Question Christine Nyamu · Mar 14, 2024 Adding " " to a string Is it possible to add quotations " " so that it is part of the output? For example: set b = "Cat" Set c = b w c giving an output of "Cat" as opposed to Cat. #InterSystems IRIS for Health 1 7 0 370
Question Christine Nyamu · Feb 27, 2024 Get Yesterday's Date I am trying to figure out how to get yesterday's date in object script in the format yyyy-dd-mm. Any help would be greatly appreciated. #InterSystems IRIS for Health 0 2 0 172
Question Christine Nyamu · Feb 8, 2024 Randomize Value in a Field Is there a way to randomize the value that will appear in a field. For example, if I want MSH 3:2 to be either "SAD", "MED", "TEN", "BOB", "RAN", how do I code the DTL to just randomly assign a value? #InterSystems IRIS for Health 0 6 0 193
Question Christine Nyamu · Jan 31, 2024 De Identify PHI Any ideas on how I can easily de identify production messages so that I can use them in TEST? #InterSystems IRIS for Health 0 2 0 139
Question Christine Nyamu · Jan 25, 2024 Comparing two contexts in a BPL in an IF I am able to capture two values in two separate contexts in the BPL. One through an API call and another by looking at the contents of PV1:7. These are context.Prov and context.ProvName. I am checking to see if the values contained in the contexts are the same and if yes process further and if not stop. In the IF statement I tried the below but none worked. Can someone please tell me what I am doing wrong. The trace does show that they are the same value so that's not it. 1. context.Prov = context.ProvName 2. "context.Prov" = "context.ProvName" and #InterSystems IRIS for Health 0 4 0 143
Question Christine Nyamu · Dec 7, 2023 How to find the Index of a segment that contains a certain value in the DTL I have an interface with repeating DRG segments with messages coming in as DRGgrp().DRG(1). I know how to find the count of DRG groups: (source.{DRGgrp("*")}) BUT I am stuck at how to find the index of the segment that has DRG.1.3 having a specific value = "PMP". Any ideas please? Thank you #InterSystems IRIS for Health 0 6 0 279
Question Christine Nyamu · Nov 27, 2023 Using the Message viewer to find specific value in trace set in BPL I have a BPL that I set up a trace to check if the ProcRsltStatus Order is 1. Because the trace is set up in the BPL, I am having issues in searching traces that have the 1 in the message viewer. Any idea how I can limit my search to only the ones with ProcRsltStatus Order::1? Thanks in advance. #InterSystems IRIS 0 6 0 192
Question Christine Nyamu · Oct 9, 2023 How to truncate OBX 5 values that are being evaluated by BPL I have a BPL that checks if at least one of the incoming OBX 5 values exists in TestTable. If the value exists it gets passed to Operation A and if it doesn't exist it gets passed to Operation B. The lookup table has keys that range between 10 to 70 characters. However, the incoming message sometimes has OBX 5 values that are greater than 510 characters which causes the BPL to terminate and the message does not get sent to any operation. #InterSystems IRIS for Health 0 9 0 224
Question Christine Nyamu · Sep 14, 2023 How to do a SQL query in DTL and map PV1 7.1 to results of query I need to run a SQL query and use the output to map PV1 7.1. The query is : SELECT IDFROM TestTableWHERE ProviderName = 'TEST,PROVIDER' AND IDType= 'BPI' When I run this query with the 'TEST PROVIDER' I do pull the ID in question but I can't figure out how to do it from the DTL given that there are various providers sent in PV 1 7 . Any assistance will be greatly appreciated. #SQL #InterSystems IRIS for Health 0 8 0 401
Question Christine Nyamu · Aug 31, 2023 How to Search If OBX 5 contains a certain value in consecutive OBXs in BPL I need to search for the following values "SEDATION: " and "Procedure" In consecutive OBX 5 as seen below. Note that sometimes the OBX 5 containing "Procedure" may be followed by other characters/text hence I am leaning towards using a contains statement. #InterSystems IRIS for Health 0 8 0 377
Question Christine Nyamu · May 12, 2023 HOW TO SEARCH IF A STRING EXISTS IN A LOOKUP TABLE Hello, #InterSystems IRIS for Health 1 8 0 513