Article Robert Cemper · Apr 26, 2020 5m read

A VIEW in SQL is basically a prepared SQL statement.
It has to be executed and assembled like any other SQL query.
MATERIALIZED VIEW means that the content is collected before hands and can be retrieved rather fast.
I saw the concept first with my favorite competitor named O* and they made a lot of noise about it.

  { favorite: because I could win every benchmark against them devil }

3
1 1012
Article John Murray · Mar 3, 2016 2m read

The purpose of this post is to raise the profile of a powerful mechanism that has long been available to us, and to open a discussion about ways in which it can be used or abused.

You can read more detail about the mechanism here. To summarize, your class definition can use the Projection keyword to reference one or more projection classes. A projection class can implement methods that get invoked at key points in the lifecycle of your class.

A projection class must extend %Projection.

18
1 1710
Job Berta Perez · Jun 25, 2021

Hi,

We have an immediate requirement for an experienced Intersystems Ensemble/Healthshare Connect developer to join our team with a good grounding programming ,Healthcare Integration and experience with InterSystems Ensemble/Healthshare Health Connect.

Contractor or Full Time.

 Please if you are interested and need more info contact :

Perez.bertamaria@srft.nhs.uk

0
0 266
Article Michael Braam · Jun 2, 2021 3m read

InterSystems SAM is a great tool to monitor your InterSystems IRIS and InterSystems IRIS For Health clusters on prem or in a cloud environment. This article describes how you can implement a customized alert handler. This is currently an undocumented and most likely an unknown feature of InterSystems SAM. With future releases it will be probably made easier to leverage this useful concept.

In the interest of shortness, I will only mention InterSystems IRIS in this article, but the following applies to InterSystems IRIS and InterSystems IRIS For Health.

2
1 913
Question Nezla · Jun 24, 2021

Hi Guys,

for some reason the height in my tablepane are very big, how can I adjust the height in the rows in a tablepane?

Thanks

5
0 244
Question A.R.N. H Hafeel · Jun 13, 2021

Hello there community, 

I recently posted an article regarding a technological aspects that could boost the internet speeds of every individual/s personal work station in the given situation of the pandemic. 

But, unfortunately my article is not published and I see it under draft. 

Is there a particular reason for this please?

Have I missed something that needs to be followed? 

Is that why the article that was published is now under the draft section? 

I would like to know more on this please. 

Regards. 

2
0 297
Question Eduard Lebedyuk · Dec 21, 2016

I'm in a process of acquiring a corpus  of documents on educational courses. 

For example there is an educational course called "OOP" and it can have documents from 2008, 2009, ... 2016 etc.
And there are a lot of these courses, each one with programs from different years (hopefully)

So 1 document is 1 programm of one course for one year.

I want to calculate how much does a course changes per year.

7
0 726
Question Utsavi Gajjar · Jun 23, 2021

Hello,

I have a Business Process where I am receiving a JSON payload in the "Body" property of the my request class. I defined a context variable as an object of a class that represents the JSON schema I expect to receive and load the JSON payload in that context variable.

e.g.

/// BPL Definition
XData BPL [ XMLNamespace = "http://www.intersystems.com/bpl]
{
<process language='objectscript' request='mapi.core.msg.rq.RestBusinessServiceRequest' response='mapi.core.msg.rp.RestBusinessServiceResponse' height='2000' width='2000' >
<context>
<property name='cm' type='mapi.exchange.msg.

4
0 436
Question ROBSON SERPA DA ROSA · Jun 23, 2021

Hello community...
As there is a certain restriction of commands in Caché, and assuming that the base of most colleges ends up being MySQL, Oracle, SQL Server and others... And the last two with very simple IDEs to use and with the possibility to handle the operation in the database very well, which IDE (if there is an "official" or something like that) would be the best for me to start working more effectively with Caché?

3
0 537
Question Johnny Wang · Jun 22, 2021

I am using .net to connect to the cache database via ODBC, OdbcConnection connection = new OdbcConnection(dbConnection); connection.Open(); This error is reported when the link is opened, how should this be solved? Thank you very much!

2
0 311
Article Yuri Marx · Feb 18, 2021 2m read

There are many options to do a full security scan in your docker images, the most popular option is Anchore community edition.

Anchore will use the main public vulnerabilities databases available, including CVE.

To install Anchore is very ease (source: https://engine.anchore.io/docs/quickstart/), follow the steps:

  1. Create a folder in your OS and download the anchor docker compose file to the created folder.
    curl -O https://engine.anchore.io/docs/quickstart/docker-compose.
1
1 331
Question Warren Oyco · May 20, 2021

I am working on tweaking our current patient load process. The roster input is in text pipe delimited format, parsed out and transforms it to a standard HS.Message.PatientSearchRequest, and send to business process for patient matching. Result is transformed into a standard ADT HL7 message using EnsLib.HL.Message class. I would like to know if there is another class I can use that will transform my output to a text flat file pipe delimited instead of HL7 format? any advice on how to do this is greatly appreciated.

Thanks!

2
0 530
Announcement Shane Nowack · Jun 21, 2021

Hello All,

InterSystems Certification has designed another certification exam and we need input from our community to help validate the exam topics. Here's your chance to have your say in the knowledge, skills, and abilities that a certified InterSystems CCR Technical Implementation Specialist should possess. 

Here's the exam title and the definition:

InterSystems CCR Technical Implementation Specialist

A development professional who:

  • Uses Tier 1 CCRs to document and process change workflow
  • Makes code changes in their Integrated Development Environment of choice.
0
0 294
Question Robert Sierra · Jun 21, 2021

Hello developer community, I'm looking for Ensemble production sftp examples. I need to copy hl7 files hourly from several servers to a central server. The local documentation is no longer as good as it used to be. I remember several years ago, the documentation would take you step by step doing this.  Any information would be appreciated.

thanks,

Rob  S

2
0 367
Question Sébastien Demoustiez · Sep 24, 2019

Hello, everyone,

I'm trying to find solutions to a problem that's becoming quite boring.
On only one namespace, the sudio is very slow.
The studio freezes completely for 5-10 seconds when I save or compile a class. Sometimes it also freezes for no apparent reason at a random time...
It stops when I change namespace...

Do you have any idea what that could be?

Thank you in advance

15
0 614
Announcement Anastasia Dyubaylo · Jun 8, 2021

Hi Community,

We're pleased to invite you to the online meetup with the winners of the InterSystems FHIR Accelerator contest!

Date & Time: Friday, June 11, 2021 – 11:00 EDT

What awaits you at this Virtual Meetup? 

  • Our winners' bios.
  • Short demos on their applications.
  • An open discussion about technologies being used. Q&A. Plans for the next contests.

1
0 246
Question Carl Campbell · Jun 18, 2021

Hi Community...I am trying figure this out any help appreciated. Thanks in advance

The service is a file passthrough that picks up a  PDF and then uses the BPL  code below to create the rest wrapper and sends the stream data. I am not grabbing the stream from the inbound correctly,  "request.Stream" or "request.StreamFC" always produces the following  error.

Here is what is sent and returned in the message..

request:

<Stream>

15@%Library.FileCharacterStream

</Stream>

response:

<Stream>

Unable to load xml from message: Data at the root level is invalid.

6
0 689