#Caché

Hi,

How to write code in table trigger to send SMS upon any modification on particular column?

Thanks
 

Hi all,
    We have a session values in a cache method and need to get those values in a client method (JavaScript).
   
Eg : 
    ClassMethod Method1()
{
    Set %session.Data("Param1")="Data 1"
}

ClientMethod onloadHandler [Language = javascript]
{
   var ret = zenPage.getSessionValues();
}

ClassMethod getSessionValues() As %String [zenMethod]
{
   Set Data = $G(%session.Data("Param1"))
   Quit Data
}

This is the code we implemented. But the problem is getSessionValues() method isn't called.
We need to know how to call a class method from client method.

Thanks,
Syed M

Hello, first of all thanks for your time reading this question ◀️

We would need to achieve the following task:

We have a Ens.Response message with this structure:

<?xml version="1.0" ?>
<!-- type: Mensajes.Response.Justicia.PLATINO.EnviarIniciadoresGeneralResponse  id: 10986665 -->
<EnviarIniciadoresGeneralResponse>
    <EnviarIniciadoresGeneralOut>
        <![CDATA[<?xml version="1.0" encoding="ISO-8859-1"?>
<mensajeWS xmlns="https://wslexnet.webservices.lexnet/3.22"><respuestaEnvioMensaje

Hi All,

I am new beginner to cache/mumps language. I want to learn Ensemble code but I do not have any application access to Ensemble code.

Is there documentation apart from Intersystems Ensemble documentation that can help me to learn Ensemble. Any notes or documents will be very handful

Please assist!! Thanks in advance.

How strange this is to me.  I'm querying a table against a numeric(15,2) column call max_client_resp_service.  When I query max_client_resp_service > 0 or any number, I get results, but they are not always right, for example where max_client_resp_service > 5 returns values less than 5, e.g. 2.00.  When I query < 110 of any higher number I get zero results.  It's as though the comparison operator, especially less than function is not working.  See attachments for screen shots.  I'm stumped.  Ok looking at this further, it appears ">" returns all records, "<" returns no results.

Does Caché or IRIS have Data Masking capability natively to Test/Dev/Report environment, like other databases?

Hi community,

I'm going to publish several articles on how to perform actions that you can do in the web portal but via code.

Today.... Web Applications via code

Is there a shorter way than

$P($ZD($H),"/",3)

?

Is there a way to get a report of how many messages are passing through a production? I am trying to gauge how many messages we process weekly, monthly, and yearly. Also, over specific months.

Would appreciate if someone can guide me on this

We use Cache for Windows 2017.1.3

any persistan class can be used as msg body, if i use one of my persistent class(ex sample.person) as msg in the ensemble then perform purge  management where inculde msg bodies .. will we loose the sample.person data?

Is there somewhere  a dialect  class for Cache 2018.1  with  Hibernate  version 5.x ?

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?

If I export a class definition to an XML file, is there a way to programmatically import it so that I could schedule a task to look in a given location for XML files once a day and import class definitions?

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

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: 

<Route Url="/test?var=:var" Method="GET" Call="Test" Cors="true"/>

 Dan Kutac

Is there a ZEN control that allows rich text entry that can be used to print PDF reports

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'

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,

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.

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.

Hi,

What is the difference of class normal and date/time property and how to use in the script and what is the use of MINVAL and MAXVAL parameters?

Thanks

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).

Although this code is

I'm writing a ZEN PDF report that uses StyleCalls to modify/HiLight table cells.

Is it possible to use a ZenMethod to create the Xdata below? I need to modify the colors based on flags.

XData XslFoXslt
{
<xsl:template name="HighLight">
<xsl:param name="Value"/>
<xsl:if test="$Value = 0">
<xsl:attribute name='font-weight'>normal</xsl:attribute>
<xsl:attribute name='background-color'>#ffffff</xsl:attribute>
</xsl:if>
<xsl:if test="$Value = 1">
<xsl:attribute name='font-weight'>normal</xsl:attribute>
<xsl:attribute name='background-color'>#dfdfdf</xsl:attribute>
</xsl:if>
<xsl:if test="$Value = 2">
<xsl:attr

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:

Set tSC = ..JSONStreamToObject(%request.Content, .tObject, "MyClass", 1)

While the route works and does what it should, in theory.

I noticed that when passing empty string or null values inside the JSON content, the values do not appear at all in the object's instance.

Therefore, there is not difference between a null value and an

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?

I work on an ERP system and am trying to set up a dashboard according to a customer request. It's a pivot table with a few controls and filters, nothing too difficult, but I'm having some issues with drill down.

We've got item sales data.Quantity sold, sales dollars, cost, gross profit as both dollars and a percentage.It's starting out with one row per item.From there, we can drill down to see which salesmen have sold that item and get all of those numbers for each salesman.

 the start date must always
be the first day of the effective salary month.
 

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.

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?

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);

Property ZREF As %String [ Calculated, SqlComputeCode = { S {*} =