I am still new to cache objectscript and am trying to figure out how I would go about removing the escape characters from my JSON below. When I call the $toJSON method it's adding the "\" character in the file path.
Â
{"FileStatus":"P","Path":"\/somepath\/test\/test123\/filename.txt","InterchangeOID":"100458"}
My Code
Hello all,
I am still learning CACHE and have below question.
In one of my ZEN method i am creating a table using
Does any one knows how to concatenate a $USERNAME or any content of a variable to the name of table
Hi Community!
You've possibly noticed ES switcher in articles.
If not - we recently introduced the option to switch to the Spanish version of the article.Â
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:
The plan for the series so far (subject to change)
Class ICT.Experiments.A Extends %Persistent
{
Property Name As %String;
Property Collection As list Of ICT.Experiments.B;
Property Collection2 As array Of ICT.Experiments.C;
}
Class ICT.Experiments.B Extends %Persistent
{
Property Name As %String;
}
Class ICT.Experiments.C Extends %Persistent
{
Property Name As %String;
}I have the classes above and I can select columns from the array collection by using two joins as follows:
SELECTÂ
mainTable.ID, mainTable.Name, c.Name
FROM ICT_Experiments.A mainTable
LEFT JOIN ICT_Experiments.A_Collection2 arrayTable ON arrayTable.A = mainTable.%ID
LEFT JOIN ICT_Experiments.C c ON c.%ID = arrayTable.Collection
Dear team,
I am trying to experiment the Docker container in our development environment. I have successfully build an image and running the container. When I access the CSP portal home page ( http://<host-ip>:57772/csp/sys/%25CSP.Portal.Home.zen?$NAMESPACE=%25SYS), I am getting the following error:
Â
I logged in to the running container (docker exec -it <container-id> sh), issued the command, 'ccontrol list' where the state says 'warn'
Hello,
I am trying to run a simple SELECT STATEMENT in USER NAMESPACE.
SELECT * FROM projectname.table
What is the syntax if i need to get data for a table in another namespace eg. SAMPLES., SYS
SELECT * FROM SAMPLES.projectname.table  is not working.
Thanks in advance.
Jimmy Christian.
I have a process that takes data from a CSV file (actually a record mapper object) and creates a nicely formatted JSON string I would love to send this along to a RESTful business operation. However no matter what I try, I continually get <INVALID OREF> errors when trying to populate the object that extends Ens.Request to give it the JSON string.
I can add strings, other objects, you name it - but stuffing a JSON formatted variable/object into another object I want to send someplace is proving to be an impossibility.
Does anyone have an example of sending an Ens.Request or other object (not an HTTPRequest object - but some other custom object) containing a JSON string to an Operation where the operation ultimately pulls the JSON from the object that was sent to it, makes the REST POST call and sends the response back
This series of articles would cover Python Gateway for InterSystems Data Platforms. Leverage modern AI/ML tools and execute Python code and more from InterSystems IRIS. This project brings you the power of Python right into your InterSystems IRIS environment:
The plan for the series so far (subject to change)
Wanted.
  Cache experts from anywhere in the world who would take the opportunity to be sponsored to work in the UK.Â
Â
  Please send your CVs to recruitment@hulatech.com
Terminal scripts can be used to run pre-designed commands on the terminal, like a batch file. You can write anything that can be executed on terminal, like for loop, if else and so on, inside Terminal scripts. In this article, I will show you how to call Terminal scripts, how to use parameters in Terminal scripts and how to avoid session disconnected when running Terminal scripts. If you have any information about how to use Terminal scripts or you have any feedback, please feel free to leave a comment
Launching IRIS Using Docker
Â
Â
This brief document will walk through the steps to launch IRIS community edition using Docker on the MAC. For those new to Docker, the first two pages explain how to install Docker, and run some basic commands that will be needed to get the IRIS community edition running. Experienced Docker users can skip directly to page three.
Â
Â
When I tried to make change in DTL view then only i see following error whereas in XML mode no issue in compilation.
Any resolution and solution ? it looks like some missing xml parser configuration or Pulg ins ?
ensEPC.DataTransforms.dtEcgCEpc081518.dtl was saved locally but could not be saved remotely.
ERROR <Ens>ErrInvalidDTL: Invalid DTL
ERROR #5001: attribute 'sourceclass' is not declared for element 'transform'
ERROR #5001: attribute 'sourcedoctype' is not declared for element 'transform'
ERROR #5001: attribute 'targetclass' is not declared for element 'transform'
ERROR #5001: attribute 'targetdoctype' is not declared for element 'transform'
ERROR #5001: element 'assign' is not allowed for content model '(annotation?)'
ERROR #5001: element 'assign' is not allowed for content model '(annotation?)'
Thanks in advance...
Sudhir
Hey Developers!
Do you want to reap the benefits of the advances in the fields of artificial intelligence and machine learning? With InterSystems IRIS and the Machine Learning (ML) Toolkit it’s easier than ever.
Join InterSystems Sales Engineers, @Sergey Lukyanchikov and @Eduard Lebedyuk, for the Machine Learning Toolkit for InterSystems IRIS webinar on Tuesday, April 23rd at 11 a.m. EDT to find out how InterSystems IRIS can be used as both a standalone development platform and an orchestration tool for predictive modelling that helps stitch together Python and other external tools.
Hi Community!
With this release, we've introduced the support of companies on Open Exchange.
See the details below.
All,
I've been following the " Build your First application with Cache " Learning path and followed to steps for installing the Atelier eclipse plugin.
It appears that the repository for the plugin is missing the "content.xml" file.
Parent Path:Â https://atelier.jfrog.io/atelier/updates/stable/1.3/
Hello,
1)
I am trying to have a ZEN datacombo to display list of Namespaces column using a Class Query.
This Classquery works fine in <tablepane> and also from terminal.
But the datacombo is not displaying the "Namespace" column but only the last two columns. I have tried property displaycolumn="1". But this is not working
Hi,
I have a global that holds users name and date of birth.
I would like to loop through them and check if the date of birth is more than 2 years based on todays date
so I have ^checker("under2", "Eric David", "02-05-2018")
I want to check the birthdate based on todays date to see if it is greater than 2. How do I access the birthdate in the global
Please can you advice
I tried :
set values = $order(^checker("under2"))
set td = $zdate($horolog, 3)
set ol = $p(^checker("under2"), ",", 3) // this does not work
while (values ' = "")
{
set difdays = $system.SQL.DateDiff("d", ol, td)
if difdays > 730
{
set ^value("greater than 2")
}
}InterSystems supports use of the InterSystems IRIS Docker images it provides on Linux only. Rather than executing containers as native processes, as on Linux platforms, Docker for Windows creates a Linux VM running under Hyper-V, the Windows virtualizer, to host containers. These additional layers add complexity that prevents InterSystems from supporting Docker for Windows at this time
Hi guys,
I'm curious about the development processes of those of you using Angular.Â
The starting point is that, somewhere, there lives an Angular project full of (mostly) typescript files. Eventually, those files need to be built, and the resulting built files served up to a browser.
Given that, let's say I want to go change one of the typescript files. What are some clean ways to, during development, see that change reflected on the active webpage in the development environment. For something like a .cls or .csp file, after you save and compile a changed file in Studio/Atelier, the IDE handles that entire build process for you, and from the developer's perspective it's just: compile, reload the webpage, and your changes are there
We at George James Software are pleased to announce that our acclaimed code debugger and editor Serenji is now available as a Visual Studio Code extension.
As well as supporting the latest InterSystems IRIS platform Serenji also works with earlier platforms, including versions lacking the server-side Atelier API support required by other VS Code extensions.
Serenji connects you directly to the code in your namespaces, resulting in an experience more familiar to existing Studio users. No need to export and import classes and routines.
We believe Serenji is the first extension to bring VS Code's powerful debugging features to ObjectScript developers.
What is the process in importing a role from one server to another server?
Let's say Server A is our main server that we maintain all of our resources / roles / users. We would like to get these over to Server B, Server C, Server D, etc.
It looks like when we import, there are tables and resources left in the destination servers that are not in the source server. It looks like whatever was in the destination server that was not part of the source server was not deleted from the import.
What is the proper way of exporting/importing a role so that this does not happen?
I managed to use CacheGlobalOrder to iterate over global and return the next subscript
I'm using callin to get global values.
Here's a simple function to get string value from global and return it:
int GetGlobalStr(char *global, CACHE_EXSTRP result)
{
int push = CACHEPUSHGLOBAL(strlen(global), global);
// narg Number of subscript expressions pushed onto the argument stack.
int narg = 0;
// flag - Indicates behavior when global reference is undefined:
// 0 — returns CACHE_ERUNDEF
// 1 — returns CACHE_SUCCESS but the return value is an empty string.
int flag = 1;
int get = CACHEGLOBALGET(narg, flag);
int pop = CACHEPOPEXSTR(result);
return ZF_SUCCESS;
}I get global value in result successfully. However I need to iterate over $lb. How can I do that?
Â
Estimated reading time:Â 6 minutes
Â
Hello everyone,
I was first introduced to TDD almost 9 year ago, and I immediately fell in love with it.Â
Nowadays it's become very popular but, unfortunately, I see that many companies don't use it. Moreover, many developers don't even know what it is exactly or how to use it, mainly beginners.
Â
Â
My goal with this article is to show how to use TDD with %UnitTest. I will show my workflow and explain how to use cosFaker, one of my first projects, which I created using Caché and recently uploaded to OpenExchange.
So buckle up and let's go.
Â
I have problem with Cache installed on a colleague's Windows 10 laptop. On the laptop, Cache was automatically configured to use IIS and this has worked fine with csp applications configured in the Management Portal.
Now this seems to have stopped working, and I can't work out why. In IIS, the web application seems to be in the correct place.
I have manually mapped the various file extensions to CSPms, as per the documentation, but any attempt to navigate to a csp page produces an 500 error, which tells me precisely nothing about why this is happening.
For example,
http://localhost/csp/myapp/login.csp -> 500 error
Â
Â
Â
I have re-installed Cache, with the repair option in the hope that this would reset any mappings or config settings to do with IIS, but it, too, has achieved nothing.
I am not a webserver guru, and this is the first time I have mucked around with IIS in literally years
Hi Team,
I am using Angular 7 with angular material for my client application that connects and obtains Access token from IRIS Authorization Server (OAUTH 2.0). The problem that I am facing right now is regarding this access token being exposed to browser and stores in the local storage of the browser.
