Syndicate content 0  
Announcement
· May 7, 2019
Bug in DC Email System

Hi Community!

Today and yesterday a lot of you received a strange email with the subject:

InterSystems Developers Publications, Week 29 of April - 05 of May, Digest

and body:

subscription|type|digest_w|post|461231|

This happened because of a bug in our email subsystem. I bring my apologies and we are fixing the bug at the moment.

0 0
0 241
Article
· Nov 9, 2015
Adding content-

It seems pretty easy to add a post to a group or something like that. But lets take Code Packages for example. How do I go about submitting a code example to be posted under that area?

0 1
0 221

Hi Community!

We are excited to announce the first French technical article writing contest!

✍️ Technical Article Contest ✍️

This is the perfect opportunity for all InterSystems technology enthusiasts to share their knowledge and showcase their writing skills. No matter your experience level, everyone is welcome to participate. Articles can cover a wide range of technical topics related to InterSystems products or services. So, let your creativity and expertise run wild!

📅 Contest period: September 2-29, 2024

🎁 Gifts for all: a special gift is prepared for each participant!

🏅 Prizes for the authors of the best articles

4 3
0 180

InterSystems Reports version 24.1 is now available from the InterSystems Software Distribution site in the Components section. The software is labeled InterSystems Reports Designer and InterSystems Reports Server and is available for Mac OSX, Windows and Linux operating systems.

This new release brings along some great enhancements from our partner, insightsoftware. InterSystems Reports 24.1 is powered by Logi Report Version 24.1SP2 and includes:

4 0
0 240
Announcement
· Sep 11, 2023
New Video: Migrating to NoPWS

Hi all! I just wanted to share a new video – the first in a series of three – addressing the migration from the InterSystems Private Web Server to an external web server. This video covers the process of installing a web server and upgrading your IRIS instance in a Linux/Unix environment. Two more videos on the way will show the process for a mirrored setup in Linux/Unix, and for a single instance in Windows.

Migrating a Single Instance to an External Web Server in Linux or Unix

3 0
0 240

I'm trying to execute SQL on a EC2 via SSM:

import boto3

instanceid = "i-123456789"
sql = """SELECT path FROM Security.Applications WHERE ID = '/csp/sys'"""
template = """su - irisusr -c 'cat << EOF | iris sql iris -U %SYS
                """ + sql + """
                        q
                        EOF'
                       """
template = [line.strip() for line in template.splitlines()] 
template = """\n""".join(template) 
ssm_client = boto3.client('ssm') 
response = ssm_client.send_command(
            InstanceIds=[instanceid],
            DocumentName="AWS-RunShellScript",
            Comment=AWS,
            Parameters={'commands': template})

0 0
0 240

Hello!

I'm new to the system I'm working on, and I have a part of a statement that needs to grab the previous month.

....and MONTH(TX3.date_of_service)= MONTH(dateadd(mm,-1,GETDATE()))

However, when it hits January, I'm left with month 0.

Does anyone know a workaround to grab December of the previous year, while still functioning normally for the rest of the current year.

Thank you!

0 4
0 236
Article
· Nov 11, 2022 2m read
Reviews on Open Exchange - #19

If one of your packages on OEX receives a review you get notified by OEX only own YOUR package.
The rating reflects the experience of the reviewer with the status found at the time of review.
It is kind of a snapshot and might have changed meanwhile.
Reviews by other members of the community are marked by * in the last column.

1 0
0 240

Hi Community!

As announced in this post, next November 16 will take place the 1st meetup of the Spanish Developer Community. And registration is now open!

It is the first in-person event in Spain since the pandemic started and we are thrilled to reunite with our customers and partners. Are you in?

🗓 November 16, from 12:00 to 2:00 PM (CEST) + pizza & drinks

📍 The Westin Valencia Hotel

➡️ Click here for more details and registration >>

Note.- If you are already registered at the Iberia Summit and want to attend the Meetup, you have to register on the previous link too.

0 0
0 240

EnsLib.HL7.Adapter.TCPInboundAdapter has a Connected property that I assume is set to the state of the connection session with the remote host; i.e. 1 when Connected, 0 when not. I'm assuming this is the property the Production Configuration web page uses to display the state of the service (green for Connected, red for not Connected, etc.).

How can I interrogate the value of that property of an active service, via a method running in separate process?

(It really seems like I should know this, but I'm just not finding the right magical incantation)

0 3
0 237

It's time to announce the Winners for September 2021! Please welcome our awesome Global Masters Heroes!

The storm of applause goes to these developers and their great contribution to DC in September 2021:

🥇 @Robert Cemper, ex Senior Sales Engineer from InterSystems, Austria

🥈 @Muhammad Waseem, HIS Team Lead, International Medical Center, Jeddah, Saudi Arabia

🥉@Lorenzo Scalese, Solution Architect, Zorgi, Belgium

Learn more about the competition and our awesome winners below.

5 0
0 240

Hi Community!

We are pleased to invite you to the upcoming webcast in Portuguese on August 20 at 11:00 BRT:

Digital Government: Architectures and Solutions

On this webcast, InterSystems Solutions Consultant @Yuri Marx will help us understand how the 3 powers at federal, state and municipal levels are seeking the digitalization of public services.

6 1
0 220

Hey Developers,

We're pleased to invite you to the upcoming "Development of Interoperability Business Hosts with PEX in Java/.Net" webinar by InterSystems Russia on July 16 at 10:00 (UTC+3, Moscow time)!

https://www.youtube.com/embed/ArSnkOthz8E
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

1 0
0 240
Hi Community! Here is a digest of the Developer Community postings in May 2019.
Most viewed




















2 0
0 240

Over time, while I was working with Interoperability on the IRIS Data Platform, I developed rules for organizing a project code into packages and classes. That is what is called a Naming Convention, usually. In this topic, I want to organize and share these rules. I hope it can be helpful for somebody.

7 4
4 159

In my previous article, Using LIKE with Variables and Patterns in SQL, we explored how the LIKE predicate behaves in different scenarios, from Embedded SQL to Dynamic SQL, and what happens to performance when wildcards and variables come into play. That piece was about getting comfortable writing a working LIKE query. But writing SQL that works is only the starting point. To build applications that are reliable, scalable, and secure, you need to understand the best practices that underpin all SQL, including queries that use LIKE.

This article takes the next step. We’ll look at a few key points to help strengthen your SQL code, avoid common pitfalls, and make sure your SELECT statements run not just correctly, but also efficiently and safely. I'll use SELECT statements with LIKE predicate as an example along the way, showing how these broader principles directly affect your queries and their results.

*This is what Gemini came up with for this article, kinda cute.

10 0
1 239

Dynamic Entities (objects and arrays) in IRIS are incredibly useful in situations where you are having to transform JSON data into an Object Model for storage to the database, such as in REST API endpoints hosted within IRIS. This is because these dynamic objects and arrays can easily serve as a point of conversion from one data structure to the other.

Dynamic Objects

Dynamic Objects are very similar to the standard ObjectScript object model you get when you create a new instance of a class object, but with some key differences:

4 1
3 219