New post

#Caché

45

  

InterSystems Caché is a multi-model DBMS and application server. See more details here.

Documentation.

I have a routine tag that takes an argument and I want this argument to be an array reference. So I try something like:

do mytag(.myarr)

The mytag tag, adds subscripts to myarr.

When I evaluate myarr after the tag call, only the subscripts passed in are retained in myarr. The subscripts added by mytag are missing. Is there a way to pass an array so it will behave the way I want it to?

0 6
0 551

I downloaded the free version of CachePCkit_x86.exe. During installation, the antivirus detects a virus
PDM: Trojan.Win32.Generic
c: \ users \ ...... I \ temp \ pde9cb \ setup.exe
How to eliminate this problem

0 7
0 462

I need to pass a parameter string that contains slashes to a REST call.

I tried URL encoding, or making URL map to accept query parameter instead of path parameter but apparently we only allow for path parameters.

I can come with several workarounds, but these involve some transformation at client and then on server, but I'd prefer a direct support.

Q1: is there any Cache specific trick to pass slashes in path parameters

Q2: are we going to support query parameters in REST?

something like this would help:

0 18
0 45.3K
Question
· Jun 30, 2021
OnMouseOver in a TablePane

Hi Guys,

is there a Onmouseover event in TablePane?

I'm looking to show an image when the user hover with the mouse on a specific Cell in a tablepane, any Ideas?

Thanks'

0 1
0 143

Hi All,

I have to convert a binary 32-bit IEEE 754 floating point to an decimal representation.

Is there any inbuilt function available in Cache 2015.1 version to convert IEEE 754 floating point to decimal representation?

For Example:

Input:
IEEE 754 value => 0 10000111 10111000000000000000000

Output:
After Converting => 440.0

Thanks,

0 2
0 178

Hi,
I want to use Single Sign On(SSO) in SAML tokens using SOAP. I need X.509 certificate.
Where can I get that certificates from a trusted source?
Is any other way to do SSO in Intersystem Cache 2017.
Can anyone please help me on this.
Thanks.

0 2
0 627

I'm pleased to announce a major release of the InterSystems Server Manager extension. It has gained a UI!

Read more at Open Exchange.

Right now version 2.0 is like an aircraft at the start of the runway (remember those days before COVID-19?), waiting for the control tower to give final clearance. Will you be an early adopter, downloading the VSIX from GitHub, installing it into your VS Code, and posting back here to confirm that we haven't left anything critical behind at the gate? Then I'll push the throttles forward, publish to Marketplace, and we'll all be on our way.

Server Manager 2.0 is my entry for the current contest. If you like it maybe you'll vote for me it.

Open Exchange app
10 6
3 578

Hi!

Does anyone have a cleaner approach than this for looping through grouped NTE segments in order to set the segment ID in an ORM? I am aiming to avoid the NTE segments that may follow the PID segment and find the NTE's that follow the OBR segment. By using the below If statement in the While loop, I'm finding NTE's that have comments in the fourth field (PID NTE's tend not to have these in the messaging I'm seeing, I'm awaiting confirmation on this), as well as finding my newly inserted NTE segment using $FIND to locate the colon (I've concatenated some values).

0 3
0 470
Question
· Jun 11, 2021
Parsing null values in JSON

Hello everyone,

I'm creating a REST API with InterSystems Ensemble.

I already have a POST route that parses JSON content into an object defined in a class.

To parse the JSON content, I'm using the JSONStreamToObject method in the Ens.Util.JSON class

Here is how I use it:

0 1
0 1.6K
Question
· Jul 20, 2021
Zen Report page number variable

I have a report that requires a different header block for the first page and another for subsequent pages.

Is there a way to direct a header page to another header page based on what the current page number is?

0 5
0 202

When I'm asked questions about SQL, I like Intersystems staff at the WRC, generally ask about the Query Plan. My feeling is that even before you run a query you should examine the results of Show Plan to confirm that the code is going to give me the results in the manner I would expect. If I expect it to leverage an index and I see that it is not then I go back and look at what I might have done incorrectly and try to re-write the query to get the index behavior I'm looking for. To that end, there's a poll below to ask you if think moving the Show Plan button as the first button would be

0 0
0 169
Question
· Jul 13, 2021
Method return List of type

Good afternoon I am making a method of a class that I want to return a list of objects of another class that I have defined, example:

ClassMethod myMethod() As list of MyPackage.MyClass
{
}

But it gives me a syntax error, I try this and it works:

ClassMethod myMethod() As %ListOfObjects
{
}

But I would like to keep the typing.

Is there a way?

0 5
0 522

Hi all,

We're encountering a problem using CacheSQLStorage where one of the subscripts of this mapped table contains the string "||", which causes issues as Caché uses "||" as a delimiter. Is it possible to assign a different delimiter?

I'm attaching the code of the class as an example.

Class MainCore.System.MDA.msort2x2x2 Extends %Persistent [ ProcedureBlock, StorageStrategy = MainStorage ]
{

Property Subscript1 As %String;

Property Subscript2 As %String;

Property Data As %String(MAXLEN = 32000);

0 3
0 254
Announcement
· Jul 16, 2021
Looking for a consultant???

Hello fellow community members,

I would like to offer my services as an Intersystems Professional and am available to work on projects.

I have more than a decade experience into Intersystems stack of technologies including IRIS, Ensemble, Healthshare, Healthconnect, Cache Objectscript, Mumps, Zen, Analytics etc. with companies spread over US and UK involved in multiple domains.

3 0
0 249

Can the built-in $System.Encryption.TOTP() function be used in conjunction with Authenticator Apps (e.g. Google, Microsoft, and so on)?

Providing the same secret/key to a variety of authentication apps, they all return the same synchronized value. However, passing the same secret/key to $System.Encryption.TOTP() is generating a different value (with all instances executing at the same time for comparison).

0 1
0 274
Question
· Jul 13, 2021
Initialise object list

How do you initialise a list of objects of a particular type?

I have tried the following code and I get an undefined when I try to insert.

I can do this and it works but I don't know if it is correct.

Is there any way to do something like this?

Set a= New list of Accciones()

Thank you.

0 3
1 333

I have a ZEN PDF report that prints headers and footers with images correctly but when I try to embed an image into a table it does not print.

Are there examples snippets where a fully url qualified image can be embedded within the <table><item><img> tags?

0 2
0 242

HI Community,

Now Intersystems has developers definitely cut-off from Zen/CSP I am looking for sample code how to invoke server-side methods from Angular and PHP, Java client.

I only see some rest/json crud examples, but that is not the whole picture I assume.

Let's say I have a persistent Class with a class method to import or modify data...

I want to invoke this from my Angular App or PHP app.

any examples, suggestions?

0 5
0 496
Question
· Jul 11, 2021
Applying Stylesheet

Hi Guys,

I'm using the below style and everything looks good, with my Dynamic Grid width 1300px, but when I refresh my grid the width goes out of whack and the grid is too wide, so how can I re-call my enforce my style to be applied again after refreshing my grid, so basically I'm looking for a line of code that I add it to my refreshing () clientMethod ?

XData Style
{
<style type="text/css">
body {
padding: 5px;
margin: 0px;
height: 100%;
background-image : url(images/bkground.gif);
}

0 1
0 161