Hi everyone, 

I am currently sending an HTTP POST request to an EnsLib.HTTP.Service service (which has an EnsLib.HTTP.InboundAdapter associated). 

Here the request URL: http://10.41.11.210:57772/csp/healthshare/dce/POSTServiceClass.cls?rpyT…

From the documentation I have read (https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls?KEY=EHTTP_inbound) I get that the form variables are written into the request body in case of a POST. I have also implemented the OnInint() is this way to enable the form variables parsing: 

Method OnInit() As %Status{Set ..Ad

Hi all...

I am testing this project:

https://intersystems-community.github.io/webterminal/
 

Is there any way to be able to record a log of what is done on this terminal?
 

Does anyone use this in production?

I need  to ran a task on a specified days (once a month but a different day each month).

How can I do that in Task Manager?

Hi Community,

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

⏯ The Value of Developing with Containers

If you work with anything other than English, you would earlier or later encounter the characters from the title or just plain ??????????.

Encodings are usually known, but sometimes you just get gibberish and need to make sense of it.

In this cases $zcvt is your friend, the three argument form specifically.

But there are a lot of options. So here's an utility script to check how the text would look like in different encodings:

Write "Locale name: ",Ref.Name, !

Hot on the heels of the QEWD-JSdb announcement, QEWD-baseline provides a ready-to-run baseline environment for developing REST APIs.

The QEWD-baseline repository (https://github.com/robtweed/qewd-baseline) includes a fully-detailed tutorial on how to build RESY APIs using QEWD and the QEWD-JSdb database (running of course on IRIS).

https://github.com/robtweed/qewd-baseline/blob/master/REST.md

Included in the tutorial is:

- fully-worked examples, including how to integrate QEWD-JSdb's abstraction of the IRIS database 

- advice on debugging QEWD REST APIs

- how to use QEWD Sessions for user

ObjectScript has at least three ways of handling errors (status codes, exceptions, SQLCODE, etc.). Most of the system code uses statuses but exceptions are easier to handle for a number of reasons. Working with legacy code you spend some time translating between the different techniques. I use these snippets a lot for reference. Hopefully they're useful to others as well.

///Status from SQLCODE:set st = $$$ERROR($$$SQLError, SQLCODE, $g(%msg))  //embedded SQLset st = $$$ERROR($$$SQLError, rs.%SQLCODE, $g(rs.%Message)) //dynamic SQL///Exception from SQLCODE:throw ##class(%Exception.SQL)

A demo in traditional style COS

This was written based on a previous trial in .XLS
It is far from being perfect. Rather a challenge for
improvement in all directions (code, interface, ...)
So anyone feel invited to make it better.

USER>d ^SUDOKU5
;; Welcome to this SUDOKU demo !
;; you may solve your SUDOKU easier or create your own
;; under each box entry you find a list
;; of allowed values for this box
;; fill in numbers 1..9 as you need
;; to clear a box enter any character or blank
;; to stop enter . or , for the solver enter ?
;; navigate between boxes by cursor keys <>^v
;;
go:

Is it possible to save HL7 messages to a csv file?  Record Mapper appears to allow a service to import a csv and convert to HL7, but can you reverse that and save to a csv?

Hi Community,

This week we have two new videos from Global Summit 2019. Please welcome:

1.   An ML Toolkit for InterSystems IRIS: Co-Innovation in Healthcare

This is a basic JavaScript Vue.js example how you can use REST calls using plain HTML.

Good day,

We upload images into the database with this code :

<tr>
<td align="right">FileName</td>
<td><input type=file size=200 name=FileStream></td>
</tr>

s FullFilename = %request.Get("FileName")
s FileName = ##class(%File).GetFilename(FullFilename)
s ItemImage.FileName = FileName

s ItemImage.fileSize = %request.MimeData("FileStream",1).Size
d ItemImage.Image.CopyFrom(%request.MimeData("FileStream",1))

The need is now to be able to copy a document (example as attached in an email) and paste to be saved into the  ItemImage.Image
%GlobalBinaryStream

Has anyone done something like this ?

Thanks

André

Hi,

   I've heard from two different sources the SMP (or parts of it) and for sure the DTL front end (in studio? via SMP?) have been rewritten to be more modern.  But on a latest IRIS Community download everything looks the same to me.  Am I missing something or is this Marketting Spin?

  ^{Hopefully I won't get banned for this post aswell......}

Olá pessoal,

Compartilho material de um curso desenvolvido por mim, espero que possa ajudar a comunidade.

English:

Hi folks,

I share material from a course developed by me, I hope it can help the community. The material is in Portuguese.
 

Link: https://www.linkedin.com/posts/cristianojs_material-te%C3%B3rico-activity-6608421528906285056-sr8E

I am generating the DDL from a modeling tool - ERStudio. But the DDL has 2 issues right now.

DROP TABLE schema_name.<Table_Name> CASCADE CONSTRAINTS; The Constraints is not supported but works with the statement - DROP TABLE Study_Definition.EVENT_STORE CASCADE;

Second if there is no object to drop, it throws an error, so is there a check like in sql server If_Exists that we can use in CacheDB?

For simplicity sake let's say that we talk about active production.

I need to know if the business host is added to the production or not.

Currently I have:

do ##class(Ens.Director).IsItemEnabled("HostName", .sc)
set defined = $$$ISOK(sc)

Which looks like a workaround.

Hello,

I've got a table with many attributes and data. There is 10 000 000 registrations approximatly.

I need to make a research on this table with filters, paging,  and order.

You can see an example of my  SQL request : 

SELECT * FROM ( SELECT TOP ALL  * FROM ANCV_Data.Titre WHERE etatTitre = 'Emis' ORDER BY numRemise desc) v WHERE %vid BETWEEN 1 AND 25

Cause there are many data on my table, my SQL req is  too long if I don't have index on my attributes BUT there are many associations possible...

Are they any solutions ?

Regards,

I have the following class: 

Class temp.test7 [ Owner = {PHOENIXDBUSER} ]{ClassMethod GetTenAssets() As %Status [ ReturnResultsets, SqlProc ]{s sc=$$$OKs sql="SELECT TOP 10 * FROM Data_Assets.Asset"s sqlStatement=##class(%SQL.Statement).%New()s sc=sqlStatement.%Prepare(sql)if $$$ISOK(sc) {s result=sqlStatement.%Execute()d %sqlcontext.AddResultSet(result)s %sqlcontext.%SQLCODE=result.%SQLCODEs %sqlcontext.%ROWCOUNT=result.%ROWCOUNTs %sqlcontext.%Message=result.%Message} else {s %sqlcontext.%SQLCODE=-460,%sqlcontext.%Message=##class(%SYSTEM.Status).GetErrorText(sc

Hi Community,

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

Hi Community,

New session recording from Global Summit 2019 is available on InterSystems Developers YouTube Channel:

⏯ The Data Management and Analytics Landscape

Want to see how IRIS can be used in a radically-new way, as a JavaScript-based Multi-model database?

Take a look at QEWD-JSdb: https://github.com/robtweed/qewd-jsdb

Full instructions on how to try it out on the AWS IRIS Community Edition are included in the repository.

Hi,

What is the best practice when adding FHIR extension to Patient resource? To not to lose it when updating Patient base class etc.

Krystian

I am writing an API that sends over a very large JSON object. 

The code I'm using to get the data is actually used in our production system today for the use of writing a report.

However when I call the code using the API (using SoapUI) I am getting 'Error getting response; java.net.SocketTimeoutException: Read timed out'

The web applications settings have a session timeout setting at 15 minutes, but this is timing out within just a few minutes, so I know it's not hitting this mark.

Has anyone experienced this issue with APIs?

This post provides further detail on the suggestions from the DeepSee Troubleshooting Guide about what to do if a user is not able to view a listing in a DeepSee cube, but instead sees errors like this:

ERROR #5540: SQLCODE: -99 Message: User <username> is not privileged for the operation [zfindStatement+118^%SQL.DynamicStatement.1:<namespace>] (8)

Hello,

I have a couple of IOT devices that communicate via WebSockets to our backend.

I successfully managed to create a websocket connection between server and (iot)client using %CSP.WebSocket
However I would like to implement authentication on this using the HTTP headers at the same time of Connection: Upgrade.

I tried to set the headers to globals in order to debug but they are always empty.

Example code: 

Method OnPreServer() As %Status
{
Try {
    s ^Header("HTTP_AUTHORIZATION")=%request.GetCgiEnv("HTTP_AUTHORIZATION")
    s ^Header("AUTHORIZATION")=%request.GetCgiEnv("AUTHORIZATION")

A quick start guide to connect Ensemble to RabbitMQ using the RabbitMQ Java Client, a Java proxy class and the Ensemble Java Gateway.

Word and PDF documentation, source code and utilities available at https://github.com/toncat/ensemble2rabbitmq.

#Software Versions Server

• Windows Server 2012 R2 x64
• Erlang OTP 19.1
• RabbitMQ Server 3.6.5
• RabbitMQ Java Client 3.6.5

Client

• Windows Server 2012 R2 x64
• Java JDK SE 8u111
• RabbitMQ Java Client 3.6.5
• Ensemble 2016.2.0.736.0

#RabbitMQ

##Install Server http://www.rabbitmq.com/install-windows.html

Download and run the Erlang Windows Binary File

Download and

Hi folks,

how do people run iris-community edition nowadays? It seems there are some incantations needed that are not documented here: https://hub.docker.com/_/intersystems-iris-data-platform/plans/222f869e-567c-4928-b572-eb6a29706fbd?tab=instructions

When I follow these, I am only getting an error:

[WARNING] No init process detected!

I want to add ports 9100 and 9101 in addition to 52773. I read on docker container documentation that this is not possible on a already ran image. Currently it starts the google cloud IRIS health container automatically without me able to specify the additional ports. How can I add ports to Google cloud IRIS Health container?

Hi Developers!

For those who want to participate in the Advent of Code 2019 and code with ObjectScript in IRIS, I created a very simple but handy Github Template.

Use the green button

to copy template in your own repo, clone the repo and run in the repo folder:

docker-compose up -d

you will get InterSystems IRIS 2019.4 Community Edition running with the template classes to load input data from files and Day1 solution.

This is also set up to start crafting solutions of Advent of Code 2019 and edit, compile and debug ObjectScript with VSCode addon.

Happy coding with Advent of Code 2019!

BridgeWorks is pleased to announce a VDM, v9.1.0.1.  This release includes the following updates:

Updates

• Historical Linking is now based off connection profile name
• Saved Formatting is now based off connection profile name
• Tables and Fields column headers no longer hide based on connection type

Bug Fixes

• Cross tab would not load data correctly in Finished Reports Viewer if it was in a report footer
• Fixed an issue where refreshing logs would not work correctly after viewing a SQL statement
• Views were not visible for available schemas on the connection wizard

New

• Load Selected