Is it possible to create a pivot table with a column containing a clickable hyperlink using a field from the cube definition as a part of the link?

Currently in Visual Studio Code when we connect to a Cache server and export the CLS and MAC files, they get placed in the following:

\Comp;anyName\src\Packages

Where the Packages folder corresponds to the different class packages we have. The MAC files are placed in the src folder and not contained in it's own folder.

Is there a way to configure the export for the MAC files so that it's contained in it's own folder like this:

\CompanyName\src\mac

Thanks in advance for your help.

-Roberto

Hello community,

I would like to report about a security issue, that engages us for some time meanwhile.

We configured a restricted user to read data from a csp page to feed our nagios server with information about configuration items we would like to have an eye upon. The configuration of this user is the same in our production and in our development environment. The called method mainly reads data from lookup tables by sql queries and writes data to a temporary table, which is deleted in the begining.

Hi I am new here. Please let me know where can I find posts related to using container registry. Thanks in advance!

Hi,

I am wanting to get the results of SYS.Database class's List query into a result set.

I have code that does it, but I get a cursor error at the end.... should I just to a try/catch and ignore this error below?  Or can I call this in a different way to avoid the error?  
My code, in the %SYS namespace
Set Statement=##class(%SQL.Statement).%New()
Set status=Statement.%PrepareClassQuery("SYS.Database","List")

Set rset=Statement.%Execute()
//
while (rset.%Next())
{
        W !,rset.%Get("Directory"),?30,rset.%Get("Size"),?40,rset.%Get("MaxSize")
}
when I call

Hi community,

When InterSystems Health stack are working toghether the hospital ecosystem get this:

Hey Developers,

Please welcome the new session recording from the InterSystems AI+ML Summit 2021:

⏯ AI+ML Summit Convergent Analytics – Cross-Industry Stream

Hi,

While Configuring Intersystems Cache in Intersystems IRIS Health, some of the background jobs are not running.

Eg: Job for Calculator process. Is License key necessary to run the jobs? Anyother changes need to run the jobs. 

Thanks.

Hi developers!

Want to share with you the new February release on Open Exchange:

• The ability to leave reviews and give ratings for applications
• Visits information on the Analytics page
• Other minor UI enhancements

When using "IDENTITY" as my primary key, I can select the last inserted ID with 

SELECT LAST_IDENTITY() FROM %TSQL_sys.snf;

Actually this is how Hibernate + Iris' Driver acquires the inserted ID when mapping with

@GeneratedValue(strategy = GenerationType.IDENTITY)

Now, considering that I am using the type "SERIAL" as my primary key instead, how can I get the last inserted ID?

Note that with "SERIAL" I can forcefully insert any value for this ID, from which Iris will continue generating values.

I want to create simple CSP page with some fields to filter and a table in the page that shows results from a table. Where to start any tips

I have lots of msg control id received from customers and i search these msg control id first in router to review the msgs and then search the same msg control id in the respective edge message viewer.

Is there a way i can generate the msg trace URLs for router and edge by using msg control id?

When I create a TASK on the Primary mirror member and Try to create the same TASK in the backup mirror member,  It Gives me CSP Application error.

The TASK gets created in the Primary node without any errors and When creating in the Backup node it prompts the error.

It happens is IRIS and I didn't face this in CACHE.

Finally what I did is export the TASK in Primary and Imported in Backup.

Is this a feature of IRIS?

Set SPMData= "SPM|1|A||^^^^^^^^||||ABDMN^ABDOMEN A^L|""_Modifier1_""^L~""_Modifier2_""^L~""_Modifier3_"

HL7 SPM:

SPM|1|A||^^^^^^^^||||ABDMN^ABDOMEN A^L|1^1^L10C^10:00^L11C^11:00^L|||||FREE TEXT NOTE 1|||202102152216||||||||||||

Hi Community! 

I'm sharing a little tool (REST service) to download interoperability messages from your browser.

You only need to:

1. Create a web application in Management Portal (e.g. /downloadmsg) and set DispatchClass=Util.DownloadMsg.
2. Call the tool using your browser passing the namespace and the message header id to download. http://localhost:52773/downloadmsg/ns/mydev/msgid/17441

/// 
/// Util to download messages given a message header id
/// 
/// Setup:
/// 1. Create a webapplication (e.g. /downloadmsg) and set DispatchClass=Util.DownloadMsg
/// 2.

I am working on automating to pick all the jobs running particular business process and kill them by using a routine. Though I was able to kill the jobs/PID on server by using (sudo kill jobid) and by using  do $SYSTEM.Process.Terminate(jobid) or  Do ##class(Ens.Job).UnRegister("buseiness host", jobid), I am looking to build a routine by setting a variable with all the business process names and then fetch the jobid or PID associated with those business process and kill them. Any help is highly appreciated.

想问一下IRIS里有SHA256withRSA  加密算法的实现吗？因为最近用到该加密算法进行接口调用。

Translated by moderator

I want to know if IRIS has SHA256 with RSA encryption algorithm? we have interface needing this encryption algorithm recently.

Is there an API that can be used to remotely fetch the state of an IRIS instance similar to what is reported with "iris list"?  Specifically, I'm looking to be able to remotely detect when an IRIS instance is in "hung" state.

I know there is the "iris_system_state" metric that I can consume in Grafana, but I found that when our system was in a "hung" state, there was just no data for that metric and I'd think if you alert on that, you cannot be sure if the IRIS system is down or hung or there's just an issue with prometheus fetching stats from IRIS.

I have vendors asking for verification that messages for locations are coming through to them.  I can get generic ADT_A01 type of numbers in Activity.  I'd really like to get some good SQL queries that can give me a count of MSH.4s (for example) for a day for X Operation.  I'm not sure which table to look at for that information.

Hey Developers,

See how you can use InterSystems IRIS and Alteryx together to provide analytics and insights to your users.

⏯ Using InterSystems IRIS and Alteryx

How can I activate and configure web applications by code without going to the management portal?

And how to configure the rights of the web-application also by code without clicking on the form in the management portal?

Hello,

I have established an ODBC connection with our client based on credentials they provided.    The test connection was successful and after using the Link Table wizard I can now see the client's tables and properties.    However when we try to execute a query in IRIS we are getting error code -226.   I'm trying to determine if this could be just a simple setting problem in IRIS or something with the client.   

We have tried with PostgreSQL as well as with TSQL.  Same result for each.

Has anyone seen this error before and could it be pointing me in a certain direction?

We are a multi-state Health Information Network seeking experienced integration analysts for immediate, full time positions. Currently these positions are 100% remote. Excellent benefits.

Ideal candidates will have extensive experience with InterSystems HealthShare, experience with Amazon Web Services, HL7 v2 & v3, and IHE ITI profiles. Rhapsody or other integration engine experience is a plus. We are seeking confident, motivated individuals with strong communication skills and the ability to engage directly with a variety of healthcare stakeholders.

Hello all,

I have a Business Service which retrieves data via a SQL adapter and writes the data in text file. My production is doing the job, but instead of the Business Operation output being one file, I am getting many files, with 1 , 2 or 3 rows only. 

Any help is appreciated. 

Thank you 

Hey Developers,

We're pleased to invite you to the upcoming webinar in Russian called "Virtual Summit + Open Exchange"!

🗓 Date & time: Febraury 16, 10:00 (UTC+3, Moscow time)

🗣 Speaker: @Eduard Lebedyuk, Sales Engineer, InterSystems 

Hi everyone, I am trying to return a cloned version of my ADT that I have made changes to in a Business Process.  So far I have the following in my process.  

&sql(Select MemberId INTO :pMemberIDval from CDSM_MemberAPI.MemberInfo where MemDOB = :ptDOB and MemLname = :ptLname and MemFname = :ptFname)

set newrequest = pRequest.%ConstructClone()

set MemberIDPID4 = newrequest.SetValueAt(pMemberIDval, "PID:4.1")

The following does return the value I am populating the clone with to the log

  set newrequestPID4 = newrequest.GetValueAt("PID:4.

Hey Developers,

Thank you so much for being with InterSystems Developer Community for yet another year! 

More than 8K+ users are already registered in our community! And day by day our team is trying to make it better and more useful for InterSystems developers.

We want to know how helpful the Developer Community is for you today. Please go through this short survey which will let us know what do you think and what could be improved!

👉🏼 Developer Community Survey 2020 👈🏼

Note: The survey will take less than 5 minutes to complete.

Hi Community,

We're pleased to invite you to the online meetup with the winners of the InterSystems Multi-Model Contest!

Date & Time: Friday, Febraury 5, 2021 – 10:00 EDT

What awaits you at this virtual Meetup? 

• Our winners' bios.
• Short demos on their applications.
• An open discussion about technologies being used, bonuses, questions. Plans for the next contests.

Since some months ago we automatized source code analysis for projects on Github, so anyone with an open source project can have its code analyzed with no cost.

You only need to create the file ".github/workflows/objectscript-quality.yml" in your project with following contents:

name: objectscriptquality
on: push

jobs:
  linux:
    name: Linux build
    runs-on: ubuntu-latest

    steps:
    - name: Execute ObjectScript Quality Analysis
      run: wget https://raw.githubusercontent.com/litesolutions/objectscriptquality-jenkins-integration/master/iris-community-hook.sh && sh .

February 11, 2021 – Advisory: Incomplete Query Results with ‘ORDER BY <row ID field> DESC’ – HealthShare

InterSystems has corrected a defect that can cause incomplete query results.  This defect affects the platforms underlying HealthShare and HealthShare Health Connect:

• InterSystems IRIS and InterSystems IRIS for Health 2019.1.0, 2019.1.1, and 2020.1.0

See Alert: Incomplete Query Results with ‘ORDER BY <row ID field> DESC’ for further detail

Customers using HealthShare Personal Community should evaluate the number of proxy relationships they have established or removed.