In Oracle database, the synonym is an alternative name for objects such as tables, views, sequences, stored procedures, and other database objects.

You generally use synonyms when you are granting access to an object from another schema and you don't want the users to have to worry about knowing which schema owns the object.

Is IRIS SQL sintax has something like this: (oracle sintax)

CREATE PUBLIC SYNONYM suppliers
FOR app.suppliers;

This first CREATE SYNONYM example demonstrates how to create a synonym called suppliers. Now, users of other schemas can reference the table called suppliers without

Hey Intersystems Community-Member,

Following Issue: When I update a SQL table like (update OnlineV3Admin.ParameterApp set popuptext = '' where ID = '1') and then read it for my Json WebService there is a /"x00" in my Json.

What is the best option to disable that? I need here  a empty String and not /x00.

Any ideas?

Best regards,

Florian Hansmann

Hi Community,

See how to build a REST API with InterSystems IRIS in just five minutes, leveraging Docker containers:

⏯ Building a REST API with InterSystems IRIS

What is the best way to create an HL7 message from JSON input file?

We have JSON file available with data required for building the HL7 message . I am trying to use a standard file/FTP Business service to pick up the file and convert the input %FileCharacterStream into a dynamic Object and use the stand JSON features to read /process the data and build the HL7 message. 

Is there any other better way to do this? or any standard built-in functionality available in HealthShare? 

Thanks you for your help

Mary

Hello,

I need to create a util function that loops thru every character in the data, execute a $ASCII() against it. If it falls outside the realm of extended ASCII we toss it.

the function should receive a string, execute a for...loop across it's length and use $ASCII to evaluate the character. Also the function should return an output argument that indicates if the string is UTF8 valid or not.

could anyone help me with this?

Hi guys,

I have this method to create object from XML

ClassMethod XMLNew(doc As %XML.Document, node As %Integer, contOref As %RegisteredObject = "") As TruLaser.ProductionPackage
{
    Set id=""     Set tmpnode=doc.GetNode(node)
    Do tmpnode.MoveToFirstChild()
    Do {
        //compare data node to the string given by the NAMEOFEXPORTID parameter
        //which indicates the XMLNAME of the ids for this object
        If tmpnode.NodeData=..#NAMEOFEXPORTID {
            //get the text from this node; this corresponds to an id in the database
            Do tmpnode.GetText(.id)}
        } While tmpnode.

Hey all,

I am currently working on a website (with Angular) for displaying the results of UnitTests.

Everything is working fine, except that I can not run a test inside a ClassMethod.

I have 2 classes: One for handling which test class should be invoked and then a test class that is extending %UnitTest.TestCase

The test class:

Class my.class.path.testing.EingangTest Extends %UnitTest.TestCase{    Method CreateEingangTest() As %Boolean     {  
        Set eingangObj = ##class(My.class.path.Eingang).%New()        if $$$ISOK(status) {           set eingangObj.ezeichnung = "Testlager"

This message contains six recent HealthShare Advisories, which are available below.

• Advisory: Using Browser Back Button may result in user seeing two patient's data at once in Classic Clinical Viewer
• Advisory: Consent May Be Overridden at the System-Level for Clinical Information Type Consent Regardless of the "Allow Override Consent" Setting
• Advisory: Clinical Viewer Password Auto Completes when Saved
• Advisory: Migrating from Full HealthShare Kit to HSAP kit may later cause Caché to IRIS Conversion Issues
• Advisory: Moving to IRIS-based Health Connect or IRIS for Health from HSAP when

Those of you who run and support older-style legacy systems on IRIS may be interested in learning about and trying out a new framework I've built on top of my colleague Chris Munt's mg_web technology (details at https://github.com/chrisemunt/mg_web).

There are quite a few older-style and legacy applications out there whose useful life can be extended by making their functionality available as REST APIs.  To make this something that can be done quickly and easily, using modern, industrial-strength web servers, I've created what I'm calling mgweb-server:

https://github.com/robtweed/mgweb-server

Thi

GA releases are now published for the 2020.3 version of InterSystems IRIS, IRIS for Health, with IntegratedML!

This is the first InterSystems IRIS release that includes IntegratedML, a new feature that brings "best of breed" machine learning to analysts and developers via simple and intuitive SQL syntax. Developers can now easily train and deploy powerful predictive models from within IRIS, right where their data lives. Documentation for IntegratedML is available as a User Guide. Virtual Summit 2020 features a number of sessions and an Experience Lab featuring IntegratedML, see overview here.

Hello, I have an SSL / TLS configuration that used TLSv1.0 encryption.

However, I need to update to the TLS 1.2 version of encryption, and apparently Caché 2012.1 does not support it according to this link: https://community.intersystems.com/post/tls-v12-support-cach%C3%A9
 

Can I add a library to the Cache, enable TLSv1.2 in some way, or just a version update?

I am very pleased to announce that tomorrow (Dec 3) at 9 AM Cambridge time we plan to enable the new CCR UI for all users.  No downtime should be required for the go-live.   Existing beta testers will not see any change, but for non-beta testers the new Frost-based Angular UI will replace the legacy CSP-based application for the home page, navigation, System Details, and several other parts of the application.

We have had over 100 people from a wide variety of organizations beta testing this new interface for many months now, and we confident that it will be well received.

InterSystems has corrected a defect that may cause Windows Telnet processes that are secured using SSL/TLS to hang indefinitely; this may then cause an instance to become unresponsive. This defect is present only on Windows platforms.

This defect affects:

• Caché and Ensemble 2018.1.4
• HealthShare Health Connect (HSAP) 15.032 built on C/E 2018.1.4
• InterSystems IRIS and InterSystems IRIS for Health 2020.3

The problems caused by this defect can occur only when the instance is running Windows Telnet.

Hey Developers,

Here is a digest of the Developer Community videos on InterSystems Developers YouTube Channel in November 2020:

The aim of my question is to achieve this :

• User with authorization :

• User without authorization :

You can notice that some information of the PID segment are obfuscated.

I do have a solution but it involve a modification of EnsLib.HL7.Message. It's not a best practice.

Do you have idea or a simple solution that doesn't involve overloading every HL7 classes ?

Here is my solution :

https://github.com/grongierisc/hl7-msg-anonymizer

HL7-Msg-Anonymizer

This is a modification of EnsLib.HL7.Message to not display Patient demography information in visual trace.

This feature is toggle by a resource named

Does anyone know how to convert UTC to Eastern time in the DTL?  Input format "YYYYMMDDHHMMSS".

Can I use ConvertDateTime() function? If yes, what value do I use in these fields informat, outformat and outf?

Thank you.

Hi everyone,

I need to call a SOAP service using IRIS Interoperability and this SOAP service returns a Microsoft DataSet with a DiffGrams payload.

Do you know how to handle this kind of Objects ?

SOAP Payload Response :

<?xml version="1.0" ?>
<GetPatientsByClinicResponse>
    <GetPatientsByClinicResult>
        <xs:schema id="NewDataSet">
            <xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:MainDataTable="Patients" msdata:UseCurrentLocale="true">
                <xs:complexType>
                    <xs:choice minOccurs="0" maxOccurs="unbounded">

Hi Community,

We're pleased to invite you to the online meetup with the winners of the InterSystems Interoperability Contest!

Date & Time: Friday, November 27, 2020 – 10:00 EDT

What awaits you at this virtual Meetup? 

• Our winners' bios.
• Short demos on their applications.
• An open discussion about technologies being used, bonuses, questions. Plans for the next contests.

This XML file does not appear to have any style information associated with it. The document tree is shown below.

<definitions xmlns="http://schemas.xmlsoap.org/wsdl/" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns:mime="http://schemas.xmlsoap.org/wsdl/mime/" xmlns:s="http://www.w3.org/2001/XMLSchema" xmlns:s0="http://herenit.com" xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" targetNamespace="http://herenit.com">
    <types>
        <s:schema

Hello,

In Caché Management Portal yo can see the SQL privileges per table.

For example : http://localhost:57772/csp/sys/sec/%25CSP.UI.Portal.User.zen?PID=P#3 (Page "SQL Tables").

Is it possible to get them by objectscript or SQL ?

Regards.

I am getting the date 20201121090000 in the HL7 message, How do I convert it to 2020-11-21 09:00:00 in a easy way?

I am currently doing it by extracting the first 7 values and splitting as date and time and then adding a hyphen using substring.

Is there an easier way by using $ZDATE? or something like that?

Hi!

If you see this page you are in the InterSystems Developer Community!

You are very welcome!

This is the place where you can read about and discuss InterSystems products and technologies: InterSystems IRIS, Caché, Ensemble, HealthShare, DeepSee, and iKnow. 

What type of content can I find here?

We have three types of content on Developer Community(DC): articles, questions, announcements. And answers to questions. And videos.

The articles are about the best practices and experience with InterSystems technology and products.Both InterSystems employees and community members post articles.

Does anyone know about any documentation or sample code to create SFTP Business service in HealthShare? 

Thank you for your help.

I'm running Windows 10 x64 Pro 20H2 with Intersystems Cache ODBC driver v2018.01.00.184. I've setup a System DSN using the 64-bit of ODBC Administrator.

I've been getting inconsistent results using my regular application (Microsoft Power BI) which I use through ODBC to query my hosted TrakCare T2017 instance.

Using Microsoft ODBC Test Tool (part of MDAC 2.8 SDK) I can verify I get the same errors as in Power BI. They seem to be ODBC driver related but I can't pin it down.

ODBC Test Tool GUI shows:

 I am looking for any pointers on how Intersystems IRIS Health can monitor a filesystem/Folder that user/s /applications can drop in CSV files via FTP and load the file  to the IRIS DB . I understand that I will need create a record map for the CSV files, I am looking for any configuration references on how how to process files using file inbound adapters  with the  intent to pick up the CSV  file as they are dropped in the  target location and pass it to a Business process and ingest into the IRIS database 

Any help would be greatly appreciated ... 

Hi!

I need to solve a combinatorial optimization problem, like the Knapsack Problem.

I found some implementations, but they're memory inneficient. I also found libraries like this one from Google.

However, first I'd like to ask you guys for your experiences doing this kind of task in Caché/IRIS platform. Do you guys have implemented your own code or used a third party library?

Thanks, José

Hi 

I have a table where i want to create join query like

(select * from patients where facility=abc) qry1

left join (select * from patients where facility=xyz) qry2 on qry1.patientid = qry2.patientid