Hi guys,
Is it possible to apply business rule on a XML without Schema?
Say, I'm trying to make some business rules on FHIR XML payload. I transferred the XML stream as an EnsLib.EDI.XML.Document in a BPL and passed it to a General Business Rule.
Set context.xmlDocument = ##Class(EnsLib.EDI.XML.Document).ImportFromLibraryStream(##class(HS.SDA3.QuickStream).%OpenId(request.QuickStreamId))I'm handling following XML document
With this rule
Then I got stuck at visiting the elements in the XML.
I.e How may I evaluate the profile value？
Thanks。
Hi Guys,
I'm helping a partner to integrate IRIS to their project. They want to integrate Rules in there system.
For testing I built a simple rule as below:
This demo program is used to show how a custom FHIR profile can be employed to validate data compliance. The custom FHIR implementation guide was developed based on FHIR Version R4, and in this example implements the Organization resource extension to validating data compliance.
Installation
Hi, guys,
A client is trying to launch a irishealth community docker image on centos 7.6 but failed
How to fix the problem? Thanks.
Hi guys,
I'm working on a project with my client.
They have a visit table which has about 7,000,000 records. The table is used in a random search page witch holds 20+ conditions to be combined.
The table is defined as below:
Hi guys,
Suppose I have a JSON string as below:
{"MessageID":"11111","save_date1":"2022-02-02 01:01:34","Sender_ID1":"esb","sent_date2":"1985-12-11 11:42:00"}
The two date variables are all formatted as ODBC date time, when I tried to import it to a %JSON.Adapter object, the date format was rejected as below
Error #9406:Unexpected format for value of field, save_date1, using class base mapping
Thus I'm trying to format all possible ODBC date time in the incoming JSON with Regular expression:
Hi，guys
My client is using IRIS 2021.1 Interoperability and they want to highlight the sessions with unresolved(without resent and completed operations) errors so their maintenance team can have a list of unresolved sessions to check against.
When I'm working on it, it seems to be it is is difficult to decide whether a session have unresolved errors. For example,
Hi guys,
A client want to programmatically list all namespaces and whether they are interoperability or not. Do we have apis or sql to do that? Thanks.
I've tried several methods of %SYS.Namespace but did not find it yet. Also when I use sql to select from %SYS.Namespace through jdbc, it always return an empty result set.
Hi guys,
How to find out the number of active connections (including SQL, http, tcp and all remote connections) of an IRIS instance? A core based license is used.
I've checked the document and find %SYS.ProcessQuery.
I'm currently using this sql:
select count(distinct Pid) From %SYS.ProcessQuery
where ClientIPAddress is not null
and ClientIPAddress <> '127.0.0.1'
and ClientIPAddress <> 'localhost'
and IsGhost = '0'
Is it accurate or do we have a better option?
Thanks in advance.
Hi guys, I'm calling a java method as below:
Hi guys,
My client has a requirement to add a column of random numbers to the query result.
I wrote a function as below:
Class Utils.SqlUtility Extends %RegisteredObject
{
ClassMethod GetSomeNumber(intInput As %Integer) As %Integer [ SqlName = GetNumber, SqlProc ]
{
Return $R(intInput)
}
}
But in the returned sql result, every row share the same value, as below,
SELECT Utils.GetNumber('456'),
ID, Citizenship, DOB, FirstName, Gender, IDNumber, LastName, PatientNumber, PhoneNumber
FROM CDR.Patient
How may I refactor the function or sql to make the random value really random on each of the rows?
Thanks.
Hi guys,
How can we remove a business host from a running production?
I've read and tested how to add it to a production, while when I try to remove it from the production with the following codes:
Hi guys,
We are connecting to a 3rd party SOAP web service. The wsdl looks like below
Please notice that the portType was defined as /cvpService.
Then when we are trying to use SOAP Wizard to generate a client for the service, we will encounter the following error which prevented the generation
It seems that '/cvpService' can not be used as a valid class name (or even method name) thus the generation failed.
Thus I have 2 questions about the failure
Hi guys,
In our clients environment, multiple sources will connect to one DB (all through JDBC connections) and perform various operations. Sometimes they found some data was deleted without reason. Thus they want some feature like SQL Server Database Audit Specifications that can log who at what time with which IP deleted data in a specific DB.
I've checked IRIS Audit but I didn't find feature about that . How can we audit and log delete of a known DB? The deletions might be performed by delete statament or truncate table stattement.
Thanks.
Hi all,
I added an additional shard node to an existing shard by accident.
After the add， it can not be removed and query from the master shard now fails. I did not find any data from shard master in the shard node.
How to recover it and remove the shard node from the shard master?
Thanks.
Hi guys,
I have a customer trying to extract data from Hive. I've tried to use Data migration to migrate a table into IRIS with JDBC driver. But the migration task always fails as below
Then I tried to create a link table, the task fails too with the following error:
I've tried several ID combinations such as rowkey+userid, userid + datatime, the results are all errors caused by stream property.
The source table are composed of only Hive string fields.I wonder how may I migrate Hive tables into IRIS. Thanks.
Hi, guys,
I've written a DT for a partner which transfers a csv file into SDA3.
I', using record map to gather data from a folder storing csv files and using the DT to tranfer the records into sda3 entities.
The followings are the codes of that DT:
Class POC.DT.CSV2SDA3 Extends Ens.DataTransformDTL [ DependsOn = (User.PhysicalExam.Record, POC.SDA.Container) ]
{
Parameter IGNOREMISSINGSOURCE = 1;
Parameter REPORTERRORS = 1;
Parameter TREATEMPTYREPEATINGFIELDASNULL = 0;
XData DTL [ XMLNamespace = "http://www.intersystems.com/dtl" ]
{
Hi guys,
I'm helping our client to pass a Chinese CHIMA FHIR certification, which requires to search encounter by subject(Patient) name.
I noticed that in FHIR specification, chained parameters were included, as below:
2.21.1.4.13 Chained parameters 
Hi folks,
One of my clients want to project a null property of a cache object to an empty XML element. Say, if we have a class:
Class Diabetes.BS.Message.LabReportMessage Extends Ens.Request
{
Property Report As %String;
Property IsRisky As %Boolean;
Property RiskValue As %String ;
}
If the instance of this class has a null RiskValue, after projection, they want the XML as following:
<LabReportMessage>
<Report>Somestring</Report>
<IsRisky>1</IsRisky>
<RiskValue/>
</LabReportMessage>
Is there any way we can do it? Thanks.
Hi, guys,
One of my clients was required by the hospital to name their webservice operation as Action_Subject, ie. Get_PatientInfo
When I define the web method as "Get_PatientInfo" as below,
/// MyApp.MyService
Class MyApp.MyService Extends %SOAP.WebService [ ProcedureBlock ]
{
/// Name of the WebService.
Parameter SERVICENAME = "MyService";
/// TODO: change this to actual SOAP namespace.
/// SOAP Namespace for the WebService
Parameter NAMESPACE = "http://tempuri.org";
/// Namespaces of referenced classes will be used in the WSDL.
Parameter USECLASSNAMESPACES = 1;
Hi guys, I'm helping one of our customer to use unattended install to standardize their deployment. I'm using Unattended Installation and Installation Manifest.
Although I can use the combination to install HealthConnect and then create namespaces and DBs as they need, there are still several tasks that I did not find the solution yet. As following:
1. Configure mirrors
2. Set the directory to store journals
3. For a given Ensemble name space, configure the period length in purging messages.
4. Set up some scheduled tasks to PurgeErrorsAndLogs or PurgeAudit
Hi guys,
I'm trying to immigrate some of my HealthInsight dashboards and pivot tables to another HS instance.
In some pivot tables, I defined them with a set of calculated dimensions defined in the analyzer, e.g as below:
Then when I exported the cubes and pivot tables in used to my new envirmonment. When I open my pivot tables again, the calculated dimensions are missing and hence my pivot tables no longer work:
Is there any way to export those calculated dimensions so that I can used them else where?
Hi there,
I'm trying to develop a program calling Cache REST service twice with Cors. The first is fetching some information of a patient with GET request, the second is using obtained information to call another REST service(implemented in the same class though) with POST to perform other tasks.
Hi, guys,
I'm working on zen report to display an examination report for a client.
They stored order information in several tables. Examination findings and diagnosis were recorded in a html page and codes of the page was stored in another table. We need to put them together in one single report.
So far we can only read the html codes from that table which is a whole page since it start from label <html> and have <header>. We know that if we are using javascript we can display the page by assigning the codes to innerHtml property of an iframe object.