The DeepSee Shell Best Practices Series - Run MDX queries in the DeepSee Shell

Introduction to DeepSee Shell

There is a basic introduction video about DeepSee shell on InterSystems video portal.

(http://video.intersystems.com/video/Video.Pages.VideoLibrary.cls?video=3449629690001&playlistid=3329216973001)

Key points in this video:

•Invoke DS shell command, generate MDX in Analyzer, copy in shell;

•Cube command, Select statement and Create statement

•Clauses: With, solve_order, Format_string

Why do you need DeepSee shell?

•If you are in terminal session, or if you don’t have access to management

Hi,

InterSystems learning section is down since yesterday

When it will be up and running OR is there any alternate available?

Thanks

Hello, are there any alternative choices for creating forms with a different tool and then integrating them with Intersystems? I want to use Angular to construct forms and integrate the code with Intersystems. Is there anyone out there who might have an idea?

Pouring The Coffee: Creating and scheduling a task

Don't you wish a fresh, hot cup of coffee could be waiting for you right when you get into the office? Let's automate that!

Cache and IRIS come with a built-in Task Manager, which should have a familiar feel to those used to using the Windows task scheduler or using cron on Linux. Your user account will need access to the %Admin_Task resource to use it, and you can access it in the management portal under System Operation -> Task Manager. When first installed, there are roughly 20 types of task that you can schedule.

If you want to add your own

The Learning platform is not working today for me.
I'm having the following error:
An error occurred while processing your request.

Reference #30.ed7b0660.1637582264.40212533

Running HealthConnect 2021.1 on RedHat Linux 8.4.

I've configured IRIS/HealthConnect with an external web server to support TLS encryption. It's installed on the same server as IRIS, but is a different instance and version of Apache httpd. That all works as expected.

I would also like to keep the "private" web server available, but I'm having an issue with using the fully-qualified domain name in the URL vs. just the hostname itself.

If I use http://servername:52773/csp/sys/UtilHome.csp to log on, all is well.

If I use http://servername.domain.name.tld:52773/csp/sys/UtilHome.csp, The login page

InterSystems Developers,

We adore you! And so excited to share with you all that...

We've now reached an incredible milestone of 10,000 registered members on Developer Community! 🎊

At InterSystems, we believe in the power of community. So we really appreciate all of your contributions throughout these 6 years and look forward to the road ahead!

Hello programmers !!
I'm learning COS and Ensemble and also I started to work with this technology and I did set up vscode to program,
but I don't know how to set up the vscode terminal for COS.
Could anyone help me?
I'm a beginner with this technology

Hi,

I am getting Failed to fetch error while calling FHIR accelerator service - API Development service

Thanks

I often get this message when trying to attach to the routine second time. The only way I was able to fix this is by restarting the Cache server.

Then I can do debugging once, but second time, the error pops up again. Very annoying. Is there a way to fix that without restarting the server ?

Thank you 

Dean Kavicki

I'm attempting to use the .NET Entity Framework provider that is provided by InterSystems (see: https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=GBMP_eframe).  In our environment, the "Support Delimited Identifiers" option is turned off and we are not allowed to turn it on without significant testing effort.  When this setting is off, the SQL that is generated by the Entity Framework provider is not considered valid and therefore the provider doesn't work (it DOES work, however, when this setting is turned ON).

Do you know of any way to work around this issue?

I want to switch between different DSNs in business operations to query different servers, but the DO ..Adapter.DSNSet("DSNName") code will report a 15-second connection timeout error when switching DSNs. What should I do?

Hey Community, 

New video is already waiting on InterSystems Developers YouTube: 

⏯ Nora, A Virtual Assistant for Clinicians: Innovation with Microsoft Teams & Northwell Health 

See the latest news from Learning Services, including:

• New custom paths for Implementation Partners
• Learning paths in system administration, healthcare analytics, and VS Code development
• Documentation feedback options

Intersystems recently announced a partnership with unqork. I would like to know if someone already used this tool, or another tool, and how was the experience. Is there within the intersystems ecosystem (partners) any low-code tool that generates COS? Tks

A permanent job opportunity has arisen for a Caché/Ensemble /Iris developer with at least 2 years experience.My client is a specialist resource provisioner of developers for high profile clients in the finance,  healthcare, retail, distribution and credit business that are mainly based in central London.My client is looking for a highly-motivated individual who thrives in an environment where problems are open-ended.

At the recent virtual conference I saw the demonstration on being able to run Python within ObjectScript and run ObjectScript within Python thanks to a feature called Language Bridge.  Is this available now? If so, am I able to install it?  I am currently running HealthShare 2020.1.  I have a little bit of experience using Irisnative with Python but was intrigued with the more seamless-looking features offered by the Language Bridge.

Thanks for any insight.

Marlin Mixon

Hi all,

I have a process that recive a datetime in ISO 8601 format (YYYY-MM-DDThh:mm:ss+001) to %timestamp value.

Example: set myDatetime  = "2021-11-04T11:10:00+0100"

I've triyed use $SYSTEM.SQL.CONVERT(myDatetime,"SQL_TIMESTAMP") but it doesn't work.

Any idea?

Regards,
Kurro Lopez

I'd like to bring your attention to my two Virtual Summit sessions, even though they're not HALF as cool as Embedded Python.

Git & GitLab for Shared Development Environments details the newly-released git-source-control package (see also on the Open Exchange) which provides a new best-of-breed solution for server-side IRIS/Git integration, especially for shared remote development environments. (I need to write up a post about this package specifically and plan to do so soon.)

InterSystems Package Manager Advanced Topics shows that our package manager (affectionately referred to as "ZPM") is

I am trying to create a scheduled task but get not implemented error when I try to run it.

Class PICIS.Core.Tasks.CleanEntry Extends %RegisteredObject
{

ClassMethod ClearTasks(pBackupFile As %String = "d:\Temp\BackupTasks.xml", pDelete As %Boolean = 0)
{
    // Create backup file
    Set tBackup = ##class(%Stream.FileCharacter).%New()
    Set tBackup.Filename = pBackupFile
    Do tBackup.WriteLine("<?xml version=""1.0"" encoding=""UTF-8""?>")
    Do tBackup.WriteLine("<Tasks>")

    // Delete loop
    Set tCount = 0
    Set tSC = $$$OK
    Set tRS = ##class(%SQL.Statement).%ExecDirect(, "Select ID From

CHAS Health is looking for a full time Interface Engineer II

AMAZING Benefits Package! Medical, Dental, Vision

Paid Time Off (PTO) CHAS Health offers up to 6 weeks of PTO per anniversary year for full time employees.

Loan Reimbursement Program that provides reimbursement for student loan payments up to $5,250 per year for CHAS Health employees working a minimum of 30 hours a week who have completed 90 days of employment and are in good standing. This program is for employees with qualified student loans that are not eligible for state or federal loan repayment programs.

Flexible Work Arrangements

I have just created a new Global Master Topic, "IRIS Cheatsheets".IRIS has introduced a lot of new functionality, especially in scripting languages, FHIR R4 support, enhanced Interoperability Tools, and IRIS Analytics.Having spent 35 years working on Windows-based PC's and Laptops, I have surprisingly little knowledge of Linux, Docker and Git.Furthermore, I have written almost every application and Interface in ObjectScript with splatterings of SQL, .Net, and Java Gateways and the most basic knowledge of WinSCP, Putty, SSH.All that changed when I received my first Raspberry Pi.

Hey everyone,

We're pleased to welcome @Duan Haihua as our new Chinese Moderator in the Developer Community Team!

Let's greet Duan Haihua with big applause and take a closer look at his bio!

Hi All,

I'm having a strange issue where doing a .setValue on a ZEN datacombo is updating it with the value as-is, not the corresponding display value. Eg, if I connected it to query that returns two columns: ID,Name, and do a setValue(ID), I would expect the text in the datacombo to update showing Name. Instead it updates show ID, which I only want to use internally.

However, if I click on the dropdown, showing all the valid Names, select one, it works fine, showing Name (with the ID retrievable by getValue() as normal).

Hello,

How I can unpack rar archive with 7z program in COS?

Are you an InterSystems Implementation Partner? As you build customer-focused applications, take advantage of comprehensive online learning resources. Now available are three custom learning paths in finance, healthcare, and all industries—offering a solid foundation for anyone looking to build applications with InterSystems products!

Hey Developers, 

Learn about new features in the InterSystems HealthShare Health Insight 2020.1 and 2020.2 releases and plans for future releases:

⏯ New & Next: Deliver actionable intelligence with HealthShare Health Insight 

In my previous articles I demonstrated the steps to connect, retrieve and save data to Caché from Appeon PowerBuilder by using ODBC.
In this article I will demonstrated how to Delete data from Caché with Appeon PowerBuilder (https://www.appeon.com/products/powerbuilder) by using ODBC 

I am using Company.cls from Samples-Data (https://github.com/intersystems/Samples-Data/tree/master/cls/Sample) 

So Let's start:
 

Step 1 : First of all we need to establish a connection (https://community.intersystems.com/post/connecting-cach%C3%A9-appeon-po…)

Step 2 : We need to create datawindow

Hi Guys,

How can I download or populate a query resultset or a content or DataGrid or zen report to a CSV file ?

basically, I know how to create a csv file than save it in a local path eg. C:\Temp\filename.csv but this is not convenient for the user to go then a try to find the file, I would like the CSV file to be downloaded or opened for the user to view the same way for example when you go a website where you have an option to download or open a csv file from query resultset or a zen report .

Thanks