I want to make the LOCATION for a %Stream.FileCharacterGzip property we have in a class parameterisable (as in stored in a global), so it can be different for different customers. Is that possible?  I've tried doing it a few different ways:
Creating a parameter
Parameter STREAMLOC = {^websystem("auditstream-location")};
then I tried to reference that in the 

Property HTMLZIPDoc As %Stream.FileCharacterGzip(LOCATION = ..#STREAMLOC);

but the compiler doesn't like that. 

I've also tried adding something to %OnOpen and %OnNew:
Method %OnOpen() As %Status [ Private, ServerOnly = 1 ]
{
    S .

I need some help with unescaping a value in TXA 2 of an MDM message that I am writing to a variable, to be used in a filename for a PF. Would I use the method Unescape(pData) if so how can I use it in a transform to set the variable? The reason I need to do this is I need to use the name as file name when writing the PDF to a directory. The escape characters and invalid for file names .

I've found a couple of methods that will tell me whether a package is mapped from another database, but not which database. Is there such a method/routine?

In my previous post I described how to install the pre-release of the Server Manager 3 extension and benefit from enhanced security for your stored credentials.

Now by upgrading to the latest release (1.2.7) of the InterSystems Language Server and opting in to the 1.3 pre-release of the ObjectScript extension you get the additional reassurance of being notified whenever either of those extensions try to access stored credentials for the first time.

I am so proud and excited to share this news! 

InterSystems Global Masters program  🎉WON the 2021 Influitive BAMMIE Award for People’s Choice: Most Passionate Community  🎉

Influitive Announcement with all Winners here
BIG thanks to you, our awesome Community members - you made this possible! We got this win together!
We will continue building the best engagement program for you, dear Community Members - more exciting things to come in 2022! Stay with us! 

Hi Community, 

Join us for this walk-through of InterSystems Package Manager ZPM advanced features for developing and deploying InterSystems IRIS solutions:

⏯ InterSystems Package Manager Advanced Topics

Dear Community Members,

Has someone built some kind of Adapter (or other related components) to interact with Couchbase?

Something sharable?

What connection method did you choose - for example REST API / .Net or Java SDK?

Thanks!

LS,

Does anyone already has an installation kit for the IRIS for Health running on an MacBook with Apple M1 Cores? Docker I already got, I'm looking for the local install version.

Regards,

Joost

Hello all,

I'm "playing" a little bit with IRIS as document database, as it seems really simple to use.

So far, creating a database and inserting documents is fine. Creating a Property so it can be indexed seems very useful and it works well when this property is created at the very beginning. But here my "problem": whenever a new property is added, how can the values be recalculated and inserted, so indices can be correctly updated? 

So far, I've only found as a solution opening and saving the documents :'( This is ok for a POC, but what when millions of documents are stored?

Hey Developers, 

Get updated on recent changes to Provider Directory and Patient Index. Take a peek at what is coming next:

⏯ Provider Directory & Patient Index: New & Next

Millions of professionals use a wonderful tool, spreadsheets, for engineering calculations and financial analysis. It attracts a user-friendly interface and clear data organization. Cell formulas provide rich opportunities for automating calculations. No programming is required. (For example, Microsoft Excel)

But in order to expand the scope of the tool, it is necessary to increase the dimension of the tables and the speed of calculations. It is necessary to create a single, common database for a group of users. Cell formulas should be able to do everything.

I have an auditing class that defines some sqlComputed properties and can be extended by other persistent classes to enable auditing of its properties.  

Class Audit.ModifiedTracker [ abstract ] {
/// Last time this record was saved
Property LastModifiedTime As %TimeStamp [ SqlComputeCode = {Set {*}=$zdt($zts,3)}, SqlComputed, SqlComputeOnChange = ("%%INSERT", "%%UPDATE") ]; 
/// User responsible for modifying record
Property LastModifiedUser As %String [ SqlComputeCode = {set {*} = .

 Hi Community:

Just want to let you know that we have created a special landing page with select Focus Sessions that you can replay.

>Link to Landing Page

>Link to Focus Sessions on Embedded Python

Enjoy!

Jacquie

Hi folks!

I'm curious if it is possible to change the class method to another class?

I call a method of a system class  to generate another class. But there is a bug/feature in a library class, so I need to tweak a bit the generated method, e.g. add additional parameter and change the line to "if" the parameter.

I hope to do this programmatically after class generation and change the code in a way I like.

What are the options?

Close out the year with some exciting updates from Learning Services:

• Try the new Python Learning path and Embedded Python QuickStart.
• Get practice managing InterSystems IRIS instances.
• Manage deployed applications with CCR.
• Take the new Certification exam.
• Read improved security content for HealthShare® Unified Care Record.

Subscribe to the newsletter to stay up to date!
 

Is there any information regarding using Cache ODBC DSN's to connect to SAP Crystal Server 2020?  We have added all the necessary DSN on the server, and yet when running reports to access the required ODBC connections, we cannot seem to get the connections to establish.

Hi there,

Does anyone have an example of the method used to run an SQL query and generate the view in a Mumps routine.   I have several SQL queries created from a vendor that need to be converted and the corresponding view referenced.  I cannot seem to find any examples in IDX routines or in the  IRIS/Cache documentation.  Any help is appreciated.

-Alicia

The 2021.2 release of the InterSystems IRIS Data Platform includes many exciting new features for fast, flexible and secure development of your mission-critical applications. Embedded Python definitely takes the limelight (and for good reason!), but in SQL we've also made a massive step forward towards a more adaptive engine that gathers detailed statistical information about your table data and exploits it to deliver the best query plans. In this brief series of articles, we'll take a closer at three elements that are new in 2021.2 and work together towards this goal, starting with Run Time Plan Choice.

It's hard to figure out the right order to talk about these (you can't imagine how often I've reshuffled them in writing this article!) because they fit together in such a nice way. As such, feel free to go on a limb and read these in random order .

Hey Developers, 

Learn about the InterSystems Partner Directory, its value to partners, and how to join:

⏯ Partner Directory New Services for InterSystems Partners & End Users

I've experienced this problem several times recently. I go to a production in my development instance and click on the (+) to add a new service. A pop-up appears with the message "An error occurred with the CSP application and has been logged to system error log (^ERRORand nothing else. Examining ^ERRORS is of no help. There's a lot of gibberish there that isn't informative in the least.

I can add processes and operations just fine.

The last two times this happened I had to re-install HealthShare from scratch.

This is the third article in our short series around innovations in IRIS SQL that deliver a more adaptive, high-performance experience for analysts and applications querying relational data on IRIS. It may be the last article in this series for 2021.2, but we have several more enhancements lined up in this area. In this article, we'll dig a little deeper into additional table statistics we're starting to gather in this release: Histograms

I am using Crystal Reports XI against a Cache database. Are the values in the database case sensitive?

I am working in Intersystems Healthshare product.

I want to clear the message logs from a particular interface (Service,process,operation). 

In intersystems we have the option to purge the data for all interfaces for the corresponding time but I want to clear the data logs for particular interface only.

Please let me know how to approach this scenario.

Hi Community,

We're pleased to invite you to the online meetup with the winners of the InterSystems Security contest!

Date & Time: Friday, December 10, 2021 – 11:00 EDT

What awaits you at this virtual meetup? 

• Our winners' bios.
• Short demos on their applications.
• An open discussion about technologies being used. Q&A. Plans for the next contests.

Hi everyone

I see that a new Apache bug has been discovered, and since various InterSystems products use an Apache webserver, have Intersystems released any news or updates on this? I'm not seeing any updates, press releases from them. Anyone know anything?

Andy

Do you know if any InterSystems product is compromised due to the Log4j vulnerability?

December 13, 2021 - Advisory: Vulnerability in Apache Log4j2 Library Affecting InterSystems Products

InterSystems is currently investigating the impact of a security vulnerability related to Apache Log4j2.

The vulnerability — impacting at least Apache Log4j2 (versions 2.0 to 2.14.1) — was recently announced by Apache and is reported in the United States National Vulnerability Database (NVD) as CVE-2021-44228 with the highest severity rating, 10.0.

Please see this page for more details about the vulnerability and updates on whether InterSystems Products are affected.

Hi members,

I have these data :

and need to exploit the first character of cot field (Library CDU classification) like this :

I get this result... it's approximatively what I want... but I need it in just one line !

With mySQL I get it with just GROUP BY rcddate

In Cache SQL I have to add {fn LEFT(cot,1)} to get the counts of each first character of cot... and seems {fn WEEK(rcddate)} doesn't make the job !

There is a trick ? or I make something wrong ?

kind regards.

I've never had a problem changing the content-type on a response using either %CSP.Page or %CSP.REST until now. No matter where I put the line to set the content-type to "application/json", it stubbornly emits a content-type of "text/html".

In OnPreHTTP: (I tried one at a time)
either
    do %response.SetHeader("content-type", "application/json") // didn't work
or
    set %response.ContentType = "text/plain" // didn't work

The same lines in OnProcessInput() didn't change the output content-type, either.

The class signature is 
Class HS.Local.VA.HS.DocRepo.Prefetch.Service.RESTService Extends (Ens.

Hey InterSystems Community,

I noticed something interesting in regards to business rule editing. Whenever you use the Management Portal or Studio to edit a business rule, the " characters gets escaped to a ".

Which results in the following code:

As long as you are not mixing development styles - as in, sticking to only the UI or only the code, it is not a problem. But as soon as you mix both, the escaping starts to hinder readability of the rules a bit. I noticed that this is not the case with other interoperability features, like data transformations.