Hi,

I have a question about deleting journals at the OS level(Linux) without corrupting the IRIS DB or it’s mirror copies.

The reason for deleting journals is the filesystem it lives on frequently fills up. 

I don't have enough disk space to further expand the journal filesystems.

When the journal filesystem fills up then the application stops.

I have the following IRIS nodes(mirror status)

LIVETC01            Backup

LIVETC02            Primary

LIVEDR                Async Copy        **OFFLINE**

ARBITER

LIVEDR is currently offline but IRIS software has been installed.

I checked inside Mirror Monitor

I am doing a HL7 data transformation with object script but need to only write a substring from the first "(" of the NTE-3 field to the end.

example

Input: NTE|1|||Some text (HI) (321)|ABC

Desired Output: NTE|1|||(HI) (321)|ABC

Basically I'd like to delete "Some text  ".

If I were writing a shell script I would use sed 's/^.*(/(/' with perhaps a modification to get only the first.

I use the function wizard but can't seem to get the right code.

This is the fourth in a series of releases that are part of the developer preview program for 2022.2 Future preview releases are expected to be updated biweekly and we will add features as they are ready.  Many updates, fixes and enhancements  have been added in 2022.2, in SQL management, cloud integration, Kafka and JMS adapters, the SQL Loader, and other areas. Please share your feedback through the Developer Community so we can build a better product together.

 The Early Access Program (EAP) is still active for the Columnar Storage.   Customers interested in exercising it should join the Ear

Kindly help me on the below points

1)Concatenate the Date column and Time column.

2)Get the current date only without time.

3)Find the current age using DOB column.

Hey Developers,

In July, you posted 83 questions on Developer Community:

And now it's time to announce the Key Questions of July, chosen by InterSystems Experts! 

Hey Community, 

See how data integration features in InterSystems IRIS data platform enable you to easily connect your systems, processes, and people: 

⏯ Integration Features of InterSystems IRIS

Hey Community,

Here is a digest of the Developer Community videos on InterSystems Developers YouTube Channel in July 2022:

Now available: InterSystems Learning News for July 2022! See how you can:

•    Sign up to be a beta tester for the InterSystems IRIS System Administration certification exam.
•    Find opportunities to keep you and your team learning.
•    Connect to InterSystems Cloud Services.
•    Take a classroom course on InterSystems Change Control Record (CCR).

And more! Read all about it and subscribe in the July 2022 Learning News.

Hi team,

I'll start with an apology as I am trying to wrap my head around the architecture of how InterSystems IRIS database management works. I am attempting to connect to the platform remotely through say a JDBC or ODBC connection in order to run queries, searches (through SQL statements) on my laptop and was trying to understand whether this would be possible? It is possible to setup an inbound client connection and wanted to better understand the architecture of how the database association works for IRIS database management. Does it use it's own internal SQL database or are we able to connect to our own database and which databases are certified to run against the platform?

Hi,

Is there a way to access the logs of a specific run of a task from the management portal task manager? I'd like to retrieve the output of a given run without going into the entire task history in an output file.

Thank you!

How to convert from internal date format to JSON/Web date format: YYYY-MM-DDTHH:mm:ss (example: 2012-04-23T18:25:43)?

Hi guys,

Does rebuilding of Data Quality Manager cubes affect patient index linkage definition data?

What I want to understand is, does DQM have any negative impact on the data each time you rebuild the cubes. 

Additionally, if I make changes to the cube and rebuild it..will this have any impact on the original data?

Hi

I'm trying to add multiple rows at a time to a SQL table for a persistent object, but I can't seem to get the syntax correct. When I try the below it doesn't work.

INSERT INTO Sample_Table.Accounts (Account, AccountName, Bank) 
VALUES 
('123456', 'AccountNameOne', 'BANK1'),
('654321', 'AccountNameTwo', 'BANK2')

Thanks

Peter

Hi Guys,

Is there online tutorials or samples on how to use Inbound Adapters ?

All I'm looking for at this stage is to create and inbound Adapter in a production to request to connect to a client where I can Get JSON file and what do I need to establish the connection?

Thanks

Hi Developers!

We have great new articles for your to read and enjoy, thanks to our wonderful participants of the 3rd InterSystems Tech Article Contest: Python Edition!

🌟 12 AMAZING ARTICLES 🌟

And now it's time to announce the winners!

Let's meet the winners and their articles:

Hi Community:

Interesting stats from Global Summit 2022. 

The 15 most popular sessions, in order by attendance numbers, were

1. Getting to Know FHIR: The Best Explanation of FHIR They’ve Ever Heard (137)
2. Health Connect Cloud (111)
3. Using Python with InterSystems IRIS (107)
4. Analytics with InterSystems: New & Next (104)
5. InterSystems IRIS FHIR SQL Builder: Sneak Peek (76)
6. API Management with InterSystems IRIS (72)
7. Ten Times Faster Queries with Columnar Storage (71)
8. The Future of Healthcare on the Cloud: Containers/ Kubernetes (71)
9. Embedded Python Use Cases (70)
10. How InterSystems Supports

Hi, we are trying to run a dynamically generated Oracle Insert SQL script using Do $SYSTEM.SQL.DDLImport("Oracle",""," sql.txt",[Error Log]) to insert multiple rows into a Linked Table within HealthConnect to an Oracle database.

We have tried using statements that are accepted within Oracle but not when using Intersystems DLL along the lines of :

INSERT  INTO mytable (column1, column2, column_n)
  SELECT expr1, expr2, expr_n FROM Dual  UNION ALL
   SELECT expr1, expr2, expr_n FROM Dual;
  
SELECT mytable (column1, column2, column_n) VALUES (expr1, expr2, expr_n)
  INTO mytable (column1, column2,

What are other's thoughts, opinions and experiences going from CSP to RESTful services, specifically when it comes to reusing code in CSP files?

One could define a method in CSP as follows:

<script language="cache" method="SubmitSomethingAwesome" arguments="aswesomeId:%Numeric"> 

And it's generated in csp.mycsppage.cls ascsp.mycsppage.SubmitSomethingAwesome(awesomeId as %Numeric).

Have people had success defining there rest call by calling the generated CSP classmethod?

Things that work well I've found:

- Procedure block is off so you can easily pass the symbol table around from the REST

I'm trying to become familiar with XSLT options in the latest version of IRIS.  The documentation here https://docs.intersystems.com/irisforhealth20221/csp/docbook/DocBook.UI… has the following statement:

InterSystems IRIS provides the following additional examples:

• For XSLT 1.0, see the Example(), Example2(), and other methods in %XML.XSLT.Transformer.
• For XSLT 2.0, see the class XSLT2.Examples in the SAMPLES namespace.

I don't find any reference to XSLT examples in the InterSystems GitHub.

During a major version upgrade it is advisable to recompile the classes and routines of all your namespaces (see Major Version Post-Installation Tasks).

do $system.OBJ.CompileAllNamespaces("u")

do ##Class(%Routine).CompileAllNamespaces()

To automate this administration task and keep a log of any errors, below is an example of a class to import and compile into the USER namespace that you can use after each upgrade : admin.utils.cls

Class admin.utils
{
ClassMethod upgrade(verbose As %Boolean = 0) As %Status
{
set ns=$Namespace
// Stopping all

Continuing to  observe the possibilities of Django, and usage with IRIS. The first we have looked how to define models and connect to tables already existing in IRIS, than we extended embedded Django Administration portal, with an ability to see what data we have in that models, with filters, editing and even pagination.

Time to go to real action, now we a going to create some REST API, on Django, based on the same data, we used before from the package posts-and-tags.

To do so, we will use Django REST Framework

Django REST framework is a powerful and flexible toolkit for building Web APIs.

Some reasons you might want to use REST framework:

• The Web browsable API is a huge usability win for your developers.
• Authentication policies including packages for OAuth1a and OAuth2.
• Serialization that supports both ORM and non-ORM data sources.
• Customizable all the way down - just use regular function-based views if you don't need the more powerful features.
• Extensive documentation, and great community support.
• Used and trusted by internationally recognised companies including Mozilla, Red Hat, Heroku, and Eventbrite.

In the first part, I've shown how to start a new project on Django, as well as define new models and add already existing models.

This time, I'll introduce an admin panel, available out of the box and how it can be useful.

Important note: do not expect that if you try to repeat actions from this post it will work for you, it does not. During the article, I had to do some fixes in the django-iris project, and even in DB-API driver made by InterSystems to fix some issues there as well, and I think this driver is still in development, and we will get more stable driver in future. Let's decide that this article only explains how it could be if we would have all done.

In this article, I am trying to identify the multiple areas to develop the features we can able to do using python and machine learning.

Each hospital is every moment trying to improve its quality of service and efficiency using technology and services. 

The healthcare sector is one of the very big and vast areas of service options available and python is one of the best technology for doing machine learning.

In every hospital, humans will come with some feelings, if this feeling will understand using technology is make a chance to provide better service.

Here we can combine both of these and in

I was wondering if someone could help me. I do not have docker available to me however a lot of the Open Exchange apps require it. Since I am using a Virtual Windows Machine I can not get docker installed, so I was wondering how to get around this? Someone at GS2022 suggested looking at the docker_compose.yml to figure out how to get around docker, but I am not sure I understand how to read it. 

Does someone have any quick solutions to get around docker compose? Or can tell me how to read a docker compose so that I can install some Open Exchange and or additional InterSystems components?

Thanks

S

Hi developers! In this article I’m going to explore the use of Iris Python Native API in a specific problem: large strings to store.

Why Python Native API?

Python Native API for Intersystems IRIS offers an useful way to persist data that you can’t have control over the schema or if the schema changes frequently. Combining the Native API with the IRIS Globals, you can easily use Iris Database as an Document Store. You can also see more details of globals use in documentation https://learning.intersystems.com/course/view.php?id=1110&ssoPass=1, or in my article https://community.intersystems.com/po

Hi Community!

We’re so glad to announce that InterSystems FHIR startup incubator —  Caelestinus held its first virtual Demo Day on June 29th!

16 startups have showed off their products and solutions built with InterSystems FHIR Server, or IRIS for Health or Health Connect to an audience of about 15 investors & partners.

The Demo Day is the result of a four-month journey — the equator of the incubator, in which startups have explored InterSystems tech, validated their ideas and presented it on the first Demo Day. In case you missed it,  enjoy watching it on InterSystems Developers YouTube:

📣 The First Demo Day of InterSystems FHIR Startup Incubator — Caelestinus

Here is the list of presenters with pitch decks of the startups.

Hello All,

   Having a recent project to create a FHIR repository, I want to know (as looking at the code) if HealthShare FHIR implementaton supports subscriptions?.  I know it records the subscriptions ok, BUT does it handle sending the subscription out (based on the tags) to an endpoint (i.e. when a new FHIR request commits data that would trigger the subscription) ?, I'm 50% it doesn't, but would rather find out for sure before shoe horning something in.

   Regards

• If I insert just plain text, the trace statement works, e.g., Value="Hello World"
• If I insert the target variable, it does not work, e.g., target.Patient.Allergies.(k1).AllergyID. For this value, compile fails with an InvalidName error ERROR #1011: Invalid name : '##class(Ens.Util.Trace).WriteTrace("user","PHI.DTL.SDAtoACX","Transform",target.