In our clients environment, multiple sources will connect to one DB (all through JDBC connections) and perform various operations. Sometimes they found some data was deleted without reason. Thus they want some feature like SQL Server Database Audit Specifications that can log who at what time with which IP deleted data in a specific DB.
I've checked IRIS Audit but I didn't find feature about that . How can we audit and log delete of a known DB? The deletions might be performed by delete statament or truncate table stattement.
Does anyone has any idea on how to send an encrypted / secure Print from IRIS ( which is hosted on AWS ) to a printer ( which is an on-premise device ).
Hi all,
By using VS code, I want to copy multiple files to local directory, then sync them to server, but I can't find where local directory is stored?
In Atelier IDE, I could open a view of server and can copy the code to the project, then code is saved in the local directory. When I copy multiple files to the local directory -> choose sync in Atelier -> the code will be synchronized to the server
How to do this from VS Code?
Thanks!
I am investigating creating builds from TravisCI, which will pull the source from github. This will also involve a code review process, pull request, etc.
It will be done in Multiple phases. The first one will not involve automated testing using TravisCI yet. It will only involve travisCI pulling the latest code from github and creating a release for testing(A deployment file in a format that can be loaded by Ensemble0)
Since I'm just starting to use this aspect of IRIS I can't tell if this is a bug or some kind of nuance. If I run a single column query like this, I get results:
However if I try to retrieve using a DISTINCT or GROUP BY, I get no results:
And again except with a GROUP BY, with no results:
It's been 6 weeks since my original article - - - - -but I have been busy on this project
I have been looking at/thinking about a replacement for ZEN for around 12 months but only really started in depth 4 months ago. Also been in IT for long enough that I can "get a feel" for a product/technology and make decisions accordingly without going into great detail. Any new technology has a learning curve and I don't want to waste time and effort on something that won't fly. And, as always, I am looking to minimise the learning curve as I want to concentrate on delivering business benefit.
DataGrip is a multi-engine database environment targeting the specific needs of professional SQL developers, DataGrip makes working with databases an enjoyable and productive experience.
To work with InterSystems IRIS from DataGrip you'll need to add InterSystems JDBC driver first (once per DataGrip) and after that add all your InterSystems IRIS connections.
We've our Cache running on Windows 2012 Server, but I've a Macbook Pro. Earlier I was using Miscrosoft Remote Desktop 8, to remote into our Windows server & everything worked.
Since version 8 is discontinued, I installed Microsoft Remote Desktop 10.5, which works for everything except starting Terminal.
I get error 'NTI Connection Error'
(287) Error writing to Pipe Reason: (998) Invalid Access to Memory Location.
If I do remote desktop from Windows machine (using same credentials), it works.
One of the leading benefits of ObjectScript is the speed and efficiency it allows for an experienced developer. Let's look at an example of how you can benefit from ObjectScript today.
Suppose you have a class that stores the names of your users. We'll call the class Data.User, and give it a string property Name. Next, we will need a method to create a new user or update an existing one. A naive, simplistic approach might look like this example:
This is a remote position for a US Citizen who has significant MUMPS background AND has experience at a deep level with Java, and AWS Services.
The location is in Kirkland Washington, however, obviously during the COVID we will be doing remote work. Our hope is some is willing to relocated to the Seattle Region after we open up again.
Given a complex method flagged with [ SqlProc ] so it is available as an SQL stored procedure, what's the best way to report a non-system error detected in that method - say, for example, an error %Status - so that the SQL query calling it fails descriptively? Is it best to create and throw an exception, or are there special % variables involved (like in a trigger)? I haven't been able to find an answer in the documentation.
Has anyone used the ##class(HS.JSON.Path).%Evaluate() classmethod interrogate JSON and return a specific object value? I need to extract the MessageHeader.destination.endpoint value from a FHIR bundle and can't seem to get that XPath-like method to work.
This post is a compilation of Top Authors, Top Experts and Top Opinion Makers of the InterSystems Developer Community in 2020. And it is a good guide "Who to Follow" in 2021.
We're glad to present these people who have contributed a lot to our community in 2020.
Let's take a closer look at the DC Wall of Fame 2020 and greet everyone with big applause! 👏🏼
the report generates statics for each ward and i want to divide specific ward 5c into two wards, the first 12 beds are for 5c - pediatric and the last 12 beds are for 5c-adults.
the report takes input from the user by selecting the wards so if the user chooses 5c, the report should show 2 wards.
the report declare cursor at the begining so how can i divide the ward.
In most organizations, events drive action. In financial services, for example, a stock dipping below a threshold price may trigger a sell order. In manufacturing, production may start when an order is received. In healthcare, an unusual increase in the number of patients registering in an emergency room could signal the start of a disease outbreak, calling for action on the part of medical staff and public health officials.
In 2020 we implemented HealthConnect as our HL7 interface engine. Having completed this, we are currently evaluating whether it would be beneficial to migrate our managed file transfers from our current MFT software, MOVEit to HealthConnect. I am interested in hearing from any InterSystems customers who have previously used MOVEit and currently using HealthConnect for file transfer managment. Any feedback would be appreciated.
Hi, I am creating a zen page which has a table pane, and loads data, using the onCreateResultSet. I have two controls which allows the user to add a date and type.
I want to add them as parameters into my sql query and update the tablepane. Can you advice on how I can do that?
The question is about queries on the System->SQL page. I have a class with a few columns on a global and the test output looks as expected, below. This works as expected as well returning a single row: select * from Utils.RoutineAuditReport where counter=4. However, other columns give an odd error like " Field 'AG' not found in the applicable tables^ SELECT * FROM Utils . RoutineAuditReport WHERE UserR = "AG". As you can see below, both the UserR column and the AG entry in it do exist. What could be the problem?