Question Randall Hiser · Mar 13, 2020

I am attempting to pragmatically create a bunch of roles and then assign the appropriate resources to that role.

Currently, the only ways to add resources to a role are to:

1. Do through Management Portal

2. Go through ^SECURITY (add resource one at a time)

My Intention would be to do the following: do ^SECURITY Role Setup Edit Role When prompted for resources to add, be able to use *

Additionally, I was thinking that an additional method can either exist (that I seem to can't find) or create a new method called AddResources: ##Class(Security.Roles).AddResources("role name", "resour

2
0 354
Question Nauris Gruduls · Mar 12, 2020

In my Data Transformation, the Target class needs to create a new List of objects (ListOfObj), depending on some conditions of Source class (Source/Target are completely distinct/different classes).

I experimented with Lists of 'primitive' data types (ListOfDT), and I could add new %String items (as an example) to a List of %String property, with "append" action in DT.

Does anyone have an example, or guidance, how to create new Lists of Objects in data transformation?

For example, if I have a 'container' class like this, it works:

Class Json.SalesOrderContainer Extends (%RegisteredObject,%



2
0 939
Question just fig · Mar 14, 2020

i want to achive a function like that:

"1.2.3"   ->   tmp(1,2,3)=""

"1.2.3.4"   ->   tmp(1,2,3,4)=""

"1.2.3.4..."   ->   tmp(1,2,3,4,...)=""

thx :)

10
0 321
Article Alexey Maslov · Mar 16, 2020 5m read

Introduction

Despite the fact that InterSystems has long recommended using external backup tools, many users have opted to use the internal Online Backup facility, which is included in all distributions of InterSystems products (IRIS Data Platform, Caché, etc.). The reasons why are quite obvious:

0
2 541
Question Frank Langel · Mar 15, 2020

    Hi, 

   I  like to validate some use cases and have the following question. I am relatively new to IRIS. Perhaps someone can help:

   1. I have a global m[x,y,z,f] distributed across multiple sharded instances
   2. I know that i can set assign computed SQL expressions to class variables using Objectscript 
   3. Is there a possibility in Globals API to do the same ? Set f = x + y as a computed expression in the global  m[x,y,z,f]  ?

       a.  We would want to use the global API to change f programmatically using code

       b.  the change in the expression would be distributed across a

5
0 434
Question Drew Holloway · Mar 12, 2020

Is there a way to query the database structure?  In SSMS there are queries for finding tables with a column with a certain name (using LIKE).  And there is the redgate tool SQL Search.  But I'm not sure how to go about looking for columns that have say a value of 'PATID' and returning all tables that match.  Does anyone know?

5
0 1800
Question Frank Langel · Mar 14, 2020

Allow a question from a newbie 

1. Lets assume we have a global (matrix) [X,Y,Z] that is distributed across sharded nodes
2. Matrix size doesnt matter, but lets assume it holds 500 GB for the moment
3. I want to return all rows where f(x,y,z) is true. f() is an arbitrary function, i.e. f = x + 20(y*y) > z

Questions
Q1. Can such a computation (in ObjectScript) be moved and distributed from the client to the different sharded nodes for parallel processing
Q2. Where is that documented (incl. perhaps an example and performance measurements)
 

Thanks a lot
Frank

2
0 355
Question Randall Hiser · Mar 13, 2020

Maybe I haven't seen anything about it in the documentation, but why isn't there a way to list all the Resources from the %SYS namespace from a class rather than through ^SECURITY

Thinking maybe something like this: 
##Class(Security.Resources).ListAll(.result)

1
0 346
Question Michel Bruyère · Mar 13, 2020

In one of my class, I use Stream.Read() method of the %Stream.Object class.

  • Method OnRequest(request As Ens.StreamContainer, Output response As %Library.Persistent) As %Status
  • {
  •    SET sc=$$$OK
  •    SET strRequest=request.Stream.Read(,.sc)
  • ​​   $$$TRACE($L(​​strRequest))
  • ....  

The Trace value gives 32,000. But the Read() method of the %Stream.Object class specifies 32,656 by default.

  1. Method Read(ByRef len As %Integer = 32656, ByRef sc As %Status) As %CacheString
  2. {
  3.    Set len=0,i%AtEnd=1,sc=$$$OK
  4.    Quit ""
  5. }

Why ?

Best Regards.

2
0 974
Article Evgeny Shvarov · Mar 13, 2020 2m read

Hi developers!

Suppose you have a Github repository with ObjectScript classes but without a Docker environment.

Recently I published a repository with a set of files that form a universal Docker and VSCode environment to let you either import and run your repository in InterSystems IRIS Community Edition on Docker or turn your repository into Docker and VSCode environment for InterSystems IRIS Community Edition.

So in one sentence:

Unpack these files in your folder and you have the Docker and VSCode environment for your InterSystems IRIS ObjectScript application!

See the details below.

0
1 785
Discussion Eduard Lebedyuk · Mar 6, 2020

Temporary tables are tables available for a current process only (and destroyed when process ends).

What are you approaches to creating temporary tables?

Here's the two I know:
  1. Process-private Globals storage can be used as a data global in storage definition. That way, each process can have its own objects for the class with ppg storage.  Here's how. Here's how 2.
  2. InterSystems TSQL supports #tablename temporary tables. A #tablename temporary table is visible to the current procedure of the current process. It is also visible to any procedure called from the current procedure. #tablename
5
0 1248
Discussion Anthony Jackson · Mar 13, 2020

Hello Everyone , Good Day ! I have a question regarding the implementation of USCDI (US Core Data for Interoperability).

Why USCDI was introduced? What is the disadvantage of previous process ( communication between systems using concept like HL7) ? What is the impact of implementing this concept in existing systems ? Do we have to change logics for processing the messages? Will it effect the existing work flow of all the healthcare application?

0
1 296
InterSystems Official RB Omo · Mar 12, 2020

In light of the COVID-19 situation worldwide, InterSystems is working to ensure continuous support for our customers, promote the health and well-being of our employees, and protect the communities where we live and work. Please view our statement and frequently asked questions.

In addition, we have also established a special email address, COVID-19@InterSystems.com, should you have any questions or concerns.

As we have for 41 years, we stand by our commitment to customers and are prepared to support you during this challenging time.

Sincerely, 

John Paladino

Vice President, Client Services

0
0 317
Announcement Thomas Dyar · Mar 12, 2020

Greetings Developer Community!

InterSystems IntegratedML (formerly known as QuickML) is ready for external beta, and is looking for some users to kick the tires!

IntegratedML is an all-SQL machine learning (ML) feature in IRIS that:
    • Gives users the ability to create, train and deploy powerful models from simple SQL syntax
    • Wraps "best of breed" open source and proprietary ML and "automl" frameworks such as TensorFlow, XGBoost, H2O-3, and DataRobot
    • Focuses on ease of deployment, so you can add predictions to your application with a single SQL function call 

You are a good fit f

0
0 311
Question Rubens Silva · Mar 9, 2020

Just like the title says, I'm attempting to find a way to create a web application that instead of serving CSP files, it uses a dispatch class.
I searched for clues in the documentation, but the CSPApplication tag seems to be exclusively for CSP file-based applications.
I'm trying to avoid implementing a workaround such as using the Invoke tag to call the Security.Applications to generate the web application but I might be forced to do so, even though it's unpleasant if I had to say...
So, is there an official way to execute this task?

22
0 792
Question amine benchaou · Feb 20, 2020

Hi All,

I need to build a search using a lot of filters, what's the best way to implement my sql requests.

1 sql request per property, or only one "big" sql request ?

what's the disadvantage of using lot of indexes ?    Thank you

KR,

Amine

5
0 363
Announcement Derek Robinson · Mar 12, 2020

In Episode 5 of Data Points, @Bob Binstock joins us to talk about mirroring databases for high availability in InterSystems products! Most of the discussion centers around this process in InterSystems IRIS, with a few notes about the differences when tackling it in HealthShare. Take a listen and let us know your thoughts!

0
0 341
Question Stephen Wilson · Mar 11, 2020

There does not seem to be any separation between the error code and error text in a %Status object. For custom errors, I simply want to display the message and not Error #5001: Some error text.

ClassMethodIsNonNullCustomerID(pCustomerIDAs%String) As%Status  {
Quit:(pCustomerID="")$$$ERROR($$$GeneralError,"CustomerID is not valid")
Quit$$$OK
}

The various methods described here to retrieve the error text always show

Error  #5001: CustomerID not valid

Without manipulating the string above, can you get the "CustomerID not valid" message cleanly from the %Status object and in as few

5
0 737
Question Dmitry Maslennikov · Jan 12, 2020

In one of the projects, when we have ECP with 10 ECP application servers, from time to time we faced the issue when our journals fail to purge, due to open transactions. While we have about 100-150 GB journal files per day, it quite quickly became a big issue, and with mirroring a very big issue. Mostly we just rebooted our ECP Data server, so it searches rollbacks any transactions, but such process is too long, may steal a few hours. I did not find any way, how to get the list of the open transactions from one place from ECP Data Server. We just migrated our Data server to 2018.1. while our A

4
0 1079
Question Krishna Jasti · Mar 11, 2020

Hi

We are trying to use Ensemble as a Router for DICOM Worklist. So when a DICOM Client sends a request (ECHO Or C-FIND), We want Ensemble to carry such request to Epic EMR. When Epic EMR responds with a Response, We need to be able to forward that response back to DICOM Client. I wanted to see If anyone has a working example of this scenario. 

Examples we have in DEMO namespace are not entirely falling into this scenario.

2
0 507
Question Wayne Fourie · Jan 14, 2020

Hi All,

I'm having an issue where I try to use  SOAPUI for a mockup offline service, my issue is when I have the mockup service running in the background and try to send a request from cache I keep getting the following error: "ERROR #6454: No supported policy alternative in configuration".

I've tried to follow the common guidelines for resolving this issue but no luck.

So if there is maybe a nice article explaining how to send a proper request to the mockup service and then getting the response(which will be hardcoded values I've set).


Regards,

1
0 597
Question Adam Dewing · Mar 3, 2020

I'm working on developing Productions with java. The sample project has several intersystems jar files: -- intersystems-enslib-jms-3.1.0.jar -- intersystems-gateway-3.1.0.jar -- intersystems-jdbc-3.1.0.jar -- intersystems-spark-1.0.0.jar -- intersystems-uima-1.0.0.jar -- intersystems-utils-3.1.0.jar -- intersystems-xep-3.1.0.jar

I have the jar files, but where can I find them for download? Are they available on a maven repository somewhere?

Any help would be appreciated!

3
0 1336
Article Murray Oldfield · Jun 5, 2019 2m read

If a picture is worth a thousand words, what's a video worth? Certainly more than typing a post.

Please check out my "Coding talks" on InterSystems Developers YouTube:

1. Analysing InterSystems IRIS System Performance with Yape. Part 1: Installing Yape

 

Running Yape in a container.

2. Yape Container SQLite iostat InterSystems

Extracting and plotting pButtons data including timeframes and iostat.

3
2 1677