All time

Hello community, I need to solve a complex but trivial issue.

Given:

Two tables "Comment" and "Post". Each one contains an "Author" field, which is essentially a user ID. In these tables, each user ID represents an author. The goal is to count all participants together and then group them by month, language, and other metrics.

The question is how to do this within the IRIS ecosystem. Is it even possible to take two tables, get distinct data from them and then combine into one cube?

0 1
0 197
InterSystems Developer Community is a community of 24,420 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!
Learn more

Hi there,

I want to use regex in my code, and I saw that the %Regex.Matcher class contains a property "OperationLimit" that you can also set to a number of steps that the regex engine should take maximum in analysing a given string. So far so good.

I tried to set the property with the function OperationLimitSet() to a silly value like 3. In 3 steps only very few regex should be executed, right? But what I found is that my regex always comes up with a solution. Here is what I did:

First I initialised my %Regex.Matcher.

0 1
0 197
Question
· Jun 15, 2023
Get a list of available printers

Hi guys,

How can I get the list of printer in client Zen page?

We currently use an ActivexObject call "MSDesign.WebLabel" to get the list of printer loaded in a dropdown in our Zen pages:

webControl = new ActiveXObject("MSDesign.WebLabel");
if (webControl!=null) printers = webControl.getPrinters();
and this will give us a list of printers available in client machine but this does work in Edge or Chrome, is there a tool or simple code that I can use to get me the list of printers available?

Thanks

0 2
0 196
Question
· Oct 27, 2021
Including datetext in a table pane

Hi Guys,

is there a way to include a datetext in a tablepane cell maybe using OnDrawCell?

I've tried :

&html<<input type ="date" id="serialno" style=" width: 80%;" />>

0 4
0 194

Hi,

we have a EnsLib.Workflow.TaskRequest wich is been send to an operation. The Task request contains a simple object, for that we´ve extendd EnsLib.Workflow.TaskRequest and added the object as an aditional property. The request is successfully created. But how to access the contents of this object from within the user portal when showing the task.

0 2
0 196

4 0
0 198

Hi Community!

This is a digest of the Developer Community postings in November 2018.

Most viewed

New release cadence for InterSystems IRIS 302

Abnormal programming with InterSystems 217

Language features that you really should know from day 1 215

What is best approach to parsing CSV string to tab-delimited string? 207

How do You Convert 8-bit Database to Unicode? 141

InterSystems IRIS 2018.2 available in preview 139

How to get running operating system 122

ObjectScript: Looping over a multidimensional global value and comparing 119

Syntax highlighting for ObjectScript 119

Detection of last update timestamp of each class row (DSTIME ?) 117

Data Verifier for InterSystems Data Platforms 104

Uploading and downloading files via http 99

Fetch Message Header Data 62

Utility to compare class and include file definitions between builds 55

0 0
0 198
Article
· Apr 1 1m read
How to get server/instance info

Hi all,

As part of the development an API to know what is the instance of IRIS is connected, I've found some methods to know information about the server that can help you.

Get the server name: $SYSTEM.INetInfo.LocalHostName()

Get the server IP: $SYSTEM.INetInfo.HostNameToAddr($SYSTEM.INetInfo.LocalHostName())

Get the instance name: $PIECE($SYSTEM,":",2)

2 2
0 157

Hey everyone, I am implementing version control with git-source-control on our codebase and I ran into a pretty strange issue. I believe I have the set up (mostly) correct as the behavior with .cls files is exactly as expected. However, I noticed that git is not keeping track of any changes to CSP files.

Specifically, if a new CSP file is created and saved, I will get the following output:

exporting new version of /csp/testdb/wrc.csp to C:\InterSystems\IRIS\mgr\repo\TESTDB\csp\testdb\wrc.csp

1 8
1 189

I'm trying to call a SOAP web service which is implemented in .NET Classic and requires NTLM authentication. The client class was generated by %SOAP.WSDL.Reader. The problem is that neither NTLM authentication works nor can I handle the exception since VSCode debugger says that all meaningful fields and properties are empty (the same request works fine in Postman):

0 4
0 193

Hi all.

I hope you can help me.

I've renamed a namespace and its databases names.

  • Old Namespace: LABORATORIO
  • New namespace: SRV-LABORATORIO

The rename of all has worked fine. When I've tried to access to the portal, it is no available, displaying the message "Tha namespace SRV-LABORATORIO does not support productions"

So, I've run the following command in terminal

1 2
0 195
Question
· Sep 25, 2024
LDAP Authentication Question

I am trying to track down a problem we saw this morning with our TEST environment. We had a momentary issue where InterSystems HealthShare Health Connect could not connect correctly to LDAP. When we tried to login and could not connect to LDAP, the system would Delete our users.

the Test LDAP function would return a "Can't contact LDAP server". I went through the Certificates, made sure they had the correct permissions and were not expired.

0 2
0 195

We need to generate a PDF file from an HL7 message as it passes through an Ensemble production. Looking for examples, tutorials, documentation aligned to our scenario.

We are currently using Ensemble (so can't use InterSystems Reports at the moment). Thinking Zen reports...

We can get from HL7 to XML OK, following Introduction to InterSystems Health Connect - YouTube (see c.1:11:00-1:13:00)

1 2
0 195
Question
· May 2, 2024
help with HL7 Transformation

Hi,

I'm new to IS and the HL7 transformations using the DTL. I need some clarification on the foreach action.

I want to iterate over IN1 segments, and output only segments that contain certain allergy types in IN1-2 with foreach. Inside the foreach block, I check for allergy type "FA" in IN1-2 and, if found, send the segment with only the required fields (fields #1, #2, #3, and #5 to be exact). Please see the foreach block below:

0 3
0 194

Hi Developers,

Tap to watch the brand new video on InterSystems Developers YouTube:

⏯ Using InterSystems Reports for Insight @ Global Summit 2023

https://www.youtube.com/embed/iacGlGwEa5s
[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]

2 0
0 197

The VS Code extension for Deltanji source control has been updated to version 1.2.3. View the change log here for a full list of updates: https://bit.ly/3PqMJ26

Users can now benefit from the VS Code Quick Diff feature when using the ObjectScript extension. To use this feature just click on the gutter decorations to reveal an inline diff experience, where you can contribute contextual commands. You just need to provide VS Code with the original contes of any given file.

2 0
0 197
Question
· Sep 28, 2022
Flush on CSP-page

CSP Page prosessing;

Is there a way to flush temporary cache data to csp page while server is still prosessing the end of page ?

So, the whole page is a LOOP which gathers the data. It seems to reveal the output only after when whole thing has finished. Is it possible to flush data to screen on every loop ?

0 2
0 195