Question Ephraim Malane · Jan 12 Unable to create a table in SQL Explorer based on the select statement that joins multiple tables and to create a cube based on this table. Hi Community, I am attempting to create a new table by executing a SELECT statement that involves joining multiple tables. However, I encountered an error during execution: '( expected, AS found^Combined AS.' I would also like to create a cube based on this SQL table. However, during the cube creation process, I am prompted to specify a source class, and I'm unsure which class to use as it requires an existing class. Could you please help me identify the issue with the table creation, and provide guidance on selecting the appropriate source class for the cube creation?" #Relational Tables #SQL #HealthShare #InterSystems IRIS for Health 0 1 0 137
Question Ephraim Malane · Jan 8 New Dimension not populating data on the cube Hi Community, I hope this message finds you well. I am reaching out because I have encountered an issue with a new dimension I created, named "Region," and I could use your assistance in resolving it. The problem is that when I open the cube analyzer, the "Region" dimension does not populate data as expected. Instead, it merely displays the text "sourceRegion," which I specified as an expression in the architect. #Analytics #Analyzer #HealthShare 0 1 0 114
Question Ephraim Malane · Nov 21, 2023 Cookies penetration test remediations Good day, We recently had penetration testing conducted on our HealthShare clinical viewer and patient Index instances and below is the recommendation 1. Set a same-site cookie for identified CSPWSERVERID. Please advise where I can do this as I only saw this on web gateway settings and it has enable and disable options only. #HealthShare #InterSystems IRIS 0 1 0 197
Question Ephraim Malane · Oct 19, 2023 Web gateway add username and password authentication on a standalone on the web server Hi Community, We have web gateway installed as a standalone on the web server and when I access it through the direct link https://mydomain.com/csp/bin/Systems/Module.cxw, it doesn't require authentication it just opens as per screenshot below. #Key Question #Web Gateway #HealthShare 1 6 0 460
Question Ephraim Malane · Sep 28, 2023 Clinical Viewer Allergy chart not indicating that there is data. Good day community, Clinical Viewer Allergy chart has data but is not displaying the coloring to show that there is data. How do I fix this? #HealthShare 0 2 0 224
Question Ephraim Malane · Jul 31, 2023 InterSystems AllergyIntolerance FHIR resource DTL shows Severity value as SV and Category Food Allergy as FA Hi Community I am using a standard DTL for Allergy Intolerance but it shows codes for Category and Severity Columns on cliinical viewer. I have copied the standard DTL to my custom folder and I want to modify it to show descriptions for these two columns but I don't know how to do it. Please see the below DTLs for Category and severity and advise how I can change them to get descriptions. Category DTL section #HealthShare 0 5 0 143
Question Ephraim Malane · Jul 25, 2023 Working with Allergy FHIR Resource Hi Community I want a FHIR resource example that will populate allergies as displayed below, I am currently focussing on only allergies and not alerts. #HealthShare 0 10 0 230
Question Ephraim Malane · Jul 4, 2023 How to Configure Email Alerting on HealthShare based on the conditions from the messages received. Hi Community, Please give me an example on how to configure email alerting based on the rules and send out emails accrordingly. As a message comes into the business service component I want to check specific fields and if a field for example active = true i want to send it to a different email and if active = false I want to send it to a different email as well. Guide me on how to accomplish this requirement and let me know if InterSystems uses a default SMTP server or I must have that server in place. Regards #HealthShare 0 8 0 235
Question Ephraim Malane · Jun 29, 2023 How to retrieve a list of patient records that are revoked on HealthShare Unified Care Record? Hi Community, I would like to know how I can query a list of patients that were revoked on HealthShare for the month of April and May. Messages are sent using FHIR and a revoke is handled with active:false as seen below. A non-revocation will have active: true on the patient resource. I wanted to check SQL tables but I am not sure which one to check if so. Please advise on how to go about getting this report. Regards, #FHIR #HealthShare 0 0 0 146
Question Ephraim Malane · Apr 5, 2023 How to know which users did patient searches on clinical viewer Hi community, I would like to know how to know which users did patient searches on clinical viewer. I tried checking the audit database but I cannot seem to know if it's logged there and under which event. Please advise how to go about this. Regards, Ephraim Malane #HealthShare 0 2 0 325
Question Ephraim Malane · Mar 22, 2023 Patient Index Patient merge not updating worklist items Hi Community, There are two records of the same patient coming from the same source and when they are merged from the source they are not updating Health Information Exchange. I have blurred crucial information and the records are not falling off the worklist items after a merge from the source system. The two records from the same source are in the middle section and the right section. #HealthShare 0 1 0 282
Question Ephraim Malane · Mar 3, 2023 How to see who made changes to a global Hi Community, There was an entry missing on ODS global HS.XF.Config and there was a change not related to this deployed sometime around February by another team. How can I check who removed this entry and when on HealthShare? #HealthShare 0 2 0 283
Question Ephraim Malane · Jan 17, 2023 CCR transition to live shows critical error Hi Community, I have created Tier 1 CCR and when I move it to Live it shows the below error. I initially had changes deployed through a different CCR to the TEST environment and were not deployed to LIVE for the same class. I tried to cancel it so that I can move these latest changes but I still get the below message. #InterSystems IRIS 0 1 0 107
Question Ephraim Malane · Dec 22, 2022 InterSystems IRIS.DAT file corrupted Hi Community, My IRIS.DAT file is corrupted on one of my Edge productions in the development environment and as a result, I cannot start production. I would like to recover it if there is a way to do so, please assist. Regards, #Databases #InterSystems IRIS 0 8 0 571
Question Ephraim Malane · Dec 13, 2022 Add users to the workflow on Patient Index Hi Community, How do I include the users on the Patient Index worklist to be part of the users on the arrow below? #HealthShare 0 1 0 154
Question Ephraim Malane · Dec 6, 2022 FHIR Practitioner seacrh by PRACTITIONER return only one record Hi Community, I need assistance to query ODS FHIR server to retrieve only one record.At the moment I am getting multiple records returned as seen below. Is there a way to specify a parameter that will return a single record instead of 21 because it's the same practitioner returned 21 times. #HealthShare 0 2 0 154
Question Ephraim Malane · Dec 5, 2022 %Identifying what is consuming space in the HealthShare Installation (Linux machine reports AWS install Disk Space Utilization reached 80%) Hi Community, Can someone assist me to check why HealthShare Iris install disk space increased, I want to know what contributed to Disk space utilization increase as it it now running at 81%. I am running Redhat Linux machine which is hosted on AWS. #HealthShare 0 8 0 227
Question Ephraim Malane · Oct 19, 2022 Remove text within quotes in a string I am reading file values by position with comma-separated string and it gives me incorrect values on the below line because there is a comma within double quotes within a string. I would like to remove any text that has quotes with object script or alternatively separate each value with pipe-delimited so that I can return position 8 as code and position 9 as a description #InterSystems IRIS 0 2 0 273
Question Ephraim Malane · Oct 17, 2022 Error when searching for a patient with medications on clinical viewer Hi Community, I am getting the below error when searching for a patient who has medications on the clinical viewer. What could be the issue? #HealthShare 0 3 0 190
Question Ephraim Malane · Oct 13, 2022 How to convert xlsx to csv Hi ommunity, I am downloading an Excel xlsx from the web with the below method and saving it as xlsx, how do I convert and save xlsx as csv? #InterSystems IRIS 0 6 1 464