Hi:

We added a column to a table as follows 

Property SentTime As Ens.DataType.UTC;

And the code to populate this

if pStatus = "SENT" //set SentTime which is used in the Tableau Report
{
Set doc.SentTime = $$$timeUTC
}

For Historical records of type "Rejected" the Sent time is appearing though as 1840-12-31 00:00:00, we don't know why. Current docs work fine with this column just historical seems to display the default instead of blank/null. 

Hey Developers,

We're pleased to invite you to join the next InterSystems IRIS 2020.1 Tech Talk: Using Java and .NETon June 16 at 10:00 AM EDT! 

In this installment of InterSystems IRIS 2020.1 Tech Talks, we put the spotlight on extending InterSystems IRIS with your own custom Java and .NET code. We will demo how to create a custom interoperability component with the new Productions Extensions (PEX) feature. Following that, we’ll demo how to call Java or .NET code from any ObjectScript code.

Hi Developers,

Please welcome the new coding talk on InterSystems Developers YouTube:

⏯ How to Generate Modules for InterSystems Package Manager (ZPM)

Hi, 

call my web service (%SOAP from caché 2012 v) from XmlHttpRequest client generate  cors policy error, 

Any one help me how i can allow origin in headers requeste.

Thank you.

Hello,

I am having a problem with SQL Select, the command in portal is OK, show all items, but when I use a CacheDataAdapter in VB .NET show the message 'Incorrect list format 0>=0'.  What could be this message? Because is the same SQL command.

Best Regards.

Hi!

we are evaluating IRIS Data Platform as an OAuth2 Authorization Server with the use of the official Docker image. We currently struggle with the OAuth2 setup, as we are required to use https:// for the /oauth2/authorize and /oauth2/token endpoints, but the Docker container exposes only http:// in its default configuration. We have tried to find any hints in the docs but were not successful. Any help is appreciated.

Thanks

Klaus & Lukas

Hi all

Does anyone have an easy way of reading the cdata in the xml response returned buy a Webservice?

At the moment I have a XML class and then I use read.Correlate() to read through that XML bit.  

However, depending on the message I have different things in the CData and I don't want to create a class for each one of these.

The API returns the cddata as KeyValueOfstringstring.

My idea would be to send to my method the cdata as a parameter which is the KeyValueOfstringstring part of the response message and then deal with it...

Any help would be appreciated...

Best Regards

I've got a class that extends FTP.PassthroughService and utilizes the FTP.InboundAdapter.  In Business Service, I have the FilePath set as /tmp and the subdirectory level = 1.  How can I access the current file path (/tmp/subdir1) when there are files in /tmp/subdir1/test.txt for example?  The ..Adapter.FilePath only returns the FilePath setting in the Business Service/Adapter but not the subdirectory level.  Of note, it is a SFTP connection.  I can access the %Net.SSH.SFTP from ..Adapter.FTP.%sftpSession but don't see how to retrieve the current directory of the file being processed.

The Intersystems IRIS is a great platform to develop, run and consume Data Science services. IRIS can ingest data from any type, format, protocol and time using adapters. These datasets can be prepared with BPL, DTL and Object Script and stored as SQL or NoSQL data. Finally, it can be consumed by open ML algorithms inside IRIS and visualized in the IRIS dashboards. See more in:   https://docs.intersystems.com/irislatest/csp/docbook/Doc.View.cls?KEY=PAGE_data_science.

Looking for a fast, efficient IDE for developing ObjectScript code?

Check out ObjectScript with Visual Studio Code, a new video from Online Learning, which shows how to export ObjectScript packages from the InterSystems IRIS server and write ObjectScript classes and methods with Visual Studio Code.

Hi InterSystems Community,

Is there a way to have a logarithmic axis in a DeepSee widget?

Thanks,

Reid

In Episode 11 of Data Points, UX designer @Ksenia Samokhvalova joins the podcast to talk about the approach to user experience at InterSystems, how it may differ from commonly considered UX concepts, and what her team is doing to constantly improve usability with the developer's goals in mind. If you'd like to take a quick survey to get involved with UX testing for InterSystems technologies, you can do that here!

Hi, I have a timestamp of 201906192359 with a HL7 and I need to add a minute to it to get 201906200000. Is there an easy way within Healthshare to do this?

It seems easy enough within SQL but I cannot get the SQL to work within Healthshare,  this is what I have for SQL which does the job in SQL Server.

 SELECT REPLACE(REPLACE(REPLACE(CONVERT(CHAR(16),DATEADD(mi,1,STUFF(STUFF(@test,11,0,':'),9,0,' ')),120),'-',''),' ',''),':','');

Within Healthshare I've tried to use this SQL to populate a :dateout variable using this code but it isn't updating :dateout. (datein: = 201906192359)

Hi,

I am getting following message in Ensemble.

Hi developers!

We are starting InterSystems AI Programming Contest next week, and according to the rules, you can include some technology IRIS Features into your solutions, which will give you extra points in the voting.

Here are the technology bonuses for InterSystems AI Programming Contest!

1. IntegratedML usage - 2 expert vote points

IntegratedML is a new technology Introduced in InterSystems IRIS which you can use with InterSystems IRIS 2020.2 Advanced Analytics Preview release. IntegratedML:

• Gives users the ability to create, train, and deploy powerful models from simple SQL syntax without requiring data scientists.
• Wraps "best of breed" open source and proprietary "AutoML" frameworks including DataRobot.
• Focuses on easy deployment to IRIS, so you can easily add machine learning to your applications.

Learn more in IntegratedML Resource Guide.

You can use with IntegratedML template.

2. Python Gateway usage - 1 expert vote point

Python Gateway is an addon to InterSystems IRIS which gives you the way to use Python in InterSystems IRIS environment:

• Execute arbitrary Python code.
• Seamlessly transfer data from InterSystems IRIS into Python.
• Build intelligent Interoperability business processes with Python Interoperability Adapter.
• Save, examine, modify and restore Python context from InterSystems IRIS.

Learn more about Python Gateway.

You can use the Python Gateway template, which includes IntegratedML too.

3. Docker container - 1 expert vote point

The application gets a 'Docker container' bonus if it uses InterSystems IRIS  running in a docker container. 

Both templates, IntegratedML template and  Python Gateway template use docker so you can collect this bonus if you build your solution using these templates.

Or you can use any other Docker-based templates, published on Open Exchange.

Feel free to ask any questions about using the listed technologies.

Good luck in the competition!

Hi Community!

We're pleased to invite all the developers to the upcoming "ZPM – Package Manager for InterSystems IRIS" webinar on June 18th at 11:00 AM EDT. 

You will learn about the ObjectScript Package Manager Client called ZPM.

Speaker: 
@Evgeny Shvarov, InterSystems Developer Ecosystem Manager

What is ZPM and what awaits you at this webinar?

Good day all

I am a new developer in cache, I am trying to connect vscode to healthshare but i get the following error:

////Error: Error: Parse Error: Expected HTTP/////

Please help me on this.

My setting like this:

{

    "objectscript.conn": {

      "active": true,

      "label": "LOCAL",

      "host": "****",

      "port": 57772,

      "username": "***",

      "password": "***",

      "ns": "***",

      "https": false,

    },

    "objectscript.export.folder": "src", 

    "objectscript.serverSideEditing": false

  }

I have a set of strings that contains special characters. Im trying to write a sql query to remove all the special characters in the string. Im using Intersystems cache sql.

Example

%Lis&ten  - Listen

This is the first article from a series. I will provide details, using bpmn notation, how can I do to develop, deploy, secure, operate a consume IRIS digital services, linking with IRIS documentation. Each subprocess will be described with an individual bpmn diagram. This is the macroprocess.

Documentation links:

Good day all -

I am attempting to use the Data Transformation Builder (for ease of use for my other engineers) to build up a web service request object to send to an outbound operation. The source is a custom persistent class (extends Ens.Response, %JSON.Adaptor) and has serialized sub-class data elements and the request object is a custom persistent class (extends Ens.Request, %JSON.Adaptor.)

Hey Developers,

New demo show by InterSystems Sales Engineer @Eduard Lebedyuk is already on InterSystems Developers YouTube:

⏯ PythonGateway-Template Demo

In an earlier article (hope, you’ve read it), we took a look at the CircleCI deployment system, which integrates perfectly with GitHub. Why then would we want to look any further? Well, GitHub has its own CI/CD platform called GitHub Actions, which is worth exploring. With GitHub Actions, you don’t need to rely on some external, albeit cool, service.

In this article we’re going to try using GitHub Actions to deploy the server part of  InterSystems Package Manager, ZPM-registry, on Google Kubernetes Engine (GKE).

Hello Community,

I hope you are well.
I encounter a problem on IRIS for Unix 2020.1  when I try to create a PDF from a simple Dashboard on Deepsee : 

When I click on this widget , a tab appear and is loading for ~30 seconds, then shows 'error loading the PDF File ' :

I am also using DeepSee Web, and i encounter a problem if I try to Export the graph as a PDF : 

Is there a link between both problem ? ( If I fix the print widget, the PDF Export will also be fixed ? ) 

Where can I download the Cache ODBC drivers for Windows?

I went here https://wrc.intersystems.com/wrc/Login.csp but it said 

User is not enabled for WRC login. If this is unexpected, please contact InterSystems Support.

What does that mean? What do I need to do?

Running Cache 2017.2.2.

I'm trying to make a REST API call in JSON format. When using the example in the class reference documentation the getJSON method in the %Net.Http class throws the error  <METHOD DOES NOT EXIST> on a %Clone() method in the %LIbrary.DynamicObject class. I even changed the parameter to a JSON string to no avail. The  code will then fail on the %Compose method (examples below). My workaround is to use the %Net.HttpRequest functionality. Is there another workaround to this?

Example As Is:

I have a code tag that performs some logic in a DTL, and want to add to it the ability to find the number of substrings delimited by a dollar sign ($) within a particular string. I have tried the following which compiles just fine, but generates an error when testing in the Data Transformation Builder.

ERROR <Ens>ErrException: <SUBSCRIPT>zTransform+985^LH.IAMON.IAMONORU1XsformDTC2.1 *DCOUNT() Encoded subscript 1 > 511 bytes -- logged as '-' number - @' set lineCount = DCOUNT(reportBody,"$")'

Often we need to debug a Business Operation. Tracing and logging work but sometimes you want to work with a BO as with your local terminal session.

Here's how you can do that on any operating system.

Windows has a great tool for debugging Business Operations - Foreground mode. In that mode Windows launches a local terminal with operation job.

Note that there's  an issue with some InterSystems IRIS versions (older than 2021.1) which caused cterm launch instead of iristerm. To fix that you can either install Caché/Ensemble/HealthShare on a same server or run this reg file:

Hi All,

I was just wondering whether anyone can help, I have managed to configure LDAP within Healthshare [HealthShare Modules:Core:15.032.9688], and I am also able to login with my LDAP user.  However, I am unable to assign any roles to this user, the user  appears on the users page however, it does not appear in the dropdown list of users when you try to update a particular role in the roles page (I am not sure where I have gone wrong with this).  I can login with the user but I don't get any where far with it because it has no roles assigned to it.  Any help would be great.

Kind Regards,

Hi

Hi All,

I created Object Gateway. Earlier it was able to open but now it raising below error while trying to open. Can anybody assist how to make this to show list of Object Gateway which has been created already.

ERROR #5001: <ILLEGAL VALUE>zGatewayState+11^%Net.Remote.ObjectGateway.1

SOURCE ELEMENT: %ZEN.Component.pane ()

Thanks,

Asif