Hi,

The class %JSON.Adaptor is very convenient,

I wonder if anyone faced the following scenario using it-

Exporting an object, that has a many to many relationship, and getting the details of the related objects.

For example, if we have three classes - Teachers, Students, and an intermediate class TeacherStudent .

The classes extend %JSON.

Does anyone NOT use a debugger? I can't remember the last time I did. It's not because I don't dislike them, I just don't need to use them. The main reason for this is because I have a certain development methodology that either produces less bugs, catches them at a unit test level, or makes tracking them down much easier.

Here are my tips...

1. Write your own COS cheat-sheet.

This is mainly for anyone that is new to COS. One of the biggest bug hazards is not knowing how certain commands and functions work.

Hello All

Could someone help me in the details of the ODBC connection  I need to connect to the Healthshare Cache databases for the CMC application?

Much appreciated in advance

Andrew

Hi Community!

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

We want to know how helpful the Developer Community is for you today.

Could you please go through this short survey which will let us know what do you think and what could be improved.
➡️Developer Community Survey 2019 (4 min)

We wish you a Merry Christmas and a Happy New Year!  ✨

Sincerely, 

Your InterSystems Developer Community Team

Hi Developers!

Often we need to use relatively small arrays with constants, static arrays in algorithms, etc where we need to do something with each element of an array. There are several ways to deal with it in ObjectSctipt. 

Previously I used to use globals, locals, PPG for this but not so long time ago figured out that %List is a way too handy.

Indeed, suppose we have an array of months and need to set up and use it in our code.

Is there anyway to improve the performance of the display of DeepSee dashboards?

It takes minutes to do the cell calculations of computing the axis members.

Any direction or help would be appreciated.

Thanks,
LG

How to calculate median and mean in SQL?

Merry XMas and Happy New Year!

Hope to hear from you next year!

Hello, Community!

After beta testing the new exam InterSystems IRIS Core Solutions Developer Specialist at Global Summit 2019, the Certification Team of InterSystems Learning Services has performed the necessary calibration and adjustments to release it to our community. It is now ready for purchase and scheduling in InterSystems exam catalog. 

This is InterSystems first certification exam to feature mainly code samples as question topics. To give potential candidates a sample of the exam's content, practice questions have been published to help orient to exam question approaches and content.

Hi everyone,

I am currently sending an HTTP POST request to an EnsLib.HTTP.Service service (which has an EnsLib.HTTP.InboundAdapter associated).  In this request there is just one header: 

I wuold like to get it from my request . I have tried in several ways but I can't: 

set reqFrom = %request.GetCgiEnv("HTTP_requestFrom")

set reqFrom = pInput.Attributes("requestFrom")

and working with the imbound adapter but it didn't work.

What is the correct way to do that?

Thank you in advance for your help. 

It seems that everyone who is moving from Caché to IRIS have noticed this small change among other, more noticeable ones. But have you noticed that temporary globals mapping rules have been changed as well?

HI,

I am planning to build a WebApp that will have tons of data to display in tables, ability to add comments on that table rows and may be some few more small features as we move on.

1. It has to be Secure

2. It has to be fast

3. It has to be Non CSP / Non Zen

4. Will have Cache DB to pull records from but should be flexible to do that from any odbc resource

5.

Does anyone know of an API that will do a hostname look-up based on IP?  We could of course use call-out but the format of the results vary based on OS and if there is already an ObjectScript tool which will parse this then we'd rather use what is already available.

Thanks!
Ben

Hi All,

I trying to get the DisplayList data of the ValueLIst from Java using Springboot. when I try to get the DislayList data via java code but I'm getting the VALUELIST data. I don't get any idea to get that DisplayList data. Below is the example

Property PetName As %Integer(DISPLAYLIST = ",Cat,Dog,Dove,Parrot", VALUELIST = ",1,2,3,4");

Java Code:

public String PetName;

public List<Pet> getPet() {
        return ser.findAll();
    }

List<Pet> arrayList = getPet();
        for (Patient list : arrayList) {

                 String pet= list.getPet();

                 System.out.

Hello, InterSystems community!

Lately, you have probably heard of the new InterSystems Package Manager  - ZPM. If you're familiar with it or with such package managers as NPM, Dep, pip/PyPI, etc. or just know what is it all about -- this question is for you! The question I want to arise is actually a system design question, or, in other words, "how should ZPM implement it".

In short, ZPM (the new package manager) allows you to install packages/software to your InterSystems product in a very convenient, manageable way.

Hello,

I have a little problem that appears to my newest program. One of the purpose of my program is to  transfer a file from a path to another one.

Another person/entity places the file into a specific file ( let's call it \\Server\) but the problem is that my service (a simple EnsLib.File.PassthroughService) takes it and places it directly into my other path. The pdf file is very big and it happens almost all the time that the size of the output file is not the same as in input and so is corrupted.

In the first article I started discussing RESTForms - REST API for your persistent classes. We talked about basic features, now, I'd like to discuss advanced features - mainly queries capabilites:

• Basic queries
• Query arguments
• Custom queries

Queries

Queries allow getting slices of data, based on arbitrary criteria. There are two query types in RESTForms:

• Basic queries work for all RESTForms classes once defined and they differ only by the field list
• Custom queries work only for the classes in which they are specified and available, but the developer has full access to query text

Hi Community,

Please welcome the new Global Summit 2019 video on InterSystems Developers YouTube Channel:

⏯ InterSystems IRIS Containers for Developers

Hi Community, we would like to share the news about the "Bell State" example (a compact quantum computing program) automated using our ML Toolkit with a Rigetti QVM running in the background:

Hi Community,

The new video from Global Summit 2019 is already on InterSystems Developers YouTube:

⏯ InterSystems IRIS Roadmap: Analytics and AI

Off the back of the Interface Monitoring post I had created a class that queries the Ens.AlertRequest global and returns the entries between 6pm the night before and 6am in the morning.   

I tested this build in our T&D environments and the build worked very well.

However in our production environment the query is being truncated, by what I believe to be a timeout and I get a partial query output.

In the System>SQL pages my 12 hour query times out.

I compared the Global size by running a SELECT MAX(ID) query and got a return of 60,244,962 records.

I've been having a blast with the Advent of Code puzzles this year - though I'll be heading into a busy span of time with family soon and will probably drop off toward the end. (At least, that's what always seems to happen - it's a good thing, though!)

I had a whole plane ride to play around with Day 13 and wanted to share some fun terminal tricks.

Hi All,

I am getting error while opening the PDF report in cache 2017 instance, I am using this below piece of code to open PDF in browser.

                S pdf=objResult.FormattedReport  // FormattedReport property is a %GlobalBinaryStream
                D pdf.%Save()
                D pdf.SetAttribute("ContentType","pdf")
                D pdf.SetAttribute("Expires",0)
                D pdf.SetAttribute("CONTENT","NO-CACHE")
                S oid=pdf.%Oid()
                S %session.Data("CacheStreamId")=oid
                S StrOid=..Encrypt(oid)
                W 

This series of articles would cover Python Gateway for InterSystems Data Platforms. Execute Python code and more from InterSystems IRIS. This project brings you the power of Python right into your InterSystems IRIS environment:

• Execute arbitrary Python code
• Seamlessly transfer data from InterSystems IRIS into Python
• Build intelligent Interoperability business processes with Python Interoperability Adapter
• Save, examine, modify and restore Python context from InterSystems IRIS

Other articles

The plan for the series so far (subject to change).

 the file being created on the FTP server will have a format that includes the current date I would like to pull this file off the FTP while ignoring other files on the same location.

Inbound Service Class

I would like to find the file on the FTP that is being created using Todays date. But it appears that the wildcard are not recognizing the file format:

Example below. This will not pull the file "ErrorFile_20191216.txt"  off the FTP but it should. Should I be using custom code or can utilize  something built in to do this. Am I missing something? Thanks in advance.

I configured a SQL inbound adapter to monitor my local Cache database.

But I got "ERROR <Ens>ErrOutConnectFailed: ODBC Connect failed for 'SAMPLES' /
'' with error ERROR #6022: Gateway failed: DSN/User Connect."

Same error if the DSN setting is blank or set to my namespace.

Question is whether SQL inbound adapter is for external database server ONLY?

Hi Developers:

There's lots of news in this month's Developments newsletter for customers and partners. InterSystems made the Gartner Leaders Quadrant and ranked high in other analyst reports. There have been several major product releases. And the recent "AI Robotization (Python, R, Interoperability) for InterSystems IRIS"(Anton Umnikov, Eduard Lebedyuk, and Sergey Lukyanchikov) is now available on demand. 

You can download the latest issue from our landing page.

If you don't get Developments, consider SUBSCRIBING. 

s txt(1)="1"

s txt(2) = "2"

s txt(3)="3"

...

s txt(n)="n"

 Instead of hardcoding "d ..write(txt1(1),txt(2),txt(3))"

Is it possible to write code to generate the input parameters to do d ..write(txt1)...txt(n))?

ClassMethod write(Arg... As %String)

{

  s cnt = $GET(Arg, 0)

}

Hello All,

We need to develop a small csp application which shows data in simple paginated / searchable table for business users. 

It is to be built on an old version of Cache and is not a big full fledged application but something temporary.  We can't use Zen and using  a combination of csp & Bootstrap as bootstrap makes the pages look beautiful with little effort.

I have built the table in boostrap and it works fine with pagination and search working perfectly 

The problem occurs only when we go above 500 records.

In the previous part of this series, we saw how to define a basic portlet. Now we will look into making this portlet reference a web page that will enhance our dashboard experience.

In this example, we will be embedding a Developer Community article along side a couple of widgets displaying information related to the number of views on the Developer Community articles. This example is not hosted on the Community Analytics server, but if it was we could see the view counts going up as we interacted with the page.

Why use this?

In a real case, perhaps you have an embedded page from an external web site showing the current Emergency Room wait times for Hospitals in your area. This portlet can be used along side widgets from your Emergency Room showing how many people are waiting, how many doctors are active, and how many people are being treated. As other Emergency Room wait times grow, you can possibly expect your volume to increase as well. This can help you make decisions on how to allocate resources.