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?"

0 1
0 138

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.

0 1
0 115

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.

0 1
0 198

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

0 5
0 145

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

0 8
0 236

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,

0 0
0 146

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.

0 1
0 283

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.

0 1
0 107

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

0 2
0 274