Hi All,

In earlier cache version, I can see full data values in SQL management portal.

But IRIS restricted the view only to 100 chars.

"If the data in a field is longer than 100 characters, the first 100 characters of the data are displayed followed by an ellipsis (...) indicating additional data." - From Documentation.

Is there a way to change this behavior ? I would like to see all the values in the particular SQL field.

Thanks in advance,

Archunan K

I am trying to call to a website that renders a xml structure as a response.if I put the url on the browser an xml rendered page is returned but if i call to this using the below code I get an object reference error which I am finding had to understand is there anyone who could help understand this error or point me in the right direction thanks.

Set tSC=$$$OK

Hi All,

Can you help me how to extract SQL table data into a text file and generate the text file in a particular file path

Thanks,

Smythee

So I am working with an inherited SQL query that queries 8 different tables. 5 of which have over a million records.
I have 3 different servers.

Server 1, Server 2 and Server 3. They all have the same data/tables/structure across all servers.
Server 3 has an Iris database engine and the other 2 are Cache 2015.1.4.

I have a problem with views and performance across the servers being inconsistent.

Thankfully Server 1 is the current live server that performs "fast enough".
Server 2 is being synced from Server 1 and acts as a report server.

I would like to control multiple 'services' in Ensemble.

I would like the ability to switch them off and on.

My plan is to achieve this in a Cache class using ObjectScript.

Is this possible?

Any tips, starting points would be gratefully received.

Many thanks.,

Hi

I have a Zen toolbar which I want to share across many pages as common feature - I know it can be populated with a javascript clientmethod that returns a JSON on each page as per this example - https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY...

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

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

.....

Hello everyone!
I need to transform a String, which is a numerical value, to an Integer.
The value gets returned in my Rest service as "testingID": "1234567", but I need it to be "testingID": 1234567

Thanks beforehand! Appreciate all the help I can get! :)

Does the GetValueAt method of an EnsLib.HL7.message object change the contents of the HL7 message?

We want to do two things, given an incoming HL7 message, in our production:

I need to convert dd/mm/yyyy --> yyyymmdd

example

Input = 25/03/1988

expected Output = 19880325

The documentation https://docs.intersystems.com/ens201817/csp/docbook/DocBook.UI.Page.cls?... says "You can also obtain this routine [%fm2class] as an XML file and install it in Caché or Ensemble version 5.0.* or higher."

How do I get that XML file?

If it's already part of Cache 18.1, you could also just tell me how to access it.

Thanks!

Until what version of HTML and CSS can I use on zen pages?

This is my delphi code

procedure TForm2.Button1Click(Sender: TObject);
var
cmd:string;
sResult:string;
begin
cmd:='$$Check^logininput()';
vism1.Code:=cmd;
sResult:=vism1.Value;
end;

end.

I need to show the absence of data, so I have to join the list of predefined values with a result of a select statement.
However, it seems like Table Value Constructors in JOIN are either not supported, or I do not understand the syntax.
Basically, I am going for something like this:

Select v.valueId, m.name 
 From (values (1), (2), (3), (4), (5)) v(valueId)
     left Join otherTable m
        on m.id = v.valueId

Is it supported in Cache SQL or not?