I need to send the data from a view that returned NULL, but is going as empty. The fields are of type String.
I'm using:
SET tSC = ##Class(%ZEN.Auxiliary.jsonProvider).%WriteJSONStreamFromObject(.tSteamJson,pObj,,,,"e")
{
"altura": "",
"atendimento_id": "3060382",
"data_atualizacao": "2021-12-16 10:39:12.0",
"data_coleta": "2021-12-16 10:37:00.0",
"data_liberacao": "2021-12-16 10:39:12.Hi Developers,
New video is already on InterSystems Developers YouTube:
⏯ Embedded Python for ObjectScript Developers: Working with Python and ObjectScript Side-By-Side
If one of your packages on OEX receives a review you get notified by OEX only on YOUR package.
So @Evgeny Shvarov suggested publishing my monthly summary of my reviews here in DC.
It reflects my experience with the status I found at the time of my review.
to dismount/mount a database, use Dismount() and Mount() methods in SYS.Database class available in %SYS namespace.
NB: the database ID is its Directory
You'll find some examples of how to dismount/mount and check if a database is mounted (Mounted=1) or not (Mounted=0), and quickly see all the attributes of a database (via zwrite)
%SYS>set db="/opt/irisapp/data"
%SYS>w ##class(SYS.Database).%OpenId(db).Mounted
1
%SYS>w ##class(SYS.Database).%OpenId(db).Dismount()
1
%SYS>w ##class(SYS.Database).%OpenId(db).Mounted
0
%SYS>w ##class(SYS.Database).%OpenId(db).Hey Community,
Day by day, our team makes the DC site a better place for InterSystems developers. This release will show how we've improved the Developer Community recently.
The key features:
Learn more about our new features below.
Hello!
I send request:
set hr.Location = "method?param=value"
set tSC=hr.Send("POST")
But when request incoming to server.com URI = "method%3Fparam%3Dvalue".
How I can disable urlencode params in URI, so that the URI remains "method?param=value"?
One of my colleagues had developed an interface in Health Connect (HealthShare 2019.1) to add large amounts of data to an external SQL Server database. The data comes from many text files with delimited rows and data for one table per file. There is a business process to read a file line by line and send an Insert Request to an operation. The request contains an Insert statement like ‘Insert into TABLE columns (col1, col2, … colZ) values (val1, val2, … valZ).’ The Health Connect operation utilizes Outbound SQL Adapter to insert one row into a table per request.
Hello,
I am in the process of trying to create a GIT repository and I am struggling to export all the relevant classes from Studio, as I only have access to Studio and not able to export via the Management Portal. Does anyone have any suggestions as to how I can export from Studio as one project to include all the relevant folders and its associated classes?
Are there also any recommended documentations/links you would suggest to help me get a better understanding of GIT and how it works etc?
Thanks!
Pavi
Hi Community,
New video is already on InterSystems Developers YouTube:
⏯ Updates on Security: OpenSSL and a New "Security" Database
we have a issue with just the 1 namespace, where users log using ldap but arent getting any roles assigned to them.
Ldap does work as the user account is created as a ldap user.
I have gone through the various settings to check that all is setup as required, but cant find a reason why the roles arent being assigned.
Hey Community,
Welcome to the second InterSystems technical article writing competition! Write an article on any topic related to InterSystems technology:
🎄 InterSystems Tech Article Contest: Christmas Edition 🎄
Duration: November 25 – December 25, 2021
Prizes for everyone: Everyone who publishes an article on Dev Community during this period will receive a special prize pack!
Main Prizes: Apple AirPods Max / Oculus Quest 2 (VR Headset) / Amazon Kindle / Apple AirPods Pro / Raspberry Pi
Join our new contest and your content will be seen by over 55K monthly readers! Details below.
As you can see in my profile I teach at a university and I wanted to share my take on teaching IRIS (or Caché before it).
It’s been some time but I remember seeing a series of articles by @Yuri Marx earlier this year about the course “Developing with InterSystems Objects and SQL”. He actually gave a brief description of what’s done on Day 1, Day 2, and Day 3 with comments from instructor @Joel Solon. And I thought to myself, it may be interesting to share my experience.
Currently IRIS only supports up to version 4.5 of .NET. Are there plans to support the latest versions, such as .NET 6 and also NET Core 3?
Hi folks
We are upgrading TrakCare from 2017 version to 2020, when I tried to reconnect our applications with new upgraded environment through IRIS ODBC driver instead of cahe ODBC driver I got this error: "the driver doesn't support the version of ODBC behavior that the application requested" while it is working fine with cache driver. Any help please ?
SAM only makes Management Portal connections to http.
Has anyone figured out how to get to the SMP through SAM when the instance server is setup for https:
Hi folks!
While browsing tables in Management Portal is there an easy way to open a related class (e.g. to see its documentation)?
There is a Documentation dropdown but the Class Documentation button is disabled.
Thanks!
Just wanted to give visibility to a place in GitHub where everybody can publish Enhancement Requests, Ideas and Innovations that would be great to have in our InterSystems Technology ecosystem.
If you want to add your enhancement request, or take a look and see if there is already there and vote for it, contribute, etc..., click on this link. That doesn't guarantee that Product Management decides to go on that direction, they have to balance many things to decide our products roadmap, but having the direct input from our Community is invaluable.
Come on! Go for it and make your suggestions!
Hi
I have a question about something in Studio that has been bugging me for a while. Why does the font of some items in the Classes treeview (View > Class View) appear in italics whilst others do not?
Cheers
Andy
Hello Community,
I am trying to insert multiple values in a table. Below is the simple sql statement.
Insert Into TableX
values ('Name', 'Address', 'Phone')
How can i do multiple inserts(rows) in one single statement?
Values are not in another table, so i cannot use Select into.
Thanks,
Jimmy Christian.
What about having your IRIS REST APIs scanned every push you did and being reported on possible vulnerabilities? This is what I am going to show you in this article.
Recently, we had the Security Contest with amazing applications and examples showing how to improve security on your IRIS solutions. One of such examples was the zap-api-scan-sample, made by me and my colleague Henrique Dias. Our application shows how to use the OWASP ZAP API scanner to perform security tests on your REST APIs OpenAPI definitions generated by IRIS.
Have you tried the InterSystems learning platform lab for IRIS IntegratedML? In that lab you can train and test a model on a readmission dataset and be able to predict when a patient will be readmitted or not, or calculate its probability of being readmitted.
You can try it without any installation on your system, all you have to do is start a virtual lab environment (Zeppelin) and play it around!
Setting the Scene
I was editing the properties of a persistent ObjectScript class the other day and noticed that the storage definition wasn't updating to reflect my latest changes.
In this case, I deleted a property that was no longer needed from the class definition, saved, recompiled, and still saw it in the storage definition.
No problem, I thought. If the storage definition gets autogenerated on compile, I can just delete it and recompile the class. Sure enough, after doing this, I no longer saw the deleted property in the storage definition.
There, problem solved.
I installed a community version of Intersystems IRIS in a Large AWS EC2 instance to do some testing. I installed SAM and when I try to "Add a new cluster" I receive the following: "ERROR #5005: Cannot open file '/config/prometheus/isc_tmp_yml_file.yml'"
Screen shot included here: https://share.getcloudapp.com/RBu4K5yv
I want to make the LOCATION for a %Stream.FileCharacterGzip property we have in a class parameterisable (as in stored in a global), so it can be different for different customers. Is that possible? I've tried doing it a few different ways:
Creating a parameter
Parameter STREAMLOC = {^websystem("auditstream-location")};
then I tried to reference that in the
Property HTMLZIPDoc As %Stream.FileCharacterGzip(LOCATION = ..#STREAMLOC);
but the compiler doesn't like that.
I've also tried adding something to %OnOpen and %OnNew:
Method %OnOpen() As %Status [ Private, ServerOnly = 1 ]
{
S .
I need some help with unescaping a value in TXA 2 of an MDM message that I am writing to a variable, to be used in a filename for a PF. Would I use the method Unescape(pData) if so how can I use it in a transform to set the variable? The reason I need to do this is I need to use the name as file name when writing the PDF to a directory. The escape characters and invalid for file names .
I've found a couple of methods that will tell me whether a package is mapped from another database, but not which database. Is there such a method/routine?
In my previous post I described how to install the pre-release of the Server Manager 3 extension and benefit from enhanced security for your stored credentials.
Now by upgrading to the latest release (1.2.7) of the InterSystems Language Server and opting in to the 1.3 pre-release of the ObjectScript extension you get the additional reassurance of being notified whenever either of those extensions try to access stored credentials for the first time.
I am so proud and excited to share this news!
Influitive Announcement with all Winners here
BIG thanks to you, our awesome Community members - you made this possible! We got this win together!
We will continue building the best engagement program for you, dear Community Members - more exciting things to come in 2022! Stay with us!
Hi Community,
Join us for this walk-through of InterSystems Package Manager ZPM advanced features for developing and deploying InterSystems IRIS solutions:
Dear Community Members,
Has someone built some kind of Adapter (or other related components) to interact with Couchbase?
Something sharable?
What connection method did you choose - for example REST API / .Net or Java SDK?
Thanks!
