Article David Hockenbroch · Sep 14, 2023 9m read

The Security Package - Editing Users Programmatically

Have you ever thought of creating your own systems for editing users or, perhaps, even an API that you can call? Today, you’re going to join me in the %SYS namespace and get to know Security.Users! 

This class has forty properties, many of which you’ve seen before in the System Management Portal. There are class methods for manipulating most of those properties. Every method in this class is a class method, and in most of them, the username is passed as an argument. These methods can be used when you do not want to open and directly manipulate the user’s objects, which is a bad idea anyway! Y




#InterSystems IRIS #Access control #Authentication #Coding Guidelines #Security #System Administration
1
3 614
Question Katrina E Rodenhaus · Sep 14, 2023

PHP8 with ODBC connection to InterSystems IRIS returning NULL for fields VARCHAR(30000)

I am very new to IRIS. We are developing a PHP application that connects to an IRIS instance of one of our vendors. This works well most of the time, but when I query a table to get data from particular fields that contain long text strings, it returns `NULL`. These fields are all `VARCHAR(30000)`.

I tried using the `$extract` functionality in the IRIS documentation, but that made no difference. I also tried setting the PHP setting `odbc.defaultlrl` to both 31K and 0. Neither resolved the issue.

I also looked through the internet to try and find a similar issue, but wasn't able to find anyth

#InterSystems IRIS #ODBC #SQL
1
0 367
Announcement Jeff Fried · Sep 14, 2023

InterSystems IRIS Point Releases Explained

From time to time InterSystems must respin a release to correct 1-2 issues. This process generates new kits called "Point Releases".

A Point Release is distinct from maintenance or feature releases.  Its objective is to correct an urgent issue in the field quickly and surgically.  

#InterSystems IRIS #Release
0
0 517
Question Nezla · Sep 14, 2023

%OnSubmit is not invoked from client

Hi Guys,

I've an fileupload and button that executes   Upload() clientmethod to upload files in my database and everything works fine when I run the application in the server where it is located, but if I run it from a client machine the %OnSubmit class method doesn't get invoked when form.submit() get executed so how can I fix this?

I can always use <submit> button but the thing is that I need the current form to close after submitting the form but adding  &js<window.close()> st the end of %OnSubmit classmethod to close the window is not working 

<html>
<input type="file" size="80" name="F

#Ensemble
1
0 226
Article Mihoko Iijima · Sep 14, 2023 1m read

How to get all fields of a specified table with SQL

InterSystems FAQ rubric

It can be retrieved using the schema INFORMATION_SCHEMA.

INFORMATION_SCHEMA is a system schema and is not displayed by default in the SQL menu of the Management Portal.

The method to display it is as follows.

  1. Open Management Portal → System Explorer → SQL menu.
  2. Check "System" on the left of the schema drop-down.
  3. Select INFORMATION_SCHEMA from the schema dropdown.

The SQL to get the ID, field name (COLUMN_NAME), data type (DATA_TYPE), description (DESCRIPTION) for the specified table (Sample.Human) is as follows.

SELECTID,COLUMN_NAME,DATA_TYPE,DESCRIPTION
#Caché #Ensemble #HealthShare #InterSystems IRIS #InterSystems IRIS for Health #SQL #Tips & Tricks
0
1 675
Discussion John Murray · Sep 8, 2023

Unable to create trial deployment on Health Connect Cloud

Earlier today I enrolled at Cloud Services Portal and clicked "Start trial" for the "Health Connect Cloud" service. Next step was "Create Deployment". The only deployment size offered was "Micro", so I picked that, completed the other required details and clicked "Create".

Response was:

I reported this using the "Submit Feedback" option on the dropdown from my username in the top right of Cloud Services Portal but haven't yet received a response. Hence this DC post, in case someone here can tell me what I'm doing wrong.

#Health Connect #HealthShare #Cloud
9
0 304
Question Nezla · Sep 13, 2023

Fileupload and %OnSubmit

Hi Guys,

I've a popup zen page to upload files using the input tag and submit button as below :

<html>
<input type="file" size="80" name="FileStream" class="button" id="fileUpload" />
</html>
<!--imageclickbutton id="btnUpload" caption="Upload" width="90" height="30" onclick="zenPage.Upload();"/-->
<submit align="right" id="Submit" name="Submit" caption="Upload1" />

and the problem is that after loading the file on the %OnSubmit classmethod I need to execute a client code a Javascript clientMethod  (CloseAndRefresh()) which closes the current popup screen and refresh a gridview in Original pag

#Ensemble #ZEN
2
0 362
Question Scott Roth · Aug 9, 2023

How do I convert my JSON Response to an Ens.Response object with Lists of Arrays

Still working on my first External REST API call, and I am struggling to find the exact answer I am looking for... I get a JSON response from my API call but I am not quite sure how to dynamically get the JSON response into the Ens.Response Object with its lists of Arrays that I have defined.

  set tSC = ..Adapter.SendFormDataArray(.tHTTPResposne,"POST",tHTTPRequest,,,tURL)

  set pResponse = ##class(User.REST.Epic.Msg.GetPatientLocationResponse).%New()

  set dynObject = {}.%FromJSON(tHTTPResposne.Data)

  set iter = dynObject.%GetIterator()

  while iter.%GetNext(.key,.value){

    $$$TRACE

#Health Connect #InterSystems IRIS #InterSystems IRIS for Health #API #JSON #REST API
10
0 732
Question Pietro Di Leo · Sep 7, 2023

Inconsistent Visual Trace Outputs

Hi everyone,

I have a question related to a strange issue I've been experiencing over the last few days.

Context

I'm attempting to create an automatic resending system that, if no reply is received from the server, raises an error and re-sends the message. This process continues for the a duration defined by the FailureTimeout (e.g., 20 seconds), and a new message is being sent every 5 seconds until the FailureTimeout is reached. If no response was obtained from the server, the system returns an error. 

Issue

I've noticed that at times, even with the same input and settings, the outputs d


#InterSystems IRIS
2
0 368
Question lw lw · Sep 7, 2023

Does mirroring support journal restore?

My cluster status is as follows:

when I do journal restore on primary, it says journal restore is not allowed. The DR is also not allowed to do journal restore.

1) Begin Journaling (^JRNSTART)
 2) Stop Journaling (^JRNSTOP)
 3) Switch Journal File (^JRNSWTCH)
 4) Restore Globals From Journal (^JRNRESTO)
 5) Display Journal File (^JRNDUMP)
 6) Purge Journal Files (PURGE^JOURNAL)
 7) Edit Journal Properties (^JRNOPTS)
 8) Activate or Deactivate Journal Encryption (ENCRYPT^JOURNAL())
 9) Display Journal status (Status^JOURNAL)
10) -not available-
11) -not available-
12) Journal
#InterSystems IRIS #InterSystems API Manager (IAM)
3
0 267
Discussion Sylvain Guilbaud · Sep 11, 2023

Manage SQL accesses to all or some schemas in a database, instead of managing it a the tables level.

Currently, the SQL privileges (SELECT, INSERT, UPDATE, DELETE) are managed at the tables level, which can be very tedious when you have to administer many roles in an organization, and need to keep them sync with a constantly evolving data models.
By managing privileges at the schemas level, will allow to give SELECT and other DML privileges to *all* or *several schemas* to a role|user, fixing the need to manually synchronize the new tables|views to the roles.

If you agree, I invite you to vote for this idea.

#Caché #Ensemble #InterSystems IRIS #InterSystems IRIS for Health #Security #SQL
6
0 353
Question Emil Odobasic · Sep 6, 2023

Question if it is possible to receive a REST call to an EnsLib.HTTP.InboundAdapter

Hello everyone!
I need to build something that will receive a REST request. As of now I have tried my luck with using an EnsLib.HTTP.InboundAdapter. But i am not so sure how I am supposed to configure it to be able to receive the REST request together with the JSON body.
I have specified the OnProcessInput in the adapter so that it receives a GlobalCharacterStream. However, I have not had any good luck finding out to actually make the request to the EnsLib.HTTP.InboundAdapter. 
I would be really thankful if you could let me know if it is possible for an EnsLib.HTTP.InboundAdapter to actually rece

#Ensemble #HealthShare #REST API
8
0 495
Discussion Luis Angel Pérez Ramos · Sep 11, 2023

What about BPL and DTL web pages automatic refresh?

I usually receive complains from our customers about the BPL and DTL web pages automatic refreshes, it's a common problem among newbies users but for veteran developers too, they forget to save the changes regularly and automatically the web page is reloaded, losing all the work done.

Maybe an autosave would fix this problem that produces a deep feeling of hate and resentment against InterSystems technology among our customers. I've added an idea in our portal, so feel free to vote it!

https://ideas.intersystems.com/ideas/DPI-I-452

#HealthShare #InterSystems IRIS #Business Process (BPL) #DTL
12
0 337
InterSystems Official Bob Kuszewski · Aug 17, 2023

InterSystems Supported Platforms Update Q3-2023

We often get questions about recent and upcoming changes to the list of platforms and frameworks that are supported by the InterSystems IRIS data platform.  This update aims to share recent changes as well as our best current knowledge on upcoming changes, but predicting the future is tricky business and this shouldn’t be considered a committed roadmap. 

With that said, on to the update…

IRIS Production Operating Systems and CPU Architectures

Red Hat Enterprise Linux

  • Recent Changes
    • RHEL 9.2 & RHEL 8.8 were released in May, 2023. Red Hat is planning to support these releases for 4 y
#Caché #InterSystems IRIS #InterSystems Official
4
2 685
Question Pravin Barton · Sep 12, 2023

How to exclude folders from VS Code ObjectScript search

I have a VS Code workspace using server-side editing with separate folders for different namespaces on the instance:

{
	"folders": [
		{
			"name": "SYS",
			"uri": "isfs://server:%SYS/"
		},
		{
			"name": "cls",
			"uri": "isfs://server:USER/?filter=*.cls"
		}
	]
}


The VS Code search works well to find symbols in ObjectScript files, but it searches across all folders. Is there a way to include or exclude certain folders from the search? I've tried adding some patterns to the "files to exclude" dialog, but none of these seem to work: SYS/**, /SYS/**, %.*, \%.*

#VSCode
3
0 910
Discussion Dmitry Maslennikov · Sep 1, 2023

Data warehouses and data lakes with data from IRIS

In today's landscape, enterprises have grown substantially in scale, amassing vast amounts of data. This data is collected from a plethora of sources including different applications, databases, and other channels. Given the diversity and volume of this data, it's only logical for these enterprises to seek a deeper understanding of what their data entails. Some of the data can be stored in IRIS, and it can be reasonable to be able to add this data to a data lake too.

The Internet now offers many different tools for such tasks, that do not yet support IRIS, but it's achievable. 

What do you t

#InterSystems Ideas Portal #InterSystems IRIS #Big Data #SQL
7
0 673
Question Smythe Smythee · Sep 11, 2023

How to read and write values into Ens.StreamContainer

Hi Community,

I have SDA file as Ens.StreamContainer Message using pRequest As Ens.StreamContainer

SDA file structure looks like this 

<Name><FamilyName>Lucy</FamilyName><GivenName>Hale</GivenName><MiddleName>Park</MiddleName></Name><Gender><Code>F</Code><Description>F</Description></Gender><BirthTime>2023-09-07T00:00:00</BirthTime>

How can i change individual value from the Steam and then save changed value into the stream?

#InterSystems IRIS for Health #Business Operation #DTL #XML
3
1 968
Question Robert Bielen · Aug 25, 2023

Reply Code Actions Question

Hi Everyone

I'm just wondering if anyone might have a list (or the experience to make a list) of the most often used / useful Reply Code Actions?

In the Help section of Health Connect Management Portal, it lists 

'E=F' and ':?R=RF,:?E=S,:~=S,:?A=C,:*=S,:I?=W,:T?=C'

as the default options, though I'm curious if anyone else has found other codes or strings of codes useful?

Thanks in advance. 

Best wishes

Robert

#Health Connect #InterSystems IRIS for Health #Management Portal #System Administration
3
0 721