Caché | InterSystems Developer Community

Question

Drew Holloway · Feb 28, 2020

How to transform date range into multiple rows in Intersystems Cache?

Let's say I start with a date range of '1-5-2019' to '5-25-2019' that occurs on one row. I'd like to ultimately have this show as 5 rows in Crystal Reports as shown below

Result

1-5-2019 1-31-2019

2-1-2019 2-28-2019

3-1-2019 3-31-2019

4-1-2019 4-30-2019

5-1-2019 5-25-2019

I found a result that worked in T-SQL, but I'm not sure how to translate it to Cache SQL. The T-SQL code is

#SQL #Caché

1 3

0 385

Question

Drew Holloway · Feb 28, 2020

How to get a Numbers View

In T-SQL, I can create a recursive CTE to create a subquery or a view that will hold a whole lot of numbers. Is there a way to do this in Cache SQL? I'd like the numbers from 0 to 10000 if possible.

Thanks!

#SQL #Caché

0 3

0 334

Question

Ali Chaib · Feb 28, 2020

Create a list of messages in studio

Do you have any clue how to create a list of messages in studio ?

Example :

I can define one message that is called DoctorInfoMsg such as

set DoctorInfoMsg= ##class(PKGNotification.InDoctorInfo).%New()

#Studio #Caché

0 6

0 259

Announcement

alex kosinets · Feb 8, 2020

M is in the cell

Ladies and gentlemen, good news for our town.

It finally happened - M was put in the cell.

#ObjectScript #Tools #Caché #InterSystems IRIS

3 19

1 1.6K

Article

alex kosinets · Feb 29, 2020 4m read

Multiple reports in one request MX

There is a special Query for reporting, it takes one cell of Excel. Example :

#ObjectScript #Caché #InterSystems IRIS

0 0

0 246

Article

Robbie Luman · Feb 28, 2020 3m read

Using a Static C Library with the C Callout Gateway in Intersystems IRIS

Our company is in the process of converting our software for use in Intersystems IRIS and one of the major sections of the software makes use of a custom statically-linked C library using the $ZF("function-name") functionality. During this, I found out that the process for setting up the C library to be used within the database platform has changed significantly between Cache and IRIS.

#Callout #ObjectScript #Caché #InterSystems IRIS

5 0

0 344

Question

Paul Dawson · Feb 24, 2020

%GetComponentByID Compile Error

Hello,

I have a class I'm working on that is extending a base class that contains the %GetComponentByID method and a section of the new code I'm writing uses %GetComponentByID but when I attempt to compile the class I'm getting an error that says the method doesn't exist.

Am I missing something to be able to include the GetComponent method in an extended class?

#Caché #HealthShare

0 7

0 266

Question

Đặng Phú Lộc · Dec 30, 2019

%SQL.StatementResult vs %Library.ResultSet

Can anyone clarify to me about the differences between these two classes?

People in this topic https://community.intersystems.com/post/using-class-queries-sqlstatement-versus-libraryresultset stated that %SQL.Statement (I am assuming they mean to talk about %SQL.StatementResult) is newer than %Library.ResultSet. But I don't really know what are the advantages of %SQL.Statement over %Library.ResultSet as the people in the topic somehow didn't mention them.

#Caché #InterSystems IRIS

0 6

0 1.3K

Question

Akshat Vora · Jan 23, 2020

QUIT argument not allowed

   try{
        ....
        ....
        ....

        Set tSC = method_invocation()

        If $$$ISERR(tSC) {
            Quit tSC
        }

        ....
        ....
        ....

}

On compiling the above, I get an error saying "QUIT argument not allowed : 'tSC' ".

#Debugging #ObjectScript #Caché #InterSystems IRIS

1 9

0 1.1K

Question

Amnon Magen · Feb 25, 2020

CSP - using cspbind dynamically

#CSP #Caché

0 3

0 381

Question

Yone Moreno · Feb 6, 2020

How could we add InclusiveNamespaces tag inside Signature, when we sign a message?‽‽

Hello,

We have the following code:

#ObjectScript #Caché

0 1

1 411

Question

Anthony Rosania · Feb 23, 2020

$list returning symbols along with results...

First,

Forgive me if this is a rather low-level question - I am a physician informaticist who is learning cache/mumps for the first time. I am sure this probably relates to some setting but I can't find a similar issue anywhere.

When I create a list, and then try and return that list - I get a bunch of symbols back along with my results, or sometimes I just get symbols.

I pasted a screenshot below. Thank is advance for the help!

Anthony

#ObjectScript #Terminal #Caché

0 6

0 286

Announcement

Andreas Dieckow · Jun 28, 2019

InterSystems IRIS Adoption - Invitation

Conversion Sequence step 4 (see table below)

#Caché #Ensemble #InterSystems IRIS

5 10

1 1.3K

Article

Mathew Lambert · Feb 21, 2020 1m read

Terminal connection from vs code to local instance (one way)

I was searching for the most simple way to connect from visual studio code to my local instance via terminal without having to change any window.

I know this can also be achieved via telnet but seems a bit overhead if you're in your local machine.

For me the simplest sollution is to open a terminal window in VS Code, navigate to the /bin folder of your instance installation and run .\csession.exe INSTANCENAME

For simplicity you can just include your /bin folder in your path so you don't even need to navigate there

#Development Environment #Terminal #VSCode #Caché #HealthShare #InterSystems IRIS #InterSystems IRIS for Health

1 1

1 1.3K

Article

Mikhail Khomenko · Aug 16, 2017 20m read

Grafana-based GUI for mgstat, a system monitoring tool for InterSystems Caché, Ensemble or HealthShare

Hello! This article continues the article "Making Prometheus Monitoring for InterSystems Caché". We will take a look at one way of visualizing the results of the work of the ^mgstat tool.

#Best Practices #System Administration #Monitoring #Visualization #Caché

14 10

4 3.2K

Question

Michael Davidovich · Apr 1, 2019

Use Cache to Write Excel Files

Currently, when we want to write data to a file that will be viewed in Excel, we parse the data in tab deliminated format to the file and name it with .xls at the end. That is sent to end users via email. They get a warning that the data is not formatted properly (it's not really an Excel file after all) but it does display somewhat correctly as the tabs are understood (this does not work if we deliminated with commas however).

#Beginner #Caché

3 28

3 4.1K

Question

Neil O'Connor · Feb 20, 2020

How to escape the less than symbol < when sending a string to a recordmap

Hi,

I am using a record map and when the less than symbol < is sent the record mapping fails. How can I escape this character so the record map will not fail.

#Caché #Ensemble

0 1

0 258

Question

darko susnjara · Feb 20, 2020

How to use SQL „LIKE“ on a GlobalStream where the Attribute Datatype is a LONGVARCHAR

Hi all,

i‘m traying to run a sql LIKE Query on an attribute datatype LONGVARCHAR.

I also try allready with the SUBSTRING(Attribute,1,...), when i run the query, the resultat is empty without errors.

The Query:

select text from table

where text like ‘%abc%‘

many thx for help

Darko

#SQL #Caché

0 2

0 457

Question

Hao Ma · Jan 4, 2020

How to quit ^%SYSMONMGR in some case?

With ^%SYSMONMGR, there are some brunches that I never found a way to quit out, like shows as the following example: do ^%SYSMONMGR --> Manage Health Monitor --> View Alert Records ...

Does anyone know the answer? thank you very much.

%SYS>do ^%SYSMONMGR
1) Start/Stop System Monitor
2) Set System Monitor Options
3) Configure System Monitor Classes
4) View System Monitor State
5) Manage Application Monitor
6) Manage Health Monitor
7) View System Data
8) Exit

Option? 6

#Caché

0 6

0 327

Question

Orlando Lagman · Jan 16, 2020

debugging web client

I used the soap wizard to create a web client based on the wsdl. I was able to get a valid response back, and now it looks like the error is in decrypting the soap message response "inbound"

ERROR #6284: Security header error: SecurityTokenUnavailable.

#Security #SOAP #Caché

0 1

0 565

Question

Suman Samanta · Feb 12, 2020

Cache JDBC get row id of the table while inserting the data

HI I am using below code to retrieve the last inserted ID of the table. It works when we do not set any custom column as IDKey. If we define any column as

IDKey below code does not return any IDKey. I know when i am defining any column as IDKey its not auto generated , but whats the best way to get the ID column value

#JDBC #SQL #Caché

0 1

0 752

Question

Jonathan Ebbers · Feb 18, 2020

SQL: ability to choose a specific index

I'm using Cache SQL and want the ability to choose a specific index.

I've boiled the problem down to one table and simplified the query down to

SELECT *
FROM Registration.PatResp
WHERE SchedApptNum=8450022

SchedApptNum is indexed, but instead of using that column, "Show Plan" indicates that it's looping through the entire Registration.PatResp table on Id (the primary key for the table).

I've done a tune-table with no change.

#Indexing #SQL #Caché

0 6

0 1.2K

Question

Patrik Spisak · Feb 14, 2020

%XML.Reader

Hi guys,

I need help because I have no idea how to proceed further and documentation does not explaining this solution.

I have XML like this:

<?xml version="1.0"?>

#XML #Caché

0 9

0 856

Question

Mathieu Van Sevenant · Feb 6, 2020

Size Limitation for %ToJSON() with large stream

Hello everyone

Here is a try of sending a stream object with %ToJSON() by HTTP POST request on a remote server.

First the JSON structure:

#JSON #Caché

0 7

2 1.4K

Question

Paul Rick · Feb 14, 2020

Hidden change of $UserName

This is more a WARNING than a question

#Authentication #Security #Access control #Caché #InterSystems IRIS

1 2

1 489

Question

Yone Moreno · Feb 12, 2020

Convert String to JSON

Hello,

We would like to convert a string which represents a dynamic JSON object, to a JSON.

We have:

#JSON #Caché

0 2

0 1.8K

Article

Evgeny Shvarov · Oct 18, 2018 3m read

How to Publish an Application on InterSystems Open Exchange?

Hi Community!

As you know we launched the InterSystems Open Exchange — the marketplace for solutions and tools on InterSystems Data Platforms!

But how to publish your application on OE?

Before we start, let me answer the few basic questions.

#Caché #Ensemble #InterSystems IRIS #Open Exchange

4 11

1 745

Question

Yone Moreno · Feb 13, 2020

How could we store a list into a global variable?

Hello,

We would like to store a list into a global. The need is to get the full Web Service's Response Message, because of currently, our Operation sends the message to the Process, whith an empty list:

We have created a copyList which is a clone of the list which is being returned from the web service client:

#Globals #ObjectScript #Caché

0 2

0 269

Question

Javier Sanchis · Feb 13, 2020

Cache Unit Test with jenkins

Hi, everybody,

I've been reading some posts in the community but I haven't been able to come to a conclusion. Here's my point.

I have a cache code, and following this guide https://cedocs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?K... but I can't understand how to run this from jenkins for example, without using the console, and thus automate the process. That is to say, if it were possible to do it, what steps should I follow.

Thank you very much

#Continuous Integration #Caché

1 2

0 1.1K

Question

Mathew Lambert · Feb 12, 2020

Get all collation number and names

I've recently encountered a HS Caché that won't start informing that Collation 30 is not available, but I have not found an easy way of knowing what collation is 30.

I've found that the following command returns the ones from the current locale, but not from all locales:

Set Rset = ##class(%ResultSet).%New("%Library.Collate:CollationList")

d Rset.Execute()

While (Rset.Next()) {zw Rset.Number_": "_Rset.Name}

Thank you

#Localization #Caché #HealthShare #InterSystems IRIS

0 2

1 380