Syndicate content 0  
 
All time

Hi Community,

I am attempting to create a new table by executing a SELECT statement that involves joining multiple tables. However, I encountered an error during execution: '( expected, AS found^Combined AS.' I would also like to create a cube based on this SQL table. However, during the cube creation process, I am prompted to specify a source class, and I'm unsure which class to use as it requires an existing class. Could you please help me identify the issue with the table creation, and provide guidance on selecting the appropriate source class for the cube creation?"

0 1
0 214

An interim idea to bring more dark to the docs with different font.

Process:

  • In Firefox web browser address bar navigate to: "about:support"
  • Look for label "Profile Folder", and click on the corresponding "Open Folder" button.
  • Drill-down / Open sub-folder called Chrome.
  • Create file here called: userContent.css

Content of file:

2 0
0 215
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 213

I have been developing this project for many years. He helps me a lot in my daily work as a DBA and full stack developer.
This project has grown into a platform on which many of my other projects are based.
You can read more about the project in the article.
And I proposed this project for the contest, maybe it will be useful to you.

Open Exchange app
1 0
0 215

Hello Everyone,

In October 2021 we asked for input from the IRIS community regarding exam topics for our InterSystems IRIS System Administration exam. We will close the window for providing feedback on the exam topics on Wednesday, January 12, 2022. Thus, if you would like to have your say in what topics are covered on the exam, this is your last chance!

0 0
0 215

For me the best moments were:

1 - Global Masters WON the 2021 Influitive BAMMIE Award for Most Passionate Community

2 - Tech Article contests

3 - InterSystems Programming Contests

4 - 10,000+ DC members

5 - Partner directory and business services

6 - 500+ applications on OEX

7 - Open Virtual Summits

8 - Prizes from GM points

9 - Free online learning courses

10 - Discord channels

11 - Innovations from IRIS Data Platform

12 - Multilanguage communities, including portuguese, spanish and chinese community

5 4
0 211

Hi, Community!

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

Most viewed

Atelier 1.2 Stable Release 230

InterSystems IRIS Data Platform 2018.1.1 Release 199

"IF THEN - $SELECT - $CASE" - What is the best way? 179

$CASE For Long Stories 148

Translate a number to text 147

Sort ordering 141

Extending method keywords 138

Stop Storing Atelier Credentials 133

COMANDO $ZF 130

Multi Language Sort 125

Most voted

Atelier 1.2 Stable Release 7

Translate a number to text 7

InterSystems IRIS Data Platform 2018.1.1 Release 6

Multi Language Sort 5

InterSystems on DeveloperWeek NYC, June 18-20 5

Atelier at EclipseCon France 2018 4

Installation Manifest - I can disabled the journal globals by the XML? 3

Creating SSL-Enabled Mirror on InterSystems IRIS Using Public Key Infrastructure (PKI) 3

One simple Docker trick to halve your image build time 2

DC June 2018 Release 2

Most commented

Communication link failure trying to access Studio 15

$CASE For Long Stories 14

How to convert page number to roman numeral in ZEN Report? 14

Extending method keywords 13

How to navigate to parent of Serial Object? 12

Kill process started by JOB 11

Custom file pass through Operation writing out unreadable pdf files 11

Has anyone tried REST API Put Or Post on AWS S3 ? 10

%ProcessError+6 ^%Net.Remote.Proxy.1 error occurs inconsistently 10

How to Update Caché User Full Name field via SQL? 9

Top 10 Authors to Follow by Views

Francisco López, Posts, 147

Eduard Lebedyuk, Posts, 73

Daniel Kutac, Posts, 45

Pete Greskoff, Posts, 34

Top 10 Experts to Follow

Nicole Aaron, Answers, +11

Robert Cemper, Answers, +10

Eduard Lebedyuk, Answers, +9

Vitaliy Serdtsev, Answers, +7

Benjamin Spead, Answers, +4

Francisco López, Answers, +4

Evgeny Shvarov, Answers, +3

Dmitry Maslennikov, Answers, +3

Gilberto Junior, Answers, +3

Timothy Leavitt, Answers, +2

0 0
0 215

Using Flask, REST API, and IAM with InterSystems IRIS

Part 1 - REST API

Hello

In this article we will see the implementation of a REST API to perform the maintenance of a CRUD, using Flask and IAM.

In this first part of the article we will see the construction and publication of the REST API in Iris.

First, let's create our persistent class to store the data. To do this, we go to Iris and create our class:

3 0
0 214

I have installed three plugins on VS Code: Intersystems Language Server: v2.3.6, Intersystems ObjectScript: v2.10.5, and Intersystems Server Manager: v3.6.2. I connected to the Caché database and connected a workspace to the InterSystems server. Then I edited the code locally on my client machine.

0 6
0 208

If both fields are numeric and the result of subtraction of field1-field2 is positive, only then put the result is a data field.

I am doing this within an Iris DTL.

I don't find any functions like IsNumeric(). Once I get that, I can test if field1>0 and field2>0, do the subtraction, and test if diff>0.

I just need a function to determine if they are numeric, rather than some cumbersome way like a regex where the only characters are 0-9.

I see functions in documentation but don't see them used at tests, only in WRITE statements.

Thanks,

0 10
0 204

Hi Community,

Let's meet at the online meetup with the winners of the Developer Tools Contest. It's a great opportunity to chat with the InterSystems Experts team and our contestants.

Winners' demo included!

Date & Time: Monday, October 7, 10:00 am EDT | 4:00 pm CEST

https://www.youtube.com/embed/dM06RvMaT-k?si=hkTP2pQU7TDnHg-2
[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]

0 2
0 174
Question
· Jul 25, 2024
Read an XML response

I receive response from Business Operation(HTTP GET) as below :

<response>
<message_code>202</message_code>
<message_string>Success/message_string>
</response>

I am not able to read the "message_code" as response.message_code ?
is it because of underscore ?
Is there a way to read it ?

0 4
0 210

Looking to get started with generative AI? Try two brand-new learning paths. In Getting Started with Generative AI (2h 45m), learn the basics of interacting with GenAI. Then, try Developing Generative AI Applications (2h) to start developing your own GenAI application. Plus, earn badges for completing each path!

4 0
0 214

The 2023.1.3 extended maintenance releases of InterSystems IRIS, InterSystems IRIS for Health, and HealthShare Health Connect is now available. It provides bug fixes for any of the previous 2023.1.x releases.

You can find the detailed change lists / upgrade checklists on these pages:

1 0
0 214
Question
· Dec 27, 2023
Code Quality Checks: Javascript

Is it possible to get a code quality stamp of approval on the Open Exchange with an application written in Javascript?

My Iris Whiz application is a browser extension written in Javascript and I wonder if having the code quality stamp missing from my application page will put people off from using it.

0 2
0 212

We recently published a new White Paper on the use of reporting nodes ("asynchronous reporting mirror members" in full) in a mirrored environment. More and more customers are looking into this mechanism as a quick and easy way to set up a copy of their production data that stays current, yet can be used for analytical querying or heavy-duty reporting workloads without impacting the source system. Read the White Paper here.

1 0
1 214

When requesting /MDX2JSON/PivotVariables/Patients?Namespace Patients shoud be passed to a method but its not. When argument passed directly into the method it works.

<Route Url="/PivotVariables/:Cube" Method="GET" Call="WritePivotVariablesForCube"/>

Has something changed in IRIS and this syntax is deprecated, or is there a bug and the colon is ignored? What could it be?

This question is continuation from https://community.intersystems.com/node/534811

0 1
0 213

In our latest episode of Data Points, I had a conversation with @Thomas Dyar about AI Link, which helps bridge the gap between data scientists and business analysts. Our conversation talks about how AI Link fits with IntegratedML and Adaptive Analytics, as well, as what new features are on the horizon for IntegratedML. Take a listen!

https://5e18edf067eb59-03854285.castos.com/player/1346398
[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]

3 0
0 214

In a data transformation, when creating a "set" action, I have a value that looks like this:

..If(..NotIn(source.Records.(k1).Property4,"Learn & Dev Supervisor,Director of Learn & Dev, Clinical Trainer Lead, Learning and Development Specialist Lead"),"TL","3")

Is there a way to target keywords such as "Trainer", or "Learning" so I don't have to keep adding specific job titles?

Similar to a LIKE statement in SQL, if that makes sense.

0 2
0 212