Dear Community, 

We're pleased to invite you to the InterSystems Iberia Summit 2020, which will take place from February 18th to 19th in Barcelona, Spain!

You're more than welcome to join us at the Melia Barcelona Sarriá Hotel!

HI I am using below code to retrieve the last inserted ID of the table. It works when we do not set any custom column as IDKey. If we define any column as 

IDKey below code does not return any IDKey. I know when i am defining any column as IDKey its not auto generated , but whats the best way to get the ID column value

            String sql = "INSERT INTO TestFramework_UI_Data.Execution (TotalTestSteps) VALUES (0)";
            //ResultSet rs = createExecutionSt.executeQuery("SELECT * FROM TestFramework_E2E_Data_TestData.TestCases");
            int t =

Hi, I try to do a JS script into a csp page for a Workflow

The problem is that in Ensemble i don't had troubles but in Iris don't recognize even the console.log inside the script

I attach the code

   <form>
<table class="workflowtable">
<CSP:IF CONDITION='%task.%FormValues.IsDefined("montoDeposito")'>
<tr>
<td>
Monto Depositado:
</td>
</tr>
<tr>
<td>
<input type="text" 
name="montoDeposito"
value="#(%task.%FormValues.GetAt("montoDeposito"))#">
</td>
</tr>
</CSP:IF>
<CSP:IF CONDITION='%task.%FormValues.IsDefined("numFolio")'>
<tr>
<td>
Numero de Folio:
</td>
</tr>
<tr>
<td>
<input  type="text"
name="numFolio"
id="numFo

Hi Developers!

I stuck with one interesting problem. 

For example, let's use this template repo. If you build this container A using docker-compose and then run the container it exposes REST-API  which is available on:

localhost:52773/person/all

The question is how to make this REST-API accessible from another docker container B running on the same machine? E.g. with IRIS 2019.4 Community from this repo?

The problem is that for the second container localhost it's something which belongs to container B.

I think I need to set up a network between containers somehow. E.g. using docker-compose. But is there any simpler way?

Some of you on the Developer Community have probably interacted with @Luca Ravazzolo if you are interested in cloud and container topics... If so, you'll enjoy Episode 2 of our new podcast — we chatted with Luca about Kubernetes and the InterSystems Kubernetes Operator. He does a great job of explaining the technology and its benefits here!

I'm using Cache SQL and want the ability to choose a specific index.

I've boiled the problem down to one table and simplified the query down to

SELECT *
FROM Registration.PatResp
WHERE SchedApptNum=8450022

SchedApptNum is indexed, but instead of using that column, "Show Plan" indicates that it's looping through the entire Registration.PatResp table on Id (the primary key for the table).

I've done a tune-table with no change.

SQL provides %IGNOREINDEX, which allows me to ignore a specific index, but I don't need that.  I need the reverse - %CHOOSEINDEX so that I can force SQL to use a specific index.

Hello,

We would like to get the XML which is being given by the requested system, directly to our Service output.

We have tried to just output directly the Message Response as follows:

Method findCandidatesXML(mensEntrada As %XML.GlobalCharacterStream(CONTENT="MIXED")) As Mensajes.Response.GestionPacientes.operacionResponse(XMLNAME="mensSalida") [ Final, ProcedureBlock = 1, SoapAction = "http://SCS.Servicios/GestionPacientes/findCandidatesXML", SoapBindingStyle = document, SoapBodyUse = literal, WebMethod ]
{
    set ^tipoMensaje="XML"
    $$$LOGINFO("El mensaje es de tipo: "_^tipoMensaje)

Hi guys,

I need help because I have no idea how to proceed further and documentation does not explaining this solution.

I have XML like this:

<?xml version="1.0"?>

<ProductionPackage xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" JobName="10006_8046_L69">

  <Barcode>1200002101</Barcode>

  <DueDate>31.12.5000 23:59:59</DueDate>

  <BasicMaterial>1.0038</BasicMaterial>

  <RawMaterial>St37-120</RawMaterial>

  <RawMaterialThicknessUnit>mm</RawMaterialThicknessUnit>

  <JobNote />

  <CreatedBy>stko</CreatedBy>

  <ChangedBy>stko</ChangedBy>

  <Workplace

Hi Community,

The new video from Global Summit 2019 is already on InterSystems Developers YouTube:

⏯ InterSystems IRIS on HCI

Hi: 

I'm new to Cache and intersystems. 

We have a live production solution that uses a file inbound adapter to collect pdf documents off a fileshare. This fileshare is accessed by many services and access is controlled to the files by AD.

A problem we are seeing is that documents either are attempted to be processed with a filesize of 0kb or more often a file gets processed that in the next buisness process then cannot be moved to a working directory and the file does not appear in the archive from the file inbound adapter.

Last week at the InterSystems BeNeLux Symposium, we announced the publication of the InterSystems iKnow Natural Language Processing technology to Open Source. This enables developers and researchers to take advantage of this unique technology at any level of their application stack, workflow or experiment.

Hi,

i have a DTL with generic source request (Inbound TCP).

i have added a parameter in the request class and compiled.

how do i now refresh or resync the DTL so that i see the new added field in the source.

Thanks

Hello everyone

Here is a try of sending a stream object with %ToJSON() by HTTP POST request on a remote server.

First the JSON structure:

{
    "document": {
        "id": "{43495441-4445-4C4C-4500-0500129C762E}",
        "patient_id": "5003171TC01",
        "language": "fr",
        "doc_type": "CONS",
        "doc_time": "2019-06-12 11:02:00",
        (...)
        "Sections": [
            {
                "sectionId": "main",
                "Content":

This is more a WARNING than a question

Dasha.AI is a platform that allows you to create and manage voice interfaces for your applications. One of Dasha’s distinctive features is that most users believe they are talking to a human, not a robot.

Voice is the most natural way for people to interact. Dasha allows to use voice interface to interact with your application as naturally as communication between people.   

The voice interface cannot completely replace the traditional user interface of the application, but some tasks could be perfectly solved with the help of the speech interface.

First of all, these tasks include well

Hello,

We would like to convert a string which represents a dynamic JSON object, to a JSON.

We have:

linea: {"app_id":"5cf57b56-c3b4-4a0d-8938-4ac4466f93af","headings":{"en":"Cita Atención Primaria","es":"Cita Atención Primaria"},"subtitle":{"en":"C.P.ISORA","es":"C.P.ISORA"},"contents":{"en":"Aqui el contenido del mensaje si aplicase","es":"Aqui el contenido del mensaje si aplicase"},"data":"{\"centro\":\"C.P.

Hi Community,

Please welcome the new video on InterSystems Developers YouTube, recorded by @Patrick Jamieson:

⏯ A Healthcare Data Management Solution - What Kinds of Data

You may have seen earlier this week that we launched a brand-new learning podcast called Data Points! There are three episodes released, one of which was a really interesting discussion with Thomas Dyar — a product specialist here at InterSystems focused on machine learning. Take a listen and reach out if you're interested in exploring more about IntegratedML!

Preview releases are now available for the 2020.1 version of InterSystems IRIS and IRIS for Health!

 Kits and Container images are available via the WRC's preview download site.

The build number for these releases is 2020.1.0.199.0.  (Note: first release was build 197, updated to 199 on 2/12/20)

 InterSystems IRIS Data Platform 2020.1  has many new capabilities including: 

• Kernel Performance enhancements, including reduced contention for blocks and cache lines
• Universal Query Cache - every query (including embedded & class ones) now gets saved as a cached query
• Universal Shard Queue Manager

Preview releases are now available for the 2020.1 version of HealthShare Health Connect!

 Kits, Container images, and evaluation keys are available via the WRC's preview download site.

The build number for these releases is 2020.1.0.199.0.  (Note: first release was build 197, updated to 199 on 2/12/20)

HealthShare Health Connect 2020.1  has many new capabilities including:

• Healthcare Interoperability
  
  • FHIR R4 Support
  • HL7 Productivity Tools
• API Management
  
  • InterSystems API Manager
  • Open API/Swagger Specification-First REST Development
• New Look in the Management Portal
• SQL

Hello,

We would like to store a list into a global. The need is to get the full Web Service's Response Message, because of currently, our Operation sends the message to the Process, whith an empty list:

We have created a copyList which is a clone of the list which is being returned from the web service client:

set copyList = ##class(%ListOfObjects).%New()
 set copyList = pResponse.RSPK21QUERYRESPONSE.%ConstructClone(1)
 $$$LOGINFO("copyList: "_copyList)
 $$$LOGINFO("copyList count: "_copyList.Count())
 $$$LOGINFO("copyList.GetAt(1): "_copyList.GetAt(1))
 $$$LOGINFO("copyList.PID8: "_copyList.GetAt

Hello,

We would like some help:

We have found that in the following code:

Class Operaciones.SOAP.Gasometros.GestionPacientes.SeleneHL7Service Extends Ens.BusinessOperation [ ProcedureBlock ]
{

Method operacion(pRequest As Mensajes.Request.GestionPacientes.operacionRequest, Output pResponse As Mensajes.Response.GestionPacientes.operacionResponse) As %Library.Status
{
 Set ..Adapter.WebServiceClientClass = "WSCLIENTE.GestionPacientes.ConsultaCandidatos"
 Set MSH=pRequest.MSH,SFT=pRequest.SFT,QPD=pRequest.QPD,DSC=pRequest.DSC
 Set tSC =

Hi, everybody, 

I've been reading some posts in the community but I haven't been able to come to a conclusion. Here's my point.

I have a cache code, and following this guide https://cedocs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?… but I can't understand how to run this from jenkins for example, without using the console, and thus automate the process. That is to say, if it were possible to do it, what steps should I follow.

Thank you very much

I understand RecordMaps can be used to send delimited files through a production without custom coding.The data segments are delimited by tilde character followed by $Char(10) in Linux/Unix.When I test the same IO data in Windows, I have $Char(13) and $Char(10) instead of just $Char(10).I like to use just tilde character for record delimiter and ignore $Char(13) and $Char(10) between the tilde and the leading data of the next segment / record.Is this good idea or not if someone wants to generate classes will it override code?I believe in X12 schema it ignored leading control characters.

Is possible config a docker-compose.yml to start arbiter-2019.4.0.383.0-docker.tar alone ? 

What parameter you need ?

i can't find a simple sample

Hello,

We would like help to know why our web service which gets Patient's ID number, does not accept messages?

We observe its Event Log, and it contains the following pattern:

We detail each log to give info to discover what's happening:

First there is a new connection:

Then it suddenly disconnects

After that it looks like the service restarts:

The next one is interesting: it outputs that UTF-8 encoding is invalid, inside EnsLib.SOAP.InboundAdapter

We have searched for UTF-8 inside SOAP.InboundAdaptar and we find it here:

Set tCT=$S(tCST:"binary/CST; charset=UTF-8", ""'=tCT:tCT, 0=tLen:"", tSOA

I am moving some DeepSee components to another environment and would like to know if the pivots and dashboards have to reside in the "Other" branch of the Workspace in Studio.

Thank you,

LG

I've recently encountered a HS Caché that won't start informing that Collation 30 is not available, but I have not found an easy way of knowing what collation is 30.

I've found that the following command returns the ones from the current locale, but not from all locales:

Set Rset = ##class(%ResultSet).%New("%Library.Collate:CollationList")

d Rset.Execute()

While (Rset.Next()) {zw Rset.Number_": "_Rset.Name}

Thank you

Hello,

I am playing around with an HL7 business rule set and a EnsLib.HL7.MsgRouter.RoutingEngine component. I'm wondering how I can get the routing engine to fire a rule when a response is received from a business operation.

I have a simple "debug" statement in my rule to log the "Source" value when a message is received.This debug statement only seems to fire when the message comes as a request from the business service (trace item #1 below).