#Caché

30

  

InterSystems Caché is a multi-model DBMS and application server. See more details here.

Documentation.

Hi everybody,

Is there any functionality I could use that triggers real time user-defined code on certain audit events? Right now I am interested in triggering such code on a routine modification event, like the one below. I do know how to access this record programmatically, via %SYS.Audit.

Thanks in advance,
Anna

1 8
0 408

Hi,

So I am a front end developer working with REST API with Cache database on the BE. The BE guys are currently using Cache through a Windows virtual machine and they claim it is not possible to have a development server to work with. All the work they are doing is directly on the production server and changes are immediate and I think this is a bad idea going forward and we most definitely need a development server that has access to the same code base and different version (through git) to be able to do development. We also do all the testing on this production server with test accounts, but we cannot do automated testing with this setup.

0 11
0 714

I need another set of eyes to look at the following. Instead of a Data Lookup table, I wanted to try to lookup a value against a Cache table that I had build. So I thought I could write a function to run a simple SQL query against the Cache Table and return me a %Boolean value back to my routing rule. However today I found that it was not working properly.

Can someone take a look at the following method and verify that I am doing this correct?

index = column name

value = HL7 field that I am passing into the method

0 4
0 522
Question
· Jan 5, 2021
OpenVMS versions

I'm just clarifying that 2017.1 is viable on 8.4-1H1. can someone please confirm, also what kind of support would we receive if we upgraded to 8.4-2L1? I know that 2015.2 works on it. yet it says it's not supported.

we really need to get to 8.4-2L1. any help would greatly be appreciated.

thanks

Paul

0 10
0 546

Two permanent job opportunities for Caché Developer/Programmers. Small company, remote positions. Offices located in Philadelphia and Ft. Myers, FL. Development team retiring in next two years. Looking for new team. Excellent benefits including stock options and work environment. Travel and financial services industries.

2 0
0 534

The docbook chapter "Importing XML into Objects" has the following tip:

You can call the Correlate() method repeatedly to correlate more than one element, although the examples in this chapter show only one correlation.

Does anyone have a good example of multiple correlations? I've got code running that does multiple imports of the same file while changing the correlation and it's inelegant and not really what I want.

0 2
0 767

Hello,

We would need some help, please;

We would like to handle when we have a date with hours:

20201204090000

And when we have it without the hours part, as follows:

20201204

For the first case we used:

##class(Ens.Util.Time).ConvertDateTime(source.{ORCgrp(1).RXA:DateTimeStartofAdministratio},"%Y%m%d%H%M%S","%d/%m/%Y",,.tSC)

For the second one we wrote:

##class(Ens.Util.Time).ConvertDateTime(source.{ORCgrp(1).RXA:DateTimeStartofAdministratio},"%Y%m%d","%d/%m/%Y",,.tSC)
0 1
0 443

Hi,

I am very much a newbe on the subject of JWT, so please except my ignorance.

The Trust I am currently working for wish to create a framework whereby they can create REST API Services, within HealthConnect, and grant access to these using JSON Web Token Authorisation and Bearer Tokens. This would be similar to the way the Trust currently connects to other REST API's, i.e.: DocMan Connect and GOV.UK Notify.

Can anyone offer any advice / sample code and / or point me into the direct of suitable documentation to achieve this?

0 4
0 1.3K

Currently running on limited hardware, Online Backups are becoming a bottleneck for our system.

For now, we are exploring an option to backup individual databases, or groups of them, thus reducing RAM requirements per individual backup task. To do that, however, we'd need a separate Backup List for our Backup Tasks. We did not find an option to do so in web portal, so currently we are looking at inheriting from system backup tasks and Backup.General classes to generate Backup List before backing up and then performing the backup as normal.

1 3
0 565
Discussion
· Jan 25, 2021
web service api consumed license

1) Does web service access consume license?

2) In web service program, we used a connection pool to reuse the session id, but it doesn’t work, the license consume increased quickly, it seems connection pool didn’t work, do you have any sample to do it?

1 1
0 293

While the integrity of Caché and InterSystems IRIS databases is completely protected from the consequences of system failure, physical storage devices do fail in ways that corrupt the data they store. For that reason, many sites choose to run regular database integrity checks, particularly in coordination with backups to validate that a given backup could be relied upon in a disaster.

16 8
9 2.3K
Question
· Jan 14, 2021
Page break - Zen Report

I have two tables in a row in my report, but if the first table gets too big to the point that tables 1 and 2 don't fit on the page, the page breaks.


The problem is that the page break is happening in the middle of table 2 and I wanted the page to break and leave table 2 on the second page.


No table grows to the point of occupying more than one page alone.


Any tips on how to guarantee this?

Remembering that the reports were made using Zen Report.

2 1
0 315
Question
· Jan 13, 2021
Handling Errors

I have a case where our EMR is sending data, but not all the values needed for the Ancillary are valued properly and causes that message to error/halt processing on the Ancillary system, not ideal but its what they do. I would expect them to still process the message except that 1 field, but they don't.

I want to add validation to make sure certain fields are valued correctly for the Vendor.

So I add some statements to take those items that don't pass this validation out to a batch file with headers.

0 9
0 1.1K
Question
· Jan 14, 2021
Saving image data from csp

I created a csp that will capture image data from a html canvas element. I created a button element to save the contents as a dataURL string from jpeg and make a server call.

the string is too long

I would appreciate any suggestions in saving the data into the server, currently just a global.

0 2
0 470
Question
· Jan 15, 2021
Multiple servers or CSPGateways

Hello to you all,

Strange titel, so I'll explain better:

I now have IIS-server with a CSPGateway installed. This works fine. But I want to use a rest-service (or another zen-page, whatever.) on another cache-server

So on IIS i have an application called CSP. (/csp) This contains the handler to map it to the CSPGateway.
It has been configured to acces a cache-server (X) which will handle the request. But now I want, in this case, the request to be executed on another cache-server(Y).

0 2
0 332

I would like to examine the contents of my OBX-5 field and not route the message if it contains alphabetic characters. I've tried various combinations of the Match and Contains functions, with no luck. Should I be using the COS ? operator or plaini regular expressions?

e.g.

OBX-5 Contains "\D"

OBX-5 Contains "?.A"

OBX-5 Contains "[A-Z]"

0 17
0 1.7K
Question
· Jan 14, 2021
Caché for simple applications

To develop simple applications, wouldn't the Caché database be too heavy? Or are there simpler and less complex versions that can serve in the same way?

0 3
0 277

Does anybody know if there is an easy way to know if the execution of the command $System.SQL.PurgeForTable went well/wrong?

The documentation describes that a string is returned, but in fact there is a nice Quit "" in the code.

Maybe inside PurgeForTable^%apiSQL there is any process variable set when it goes well/wrong?

Thank you very much!

0 5
0 259

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!

0 14
0 964

Index to Articles

Hi All

It's been 6 weeks since my original article sad
- - - - -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.

15 3
1 1K