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 {*} = ..GetModifiedUser()}, SqlComputed, SqlComputeOnChange = ("%%INSERT", "%%UPDATE") ];

Now, I would like to

 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?

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.Busi

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.

Hi developers!

ZPM Package Manager is getting more and more popular and thus the library of packages is growing.

And thus some solutions or samples can be built with InterSystems IRIS and one or two packages installed.

I want to share with you iris-docker-zpm-usage-template - a template that can be used exactly for this purpose.

You can create a new repository or clone it and change the package name to the one that is needed for you and once the docker image is built you get an InterSystems IRIS in a docker container with a package (or set of packages) you like.

By default it installs csvgen packag

Hello programmers I would like to build a simple app where I could register data from a user like a name, age, and the phone just to practice, but for that, I would like to build the frontend and backend and also I need to be able to insert, update and delete information.
Does anyone have any recommendations for me on how I could do that using Intersystems IRIS?

Hey Developers, 

Learn about the recent changes to InterSystems HealthShare Unified Care Record and what is coming next:

⏯ InterSystems HealthShare Unified Care Record 

Server Manager 3.0 Preview, my entry for the InterSystems Security Contest, is now making use of a cool new feature of Visual Studio Code version 1.63 - support for pre-release extensions.

As I write this 1.63 hasn't yet shipped (it's expected out next Thursday), but you can already get your hands on it by installing the VS Code Insiders build. Once you've done that and launched it, use the Extension view to search for 'servermanager' and you'll see this:

In the screenshot above I was using a 1.63.0-insider build, but 1.63 has now shipped.

Note the triangular green bookmark on the extension's

Hello everyone I'm newb using COS and
I would like to know What is the definition of ROUTINE in COS ?
is there anything related to Global?
is it all information that it's possible to persist on the database?

I've been accessing Cache tables from a developer/reporting side, but am now involved in a project to create a data warehouse for our application.  I'm trying to find a query I can use to return the sizes of all the tables in the database, so we can identify the largest tables and handle those individually.  Can someone give me a query I can run against our Cache database to return the sizes of all the tables from largest to smallest?  

Thanks for the help

Using Prometheus to monitor Caché ，when config application /metrics done， Prometheus connection error: “server returned HTTP status 404 Not Found”

Hey Developers,

The InterSystems Security contest is over. Thank you all for participating in our coding competition!

So it's time to announce the winners! 

A storm of applause goes to these developers and their applications:

Hello, everyone,

I have the problem that when trying to connect to the SFTP server the error appears, the user and password are wrong. However, these are correctly stored under login data and I entered! SFTP in SSL Config. The connection works wonderfully with Filezilla. Anyone else has a tip for me?

greeting

Hey Community, 

This is the time to show our passion for the InterSystems Developer Community! We're so proud to announce that InterSystems Global Masters is a finalist for an Influitive BAMMIE Award for Most Passionate Community🤩🤩🤩

Certainly, this is because of you, our great community members!

BUT, for us to win, we'll need to get more votes than other finalists - so we need your votes!

🚀 PLEASE press "You've got my vote" > in this challenge <

Vote every day till December 9 to show that we have the most engaged community! 

Let's WIN together!

3-days left! Video from Olga :)

Hi Community, 

New video is already on InterSystems Developers YouTube:

⏯ Embedded Python with Interoperability