Hi everyone,

I am pleased to announce that the Evaluation Service is now LIVE!

If you are an InterSystems End User or an InterSystems Partner and you want to try the latest version of IRIS with all its enterprise features (mirroring, ECP and sharding), and you want it NOW, this is for you.

Last comment 27 September 2019
+ 12   4 6
472

views

+ 12

rating

Hi all, it's finally time for the next release of VSCode ObjectScript extension. So what's new in this release.

  • Debugging support, for classes, routines and attach to a running process
  • Files in Server Explorer now can be edited

  • Added more details about connection errors

  • Improvements in Server Explorer build tree

  • Fixed memory leak when exporting large amount of files
  • Server view can be opened in explorer as virtual file system with schema `isfs://`
  • Option to suppress popup information message about successful compile, ("objectscript.suppressCompileMessages": true)
  • Export, addCategory setting have more flexibility in naming category for exported items
  • Formatting for commands and functions, as Word, UPPER or lower
  • Some improvements in syntax highlighting
  • Some other small fixes

Last comment 16 September 2019
+ 6   2 2
322

views

+ 6

rating

Hi Community, 

We are pleased to announce the Global Summit 2019 social media contest called "Twitter Rush"

Help us share Global Summit 2019 with the world by tweeting live about the keynotes, breakout sessions, newest technologies and awesome moments as they happen! To participate in the contest, post your updates to Twitter with the hashtag #GlobalSummit19 between the dates September, 19 – September, 25 2019.

Our #1 social media Ambassador will win a 10.5-inch iPad Air Wi‑Fi 64GB!

🎉Check out the winner announcement below! 🎉

Last comment 1 October 2019
+ 2   0 0
303

views

+ 2

rating

Hey Developers!

Please join the upcoming InterSystems Developers Meetup in Boston which will be held on September 25th, 2019! 

It will take place in Boston Marriott Copley Place from 5:30 p.m. to 9 p.m.

We meet to discuss solutions development on InterSystems IRIS. Come to tell your stories and share experience with InterSystems data platforms, for networking and developer conversations. Drinks and snacks will be provided.

The format is usual: 15 min for a session, 5 min for Q&A. 

Last comment 27 September 2019
+ 3   0 3
255

views

+ 3

rating

In an ever-changing world, companies must innovate to stay competitive. This ensures that they’ll make decisions with agility and safety, aiming for future results with greater accuracy.
Business Intelligence (BI) tools help companies make intelligent decisions instead of relying on trial and error. These intelligent decisions can make the difference between success and failure in the marketplace.
Microsoft Power BI is one of the industry’s leading business intelligence tools. With just a few clicks, Power BI makes it easy for managers and analysts to explore a company’s data. This is important because when data is easy to access and visualize, it’s much more like it’ll be used to make business decisions. 



Last comment 26 September 2019
+ 6   0 3
244

views

+ 6

rating

Hi Everyone,

New Coding Talk, recorded by @Evgeny Shvarov, is already on InterSystems Developers YouTube:

GitHub Repository Template To Develop and Debug ObjectScript in InterSystems IRIS

 

Last comment 12 days ago
+ 8   3 5
211

views

+ 8

rating

Hello friends,

I am trying to create REST API in Cache. I am getting a response from postman but when I tried to launch the same URL on the browser, I am getting service unavailable error.

This is my URL
http://localhost:57772/widgetsdirect/rest/Gunwant

Any help is greatly appreciated.

Thanks and Regards,
Gunwant Kapade

Last answer 22 September 2019 Last comment 24 September 2019
0   0 5
194

views

0

rating

Hi Developers!

Often I find questions on how to install IRIS, connect to IRIS from IDE, setup the environment, compile, debug, maintain the repository.

Here below possibly the shortest way to set up all the environment and start development with ObjectScript on InterSystems IRIS.

Prerequisites

Make sure you have Git, Docker, and VSCode installed

Install Docker and ObjectScript extensions into VSCode

Sign in or Create an account on Github

Here we go!

+ 3   4 1
0

comments

176

views

+ 3

rating

We often have troubles with performance when joining  tables  with about 10 million rows together.

Sometimes we can't say what the cache engine is doing, it's just sucks and never finishes.

Then we have to rebuild the query and loop first on Orders and then on OrderPositions.

this is what we want:

EDITED: the join was only forgotten

Last answer 17 September 2019 Last comment 17 September 2019
0   0 4
169

views

0

rating

A permanent job opportunity has arisen for a Caché/Ensemble developer with at least 5 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.

0   0 1
0

comments

169

views

0

rating

Hi,

I have a large XML zen report file that I want to convert to a CSV, what is the most efficient way to do it.

XML file:

<Details>
<Col1> aa1 </Col1>
<Col2> bb1</Col2>
<Col3> cc1 </Col3>
</Details>
<Details>
<Col1> aa2 </Col1>
<Col2> bb2</Col2>
<Col3> cc3 </Col3>
</Details>

Expected Output:

Col1,Col2,col3
aa1,bb1,bb1
aa2,bb2,bb2

Thank you.

Last answer 9 September 2019 Last comment 10 September 2019
0   1 3
168

views

0

rating

In this article, we will explore the development of an IRIS client for consuming RESTful API services that have been developed to the OData API standard.

We will be exploring a number of built-in IRIS libraries for making HTTP requests, reading and writing to JSON payloads, and seeing how we can use them in combination to build a generic client adaptor for OData. We will also explore the new JSON adapter for deserializing JSON into persistent objects.

Last comment 6 days ago
+ 3   2 1
156

views

+ 3

rating

hi,

i have two where-clauses:

a)  ... WHERE company=1 and product=7

b)  ... WHERE product=7 and company=1 

with other words the position of the where fields are swapped.

now the question is:

bring the where clauses a) and b) the same performance(queryplan) or do i have to write it in a special order???

in my point of view, there is a  parser/optimizer who cares about this, so i don't have to care about. 

Last answer 6 September 2019
+ 2   0 4
0

comments

154

views

+ 2

rating

Hi All,

I have a class method, this can be any cache expression to execute (usually a class / method and args) and and args stored in a variable, for example;

set aa = "##Class(Utils.Test).Run(1,2,3)"

do aa

I tried using $classmethod(class,method,args..), by extracting the values but sometimes there can be no arguments, or arguments such as ;

("2019-01-01","1,2,3,4")

which causes issues while running the $classmethod, (i am using $P to extract the Class, Method and args).

 

Is there any simpler way of doing this?

Last answer 23 September 2019 Last comment 22 September 2019
0   0 2
131

views

0

rating

Every developer has made the mistake of accidentally leaving temporary debug code in place when they meant to remove it after debugging is complete.  The great thing about writing in ObjectScript is that there is a way to make temporary code be truly temporary and automatically self-destruct!   This can also be done in such a way that the code has no change of making it into your source control stream, which can be helpful as well.

Last comment 6 days ago
+ 3   0 2
124

views

+ 3

rating

Code golf is a type of recreational computer programming competition in which participants strive to achieve the shortest possible source code that implements a certain algorithm.

Here's a list of Code Golf competitions we had on Developers Community.

And some interesting challenges:

Did I miss something? Add more challenges in comments.

+ 2   0 1
0

comments

124

views

+ 2

rating

IRIS offers Durable %SYS Directory as a highly useful feature for working with containers.

Before inventing the wheel once more I'd like to know if a similar feature also exists for Caché / Ensemble.
Official documentation is quite silent about.
Though I have some names in mind that might know more about   ( @Luca Ravazzolo @Dmitriy Maslennikov  ?     @Eduard Lebedyuk ?  )

Last answer 12 September 2019 Last comment 12 September 2019
+ 3   0 2
124

views

+ 3

rating

 

I am new to cache programming language . I am facing below issue . please assist.

 

Question: One persistent class ID column is a combination of its properties (Roll No and Marks) [ Exact: RollNo||Marks]. When i am running the query from Management portal it is displaying data in the same format and data is there. But in the code if i am making below statement, i am getting null value.

Set ExistsID=##Class(User.School).%ExistsId(RollNo_"||"_Marks)

set ID=##Class(User.School).%OpenId(RollNo_"||"_Marks)

 

Last answer 11 September 2019 Last comment 12 September 2019
0   0 4
122

views

0

rating

Hello, everyone,

I'm trying to find solutions to a problem that's becoming quite boring.
On only one namespace, the sudio is very slow.
The studio freezes completely for 5-10 seconds when I save or compile a class. Sometimes it also freezes for no apparent reason at a random time...
It stops when I change namespace...

Do you have any idea what that could be?

Thank you in advance

Last answer 12 days ago Last comment 24 September 2019
0   0 3
121

views

0

rating

Hi Everyone,

Are you ready yet? Have you packed all you'll need for the summit? And don't forget the needed power-socket adapters if you come from outside the US! 

Have you signed up for the Container Bootcamp on Sunday? Or one of the various Experience Labs, the many informative sessions and one of the symposia on Wednesday afternoon?

Again, there is a mobile app for attendees that should help you keep it all under control and even allow you to book time with InterSystems personnel for a one-on-one deep-dive on whatever you need.

Last comment 17 September 2019
+ 4   0 2
120

views

+ 4

rating

We've just published an update to the Serenji extension for VS Code. Starting with this version (3.0.7) you can now debug the code that implements your REST services. Here's a taster:

 

Read more about Serenji on Open Exchange.

+ 2   1 1
0

comments

119

views

+ 2

rating

Hi All,

I would like to install Intersystems IRIS studio, So I went this link 

https://login.intersystems.com/login/SSO.UI.Login.cls?referrer=https%253...

But I am getting the below error.

 

So what will be the next step for me!!! please guide me........

Last answer 11 September 2019 Last comment 13 September 2019
0   0 4
117

views

0

rating

Hello, has anyone tried to use Caché as a reverse proxy ?

We are trying to embed a dashboard server (Plotly Dash in this case, but it could be anything which runs on its application server) inside our application which is written in Caché.  
The dashboard/report server runs locally (for example, or inside a LAN) on port 8080, and has no authentication features, so we have to implement them on a different layer, and we'd like to use Caché for it.

Last answer 5 September 2019 Last comment 4 September 2019
+ 1   0 4
115

views

+ 1

rating

Hi Community:

Could Global Summit be only a few days away? We've hit a record for attendance this year, and, if you aren't based in Boston, we're expecting summer-like weather.

I just wanted to let those of you who can't attend (maybe next year) know that you will be able to livestream the morning keynote presentations for all three days of the Global Summit. Listen in as featured speakers from InterSystems and from business, academic, and healthcare organizations share their visions of future technology.

Follow the livestream link and click the Launch button for the appropriate day.  Here's the program:

+ 3   0 1
0

comments

113

views

+ 3

rating