InterSystems IRIS is a Complete Data Platform
InterSystems IRIS gives you everything you need to capture, share, understand, and act upon your organization’s most valuable asset – your data.
As a complete platform, InterSystems IRIS eliminates the need to integrate multiple development technologies. Applications require less code, fewer system resources, and less maintenance.
Hi,
I want to do ordering dynamically in Query. I mean to say that order by value will not be hard coded in query, it will be passed in parameter.
I have tried to it following way, but it is not working for me. Can you please advise me how can I achieve it?
In below code, Order by :objSearch.SortingField is not working.
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.
Hi Community!
Enjoy watching the new video on InterSystems Developers YouTube, recorded by @Thomas Carroll, Cloud Market Technical Specialist at InterSystems.
How Are Containers Different From Virtual Machines?
Hi Developers!
Suppose I have a project where I want to build an IRIS container with two different dockerfiles depending on goals. How can I make it?
The issue is that docker-compose is looking for the file with name 'dockerfile'
Are there any #IF constrations in a dockerfile syntax?
Commenting works but sometimes it's more than one line.
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.
Hey Developers!
We are pleased to invite you to the upcoming webinar "InterSystems MLToolkit: AI Robotization" on 18th of September at 10:00 (GMT+3)!
Hi Community!
New video is already on InterSystems Developers YouTube Channel:
Making Cloud Deployments Cost Effective
OAuth server to be deployed on the IRIS learning cloud platform. Clients - one on the other instance of the learning IRIS server, the other client locally on my computer in the container docker.
Both clients get a seemingly correct link (through ##class(%SYS.OAuth2.Authorization).GetAuthorizationCodeEndpoint()) to the login request form:
Since Caché 2017 the SQL engine has included new set of statistics. These record the number of times a query is executed and the time it takes to run.
Hi,
I'm sure I'm not the only one who's already assembling matching pairs of socks for this year's Global Summit in Boston later this month 
. In case you haven't registered yet or are still looking for the right justification to get the eventual approval to attend, here's a quick overview of all the sessions around Data Management and Analytics:
Hello everyone,
After some work with IRIS we want to share our ToolBox-4-Iris with you.
What is this about?
The ToolBox-4-Iris is an API for IRIS with a collection of handy and useful tools - features that are not available in IRIS, but greatly simplify application development. To save time and effort on the "typical tools" that every developer needs. This includes additional classes, individual methods or even more efficient macros, which are described in the respective packages.
Content
I want to assign below query result into my Person class which have Name,DOB properties, and then convert into JSON.
SELECT Name,DOB FROM Sample.Person
I got below error when passing Date in timestamp format.
I am using %JSON.Adaptor. Please refer screen 2
.png)
.png)
.png)
Some time ago, InterSystems introduced the concept of %DynamicObjects.
This feature is a powerful tool that makes it very easy to convert any string of JSON text to objects and vice versa.
However, in the work that J2 Interactive is doing for our customers, there are a couple of things that "need some tweaking".
Hello everyone!
Recently I search how to convert Cyrillic to Latin with Cache Object Script, but didn't find anything and decided to write ourselves,
So here code:
Hi Developers!
Often when we develop some library, tool, package, whatever on InterSystems ObjectScript we have a question, how we deploy this package on the target machine?
Also, we often expect that some other libraries already installed, so our package depends on them, and often on some particular version of it.
When you code on javascript, python, etc the role of packages deployment with dependency management takes package manager.
So, I'm pleased to announce that InterSystems ObjectScript Package Manager available!
Hi Team,
I am using %JSON.Adaptor class for Json validation.
Using below statement I got only one required field validation.(refer below screen)
SET stat = objExternalUser.%JSONImport(%request.Content)
I need summary of all required field.
.png)
.png)
Hi Everyone!
New video, recorded by @Benjamin De Boe, is already on InterSystems Developers YouTube:
Scaling Fluidly with InterSystems IRIS
I need RowId of inserted record.
I have used below logic to get max row id,
but it will not give desired result when multiple people enter record in the table at the same time.
.png)
Hi Developers!
A question to those who use VSCode to code InterSystems ObjectScript.
Suppose you have the ObjectScript code on IRIS server and you want to export it into the desired folder.
And you have VSCode connected to the server.
What is the way to tell VSCode that I want to export classes into some particular folder in /package/class.cls way?
E.g. into:
/project_folder/src/cls/Package/class.cls
and project_folder is opened in VSCode as the folder of the project.
Hi Community!
Sometimes I meet a method which accepts 10+ parameters.
And often I need only the 8th parameter to pass. And I call the method something like:
do ##class(Some.Feature).Method(,,,,,,,"flag")And I don't like this method when I call it like this cause, you know, often I just miss the number of commas and raise some other flag I wanted.
How do you avoid this situations?
If you meet such a code, how do you call it and sure that you didn't miss the number of ","?
What is a good number of parameters in a method and f you need to pass more parameters in a method what do you do?
Can you please provide steps to debug in VS code using serenji and how to put break point in VS code, I have tried using F9 but it is not working.
I want to debug API code using postman.
I have created below Add method in REST api, I got requested data in objExternalUser object but it is not saved to DB.
Using "Write objExternalUser.%JSONExport()" I got JSON data.
Please refer below screen.
.png)
Hello, I have a task created in my task manager, calling my Business Service class, and it's working fine.
But I need to know the ID of the task, I searched within the class %SYS.Task.Definition and found nothing related.
Hi All,
I have created a REST class in which have the Parameter HandleCorsRequest = 1;
I can able to access the API using Postman, but not with my web application. It throws the below error.
Access to XMLHttpRequest at 'http://localhost:52773/IrisVSCode/app/test' from origin 'null' has been blocked by CORS policy: Response to preflight request doesn't pass access control check: No 'Access-Control-Allow-Origin' header is present on the requested resource.
Our team is reworking an application to use REST services that use the same database as our current ZEN application. One of the new REST endpoints uses a query that ran very slowly when first implemented. After some analysis, we found that an index on one of the fields in the table greatly improved performance (a query that took 35 seconds was now taking a fraction of a second).
Hi Community!
Enjoy watching the new video on InterSystems Developers YouTube, recorded by @Joel Solon, InterSystems Senior Technical Trainer:
I have created store procedure using management portal.
how to alter or modify SP using SQL in management portal.
Please refer below screen.
.png)
Hi Community!
Two more new videos are already on InterSystems Developers YouTube Channel:
1. Machine Learning - How it Works - Part 1
2. Machine Learning - How it Works - Part 2
