Hi guys!

We're continuing our updates of the 2nd day of Hacking Health Camp 2022 in Strasbourg, France.

All our mentors @Irène.Mykhailova, @Lorenzo Scalese, @Laurent Viquesnel and @Guillaume Rongier are very busy exchanging ideas with teams and giving advice. 30 minutes per team to lead them to the best solution possible.

And of course, we have a dedicated team to answer ensuing questions about FHIR while the coaches are working in their respective groups.

I have the object query:

s Rset=##class(%ResultSet).%New("%SYSTEM.License.UserListAll")

I can loop through that query and it generates the report information that I need.

I have a Python process where I use the intersys import to connect to the Cache instance. But I have been unable to determine the correct syntax in Python for this query. Being that 'UserListAll' is a query I attempted to user:

res = <query>.prepare("select * from %SYSTEM.License_UserListAll")

That failed stating 'UserListAll' did not exist. Though this did not seem to be correct, I also attempted:

<query>.prepare_class("%SYSTEM.

Hi Community,

Don't miss the new video on InterSystems Developers YouTube:

⏯ Exploring Machine Learning with R Language Gateway

See what's new in InterSystems Learning Services! In the March 2022 newsletter, you will: 

• Get an overview of the new documentation search features.
• Find content to help you prepare for certification as an HL7 Interface Specialist.
• Learn the latest on Embedded Python. 
• See how to start performing analytics in InterSystems IRIS® data platform.

Hello!

I need to create strong random password including letters and integers. Does Cache Object Script has methods to generate password or I have to create my own method ?

We've got 68 breakout sessions this year. Take advantage of early bird rates by registering today.

Hello developers,

Before, we announced that we would be taking part in the Hacking Health Camp 2022!

And we're here now, at Hacking Health Camp, in Strasbourg, France, and we will be here for the whole weekend!

Everyone from our french community team is present @Irène.Mykhailova, @Guillaume Rongier, @Lorenzo Scalese:

And we're having a blast!

We will keep you informed of how it all goes down here.

To remind you, here is our site dedicated to this hackathon: https://hackinghealth-2022.isccloud.io/

UPDATE 1pm:

So the first part of the conference is done and we have time to look around.

Hello,

I'd like to add/remove items to/from a custom HL7 searchtable (which extends EnsLib.HL7.SearchTable).

Adding new items worked fine by:

• -add new item to class definition
• compile class in all namespaces
• reindexing messages with the BuildIndex() method

Question 1:

How can I remove items from the searchtable properly? Doing the same as above (removing them from the class, recompiling, reindexing) seemed to work, but the removed items still appear in the message viewer's search criteria list. So I think there must be an additional step to the procedure. What am I missing?

InterSystems IRIS Business Intelligence allows you to keep your cubes up to date in multiple ways. This article will cover building vs synchronizing. There are also ways to manually keep cubes up to date, but these are very special cases and almost always cubes are kept current by building or synchronizing.

What is Building?

The build starts by removing all data in the cube. This ensures that the build is starting in a clean state. The build then goes through all records specified by the source class.

Hi

Can someone point me in the direction of documentation that shows the security standards(ISO) certification for the Clinical Viewer.

Regards

Bradley

The PDF version (when you click article title, the link to the pdf it is showed) allows you click and go to the article. Enjoy!

Hi Guys,

Can I insert a new row and enforcing my own ID not the default id increment? 

 &sql(INSERT INTO Sample.Person 
    (ID,Name,SSN) 
    VALUES ('205','Swift,Jonathan','111-22-3333'))

 IF (SQLCODE = 0) {
     Write "New Person inserted with ID: ", %ROWID,!
 }
 else
 {WRITE !,"SQLCODE=",SQLCODE," ",%msg }

I tried this in samples and got the below error:  

SQLCODE=-111 INSERT of Default Only RowID Field 'ID' in table 'Sample.Person' not allowed
 

thanks

I'm trying to create a general business rule, not an HL7 message router. (This is because i want to return values from the rules and message routing rules don't appear to be able to return values.) But, I want the business rules to be able to look at HL7 messages; I've copied a simple when condition from an HL7 message router but the error log throws up <PROPERTY DOES NOT EXIST> ...... *HL7

I'm guessing that because it's a general business rule the 'HL7.' syntatic shortcuts aren't available.

Hi:
The task Mirror Monitor Launch Task recently failed and is placed in Suspend leave. Although it says USER it is not known as a task for us. 

The code runs is HSSYS which is not our main system or namespace for production items. 

The task name is HS.Util.Mirror.Task runs 

If $system.Mirror.IsMember() Do ##class(HS.Util.MirrorMonitorAgent).StartAgent() and just says the description 

/// This is the task definition that Launches the mirror monitor on any mirrored instance

I don't understand why this task runs or what it does. I assume it has just suspeneded as the startAgent() failed.

I have a rather simplistic JSON Object of this structure: 

{"id":<someid>,"value":<some string>,"details": 
 [{"id":<someid>,"value":<some string>,"details": 
  [{"id":<someid>,"value":<some string>,"details": 
   [{"id":<someid>,"value"}
   ,{"id":<someid>,"value"} 
   ,{"id":<someid>,"value"} ]
  ,[{"id":<someid>,"value":<some string>,"details": 
     [{"id":<someid>,"value"}
    ,{"id":<someid>,"value"} ] ]
 ,{"id":<someid>,"value":<some string>} ] }
  

The depth and number of depth elements are variable.
It's a finger snip to work it down with  %DynamicObject.

Hi,

Are we correct to assume that the IKO topology only allows for the use of one 'data' node type, and one 'compute' node type? So if we want to use several different iris based compute nodes (or data nodes) we have to apply several yaml files? So the following topology config is not possible:

topology:
    data:
        image: dvza.healthexchange.nl/mmres:0.1
    data:
        image: dvza.healthexchange.nl/mmauth:0.1
    data:
        image: dvza.healthexchange.nl/somethingelsethatisbasedonirisimage:0.1

Thanks in advance.

What is Selective Build?

Selective Build is a BI feature in InterSystems IRIS (introduced in version 2020.1). Selective Build allows you to build specific elements of your cube while keeping your cube online.

What is special about Selective Build?

Before getting into the details of Selective Build, a brief recap of the different phases during a regular cube build is important.

Hi Developers!

Let's take a wild ride through the futuristic cities of tomorrow, and the technological advancements they boast! 📡

We invite you to have a journey to the Future City where you can dream of the future, check your knowledge about our Developer Community, and also imagine what the InterSystems Technology will be like. 

So get your devices ready—gear up that self-driving car 🚀, 3D-print some food 🍿, and collect some bonus points! 💰

Hi Guys,

is there an easy way to import MS Access database into ensemble? 

Thanks

I have developed a process that pulls data elements from a cache instance using the tools provided with the "intersys.pythonbind3" import. This is a windows box. After validating the process, the next step is to install the process on a site (Windows) that does not have an installed version of cache and access the cache instance remotely. But, since intersys.pythonbind3 is part of the cache install, I am not sure what to do  to allow this process to function because of the missing import.

Hello,
First of all, I apologize if I got the topic wrong.
But I'm also looking for the 2007 cache version for Windows x86 / x64.
If anyone else has it, or can help me.
Thanks

Hey Developers,

Enjoy watching the new video on InterSystems Developers YouTube channel:

⏯ Smart Data Services (Vision & Demo)

Hey Coommunity, 

Learn about InterSystems globals, the data model native to InterSystems IRIS® data platform that makes data storing efficient and provides the flexibility your data needs:

⏯ Flexible Data Modeling with InterSystems Globals

I am having trouble formatting %Time to a JSON format. I have tried configuring the parameter "FORMAT" of my property but that didn't work. For some reason, it keeps putting a Z and the end of the time. 

Property:

Property TimeCollected As %Time(FORMAT = "2");

Setting the Property through a custom function which is used in the DTL:

set convertedDateTime= ##class(Ens.Util.Time).

Let's assume that we have already connected a data source to Adaptive Analytics, created a project and added tables there.

Now we will prepare Adaptive Analytics for work. First, we need to select data from tables, to make it available for the future report. To do this, we need to create dimensions from the columns of the tables. Dimensions are usually created to break down our data into categories, such as what city the user lives in, or what month a purchase was made in.

Hi Community,

We are pleased to invite all the developers to the upcoming InterSystems Globals Contest Kick-off Webinar! The topic of this webinar is dedicated to the Globals contest.

In this webinar, we’ll show you how to deal with Globals to implement different data models and sophisticated indexes. As always, our experts will answer the questions on how to develop, build, and deploy Globals solutions using InterSystems IRIS.

Date & Time: Monday, March 21 – 11:00 AM EDT

Speakers:  
🗣 ​​​@Daniel Kutac, Senior Sales Engineer
🗣 @Joel Solon, Senior Technical Trainer
🗣 @Timothy Leavitt, Development Manager 
🗣 @Evgeny Shvarov, InterSystems Developer Ecosystem Manager

IMPORTANT NOTE InterSystems no longer provides a separate InterSystems Reports Server container. To run containerized InterSystems Reports Server, use Logi Reports Server container and your InterSystems Reports Server license. Documentation.

InterSystems Reports is powered by Logi Report (formerly named JReport), a product of Logi Analytics. InterSystems Reports is supported by InterSystems IRIS and InterSystems IRIS for Health. It provides a robust modern reporting solution that includes:

• Embedded operational reporting which can be customized by both report developers and end users.
• Pixel-perfect formatting that lets you develop highly specific form grids or other special layout elements for invoices, documents, and forms.
• Banded layouts that provide structure for aggregated and detailed data.
• Exact positioning of headers, footers, aggregations, detailed data, images, and sub-reports.
• A variety of page report types.
• Large-scale dynamic report scheduling and distribution including export to PDF, XLS, HTML, XML, and other file formats, printing, and archiving for regulatory compliance.

InterSystems Reports consists of:

• A report designer, which provides Design and Preview Tabs that enable report developers to create and preview reports with live data.
• A report server which provides end users browser-based access to run, schedule, filter, and modify reports.

From InterSystems documentation.

This article focuses on the Server part of InterSystems Reports and provides a guide on running Report Server in containers while persisting all the data.

Trying to figure out inline cache expressions in TrakCare and having little to no success, if anyone can help I'd be very appreciative :)

I'm pleased to announce the release of version 1.4.4 of the VS Code extension, which contains the following enhancements and bug fixes. Links will take you to the GitHub issue being addressed. As always, if you already have the extension installed, VS Code should automatically update your extension. If you're a new user, use these instructions to get started. 

Change Log

• Enhancements
  
  • Compile asynchronously to avoid timing out (#890)
  • Add objectscript.explorer.

I have created a package that offers a utility to load a Global into JSON object and reverse     
to create a Global from this type of JSON object. Efficient refers to the structure created.
Only Globals nodes containing data are presented in the generated JSON object.