Hi Community!

Please welcome a new session recording from Global Summit 2017:

We Want More! - Solving Scalability

I am working on a TrakCare JIRA issue that requires accessing class properties in a different installation of TrakCare on another machine. For instance, I need to compare the deprecated items in the current version of TrakCare to the deprecated items in a previous release. Is there anything in the built in classes that will allow me to do this, or  is it something I'll need to do with a SQL stored procedure or something else I haven't thought of?

Hi,

I was wondering if there is any information about the events I can use when using a business service. I am using "OnProcessInput" event to define the logic of my script but I would need to run a different script when finished. I guess it would be easier to understand if I provide more information. My business service just calls a store procedure to receive messages from a database. Once there are no messages received I need to run a different query but I cannot find any option to determine when the last message has been received.

I found OnClose and OnTearDown events...but those are more

Can anybody give me a correct example to kill process started by JOB command?

Hi, Community!

This post is a digest of the Developer Community postings in June 2018.

Most viewed

Atelier 1.2 Stable Release  230

InterSystems IRIS Data Platform 2018.1.1 Release  199

"IF THEN - $SELECT - $CASE" - What is the best way?  179

$CASE For Long Stories  148

Translate a number to text  147

Sort ordering  141

Extending method keywords  138

Stop Storing Atelier Credentials  133

COMANDO $ZF  130

Multi Language Sort  125

Most voted

Atelier 1.2 Stable Release  7

Translate a number to text  7

InterSystems IRIS Data Platform 2018.1.1 Release  6

Multi Language Sort  5

InterSystems on DeveloperWeek NYC, June 18-20  5

Atelier at EclipseCon France 2018  4

Installation Manifest - I can disabled the journal globals by the XML?  3

Creating SSL-Enabled Mirror on InterSystems IRIS Using Public Key Infrastructure (PKI)  3

One simple Docker trick to halve your image build time  2

DC June 2018 Release  2

Most commented

Communication link failure trying to access Studio  15

$CASE For Long Stories  14

How to convert page number to roman numeral in ZEN Report?  14

Extending method keywords  13

How to navigate to parent of Serial Object?  12

Kill process started by JOB  11

Custom file pass through Operation writing out unreadable pdf files  11

Has anyone tried REST API Put Or Post on AWS S3 ?  10

%ProcessError+6 ^%Net.Remote.Proxy.1 error occurs inconsistently  10

How to Update Caché User Full Name field via SQL?  9

Top 10 Authors to Follow by Views

Francisco López, Posts,  147

Eduard Lebedyuk, Posts,  73

Daniel Kutac, Posts,  45

Pete Greskoff, Posts,  34

Top 10 Experts to Follow

Nicole Aaron, Answers,  +11

Robert Cemper, Answers,  +10

Eduard Lebedyuk, Answers,  +9

Vitaliy Serdtsev, Answers,  +7

Benjamin Spead, Answers,  +4

Francisco López, Answers,  +4

Evgeny Shvarov, Answers,  +3

Dmitry Maslennikov, Answers,  +3

Gilberto Junior, Answers,  +3

Timothy Leavitt, Answers,  +2

I have inherited a web-based database application and I'm having a hard time understanding the sequence of events when CSP pages are opened.  I have very limited web development experience.

Can anyone recommend a good resource for explaining this?  I have already gone through the Cache Cinema tutorial and the Cache CSP documentation.

Among other things, I don't understand when the OnPreHTTP method is invoked, when it is needed, and what belongs in there.

I'm creating a new namespace by the installation manifest XML and in the "database" tag configuration I don't see attribute to configure if I what jounal globals or not to this database.

In the database wizard of the "portal administration", have this option.

Regards,

Lucas Boeing Scarduelli

Hi.

I would like to know if DeepSee has some feature regarding synchronization which could help me with this:

I have two tables, TableA and TableB in a 1:n relationship, and one cube for each table, CubeA and CubeB.
CubeA have a list dimension based on records from TableB.
Both tables has DSTIME parameter set to "AUTO".

Some application proccess updates data only on TableB, leading an entry on ^OBJ.DSTIME global for synchronization of CubeB.
However, as the TableA wasn't updated, there isn't such entry for CubeA.

Thus, filtering on CubeA dimension which depends on records from TableB is affected.

Curr

I'm trying to add an Operation to store DICOM files but each time I add a Operation using the class EnsLib.DICOM.Operation.TCP it reverts into Services and I cannot work out why this is happening. I've tried following the guide online (link at the bottom) but the Operation still reverts to a Service.

Any pointers would be appreciated,

Thank you.

https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KE…

I have a service that takes a file and pass it through to the production .While I am passing the file through I get the file stream and set it to a variable within my message and the variable is of type %Ens.StreamContainer. But after all processing and I need to write out my file to a pdf format The file gets written but is a corrupt file since I can not read it I have tried this with asimple pass through everything is fine .But here I do not know what I am doing wrong here is the operation code

 set pInput=pRequest.FileStream
     ;the variable to hold the status for the method
 #dim

Hi,

is there way when select a value in filter column and the second column filter use only value referred to the first selection??

we use to active filter to column in table, but not know how relationship the filter between columns of table.

only in the table context in zen page.

Hi, Community!

We are pleased to invite you to the InterSystems UK Developers Community Meetup on 25th of June!

The UK Developers Community Meetup is an informal meeting of developers, engineers, and devops to discuss successes, best practices and share experience with InterSystems Data Platforms! 

See and discuss the agenda below.

Hi, Community!

I'm happy to share with you that Developer Community is growing and Yesterday we reached a good milestone: 1,000,000 unique reads for articles and questions you contributed to InterSystems Developer Community.

I am trying to read some binary data from a local file or through socket.

The binary data is like H.264 codec, I need to read data BYTE by BYTE (even BIT by BIT) and decide the next step based on the data read so far.

I check the documentation and it seems like most of the sample focus on human readable IO, ie: LINE by LINE.

Could I achieve my goal through COS?

Thanks. 

I thought I should be able to go to the application error log or look at d ^%ER when I get the following error in the browser when troubleshooting a CSP page:

An error occurred with the CSP application and has been logged to system error log (^ERRORS)

However nothing is being generated in these logs. Where are these logs being made?

Thank you

Hello,

I need to add a new property ("Injection") to an existing database.  The existing database contains, in part:

An "ImageStudy" which contains one or more "ImageFiles"  defined as follows:

Class PET.ImageStudy Extends (%Persistent) 
{
Relationship ImageFiles as PET.ImageFile [cardinality=children,inverse=Study]
...
}
Class PET.ImageFile Extends (%Persistent)
Relationship Study as PET.ImageStudy [cardinality=parent,inverse=ImagFiles]
...
}

The requirements for the Injection are that 1)an ImageStudy can have one or more Injections; 2)an ImageFile is associated with a single Injection;

I have a class thus:-

Class RMH.ClinDoc.Response.GetEPRDisplayResponse Extends Ens.Response [ProcedureBlock]

{

Property GetEPRDisplayResult As %XML.String;

}

The property GetEPRDisplayResult  contains  html content.

When I write out the property in a terminal,  all the html special character content is encoded e.g. '<' is &lt;  '>' is &gt ; etc....

I want to display this html in a browser and have it render as normal.

So my question is how to I store html content in a cache object such that it renders correctly in a browser?

To make things more complicated this data comes into Healthshare as an xml

I have this local, containing a list of books of arbitrary length:

set books=2
set books(1, "author") = "Alice"
set books(1, "title") = "Hello"
set books(1, "pages") = "123"
set books(2, "author") = "Bob"
set books(2, "title") = "World"
set books(2, "pages") = "456"

And I want to generate this PDF (there could be more than two tables), each book is a separate table:

The header is always the same (Author, Title, Page) but the number of tables would be different.

ZEN reports sounds relevant, but I'm not sure how to pass data from local there and how to draw a separate table for each result.

Or

Typically, I have time to review the documentation, which I'm sure is here. However, I have a workaround (TEST1) but I was wondering if anyone could assist me in advising how I would need to adapt the curly brace snippet (TEST2) to provide the same result.

Thanks for any help you can provide.

TEST1(STATUS=1) K (STATUS)X "S MSG=$S(STATUS:""HELLO"", 1:""GOODBYE"")"W !,MSGQTEST2(STATUS=1) PUBLIC {X "S MSG=$S(STATUS:""HELLO"", 1:""GOODBYE"")"W !,MSG}

How do I get non latin text in PDF mode for ZEN reports?

Currently cyrillic  test is rendered as ####:

/// ReportDefinition is a placeholder.

June 25, 2018 – Alert: Outer Join Query Results

InterSystems has corrected two defects that can cause SQL outer joins to return incorrect results. These defects can also impact DeepSee in Caché and Ensemble, as well as InterSystems Business Intelligence in InterSystems IRIS; in these cases, building and synchronizing some analytic models may result in build errors.

These issues exist on all platforms for the following released InterSystems Data Platform products:

• InterSystems IRIS Data Platform 2018.1.1
• Caché and Ensemble 2017.2.0 and 2017.2.1
• HealthShare Health Connect 15.03 on Ensemble

When I down load a file using a csp page, the application  shows  the percentage as  37 %, 74 %, and 100 %.    I am trying to make changes to the application that it shows one percentage after each read.  The first time it reads, it would display 37%.   The next run would replace

37 %  with 74 % and so on until it completes its download.   I have tried adding javascript code to the application  however it doesn't work.   For example when I enter &js('alert');, the application displays it value on the screen.  Also, I tryed putting it between two scripts tags and it doesn't work.

I can use html

I have a need to restrict some developers access to Message Viewer in a namespace without restricting their ability to create or modify productions components. Is there a way to do this? It's not clear from the documentation.

Hi Community!

As you know we have Global Masters program — InterSystems Data Platform Advocacy Hub. 

All Global Masters members (Advocates) can achieve various levels of advocacy which depends on contributions on Developer Community and activity in Global Masters. 

Every new level opens new type of challenges/tasks and new types of rewards.

We are excited by how engaged you are with Global Masters but realised that we have a really great gap between initial level Insider and the next level Specialist. Indeed, Specialist level demands really great achievements: 10 articles, 10 questions on DC, article with 1,000 views.

So we introduced a new level of advocacy with name "Advocate".

See the details below.

Hi Everybody!

We are pleased to invite you to the upcoming  webinar "Optimizing Application Performance" on 29th of May at 10:00 (Moscow time)!

A unique chance to talk about application performance. 

Hi Community!

InterSystems Global Summit 2018 is approaching fast! 

We've just introduced 3 new rewards exclusively for members of the​ InterSystems Global Masters Advocacy Hub!

Check out new Global Summit 2018 Rewards below!

I'm facing a specific sort problem.
There are several thousands of articles sold all over. 
Users expect to get a description in local language sorted by their specific collation.

Hi folks,

One of my clients want to project a null property of a cache object to an empty XML element. Say, if we have a class:

Class Diabetes.BS.Message.LabReportMessage Extends Ens.Request
{

Property Report As %String;

Property IsRisky As %Boolean;

Property RiskValue As %String ;

}

If the instance of this class has a null RiskValue, after projection, they want the XML as following:

<LabReportMessage>
                <Report>Somestring</Report>
                <IsRisky>1</IsRisky>
                <RiskValue/>
 </LabReportMessage>

Is there any way we can do it? Thanks.

Hi Community!

New video "Treating Patients with REST and iKnow" is available now on  DC YouTube Channel:

I have a CACHE.DAT file that is working under CACHE version 2015.1.0.429.0

I have a second machine with CACHE version 2017.2.0.741.0

When I attempt to add/use the CACHE.DAT in the new version of CACHE, it will not mount.

How do I upgrade/convert the DAT file to make it work under the new CACHE version?

Thx. Larry...