#Caché

40

  

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

Documentation.

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.7K
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 221

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 178
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 582

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 266

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 264

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 289
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 365

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 259

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 529
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 170

So, one day you're working away at WidgetsDirect, the leading supplier of widget and widget accessories, when your boss asks you to develop the new customer facing portal to allow the client base to access the next generation of Widgets..... and he wants you to use Angular 1.x to read into the department's Caché server.

There's only one problem: You've never used Angular, and don't know how to make it talk to Caché.

This guide is going to walk through the process of setting up a full Angular stack which communicates with a Caché backend using JSON over REST.

19 11
5 6.9K

Is there a method I can utilise to check if a particular method has been called and perhaps log the args it was called with?

We are currently trying to expand out Cache Unit Testing processes and were wondering if there is an existing method that would capture this or how such a method could be structured.

Thanks
Adam

0 2
0 223

Hi all,

Over the next few months I'm going to be setting up continuous integration via Jenkins for some Angular UI's. The goal is to, on each build:

1. build the code

2. run the unit tests and get a report

3. get a code coverage report

Just wanted to poll the community in case someone else has already worked with any of this before. All ideas are appreciated.

Cheers,

Johnny

1 7
0 476
Question
· Jul 1, 2021
ifexpression syntax

What is the correct syntax when passing values on a zen method after ifexpression?

<pagebreak ifexpression="%report.PageBefore('Graph',1)=1"></pagebreak> ????

.....

0 1
0 206

I have a client that no longer wants to use sftp to transmit their data file to me. Instead they want me to pick it up via a web service.

Email from client:

Here is the postman collection and mocking service to start your development. The API has only one URI parameter {id} for which you need to pass UniqueIdentifier(will let you know exact value later).

0 7
0 587

I want to add time slot and category metadata to complete my cinema application.

I am following the documentation of the cinema application "https://docs.intersystems.com/latest/csp/docbook/Doc.View.cls?KEY=TWEB2_..." and in that,

I was trying to add theater and time slot. But I was not able to do that.

I was also trying to filter the records as per the ratings and category selection on the search bar. but this is showing some error.

0 2
0 226
Article
· May 16, 2017 3m read
The COS Faker

Hi Community,

This post is to introduce one of my first project in COS, I created when started to learn the language and until today I'm keeping improve it.

The CosFaker(here on Github) is a pure COS library for generating fake data.

cosFaker vs Populate Utils

So why use cosFaker if caché has the populate data utility?

10 8
2 1K
Question
· Jul 2, 2021
Use of $ZUTIL(12)

As you know the $ZUTIL method is deprecated and I'd like to replace this calls for the corresponding ones.

In my case I'm looking to replase $ZUTIL(12) by ##class(%Library.File).NormalizeDirectory("")

0 2
0 392