Developer Community for InterSystems IRIS, Caché, Ensemble, HealthShare, InterSystems Business Intelligence and Text Analytics

Question

Mikhail Khomenko · Oct 31, 2016

Good day! Can someone briefly explain or give me a link to documentation why in Linux Cache starts 8 Write Daemons (Main and 7 Slaves)? Thanks!

#System Administration #Caché

0 7 585

Question

Evgeny Shvarov · Oct 28, 2016

Max function for the set of parameters

There is an interesting discussion in the Russian forum going.

What is the best solution for the function which returns the max for the set of parameters?

From the listed solutions I like this one:

ClassMethod max(args...) {
  for i=1:1:args {  s max(+$g(args(i))) = i }
  s i="", max=$o(max(i),-1, i) Q $lb(max, i)
}

#Code Snippet #ObjectScript #Tips & Tricks #Caché

0 8 619

Question

Tirthankar Bachhar · Oct 20, 2016

%UnitTest Code Coverage

Hi,

When we write unit test cases for cache object script code using %UnitTest.TestCase, what is the best way to write code to identify code coverage?

So, let say my unit test case hit all 10 lines of code of a method for a given class. So, unit test coverage should be 100% for that. But, using line-by-line coverage [(%Monitor.System.LineByLine] getting wrong percentage, because it also includes code comment/documentation as part of code. So, practically we can not ever achieve 100% of code coverage by using this API.

#Monitoring #Object Data Model #Testing #Caché

0 2 590

Question

Stephen Wilson · Oct 18, 2016

How do you add a Total Phones column populated by SQL COUNT(*) expression in the Zen Quickstart Tutorial?

I have been following the online Zen Quickstart Tutorial using the lastest release documentation. In addition to playing around with the styling and making a few minor functionality tweaks, I wanted to add an additional column that shows a count of the number of phone numbers for that Contact (as shown in the image below).

#Data Model #Object Data Model #SQL #Tutorial #ZEN #Caché

0 4 320

Question

Evgeny Shvarov · Oct 18, 2016

Classes removing and renaming best practice with Atelier

Hi!

Suppose I have a project in Atelier with two classes: Class A and Class B and develop it in my local Caché installation.

If I decide to delete Class A and delete it in Atelier project will it be deleted in Caché automatically or should I do it manually?

Or what is the suggested workflow in this case?

Same question is if I decide to rename Class B to Class C.

#Change Management #Atelier

0 4 476

Question

John Murray · Sep 30, 2016

Atelier "Check for updates" broken?

Here's what I get when I check for updates from my 1.0.245 on Windows:

#Atelier

0 7 352

Question

Dmitry Maslennikov · Sep 17, 2016

Support for Java Hibernate 5

Working on implementation FHIR to my project, I found interesting project HAPI-FHIR, which could help me to quickly launch my FHIR api server with InterSystems Caché as a storage, because this projects uses Hibernate to connect to database, as an example they use DerbyDB. I tried to change settings to use InterSystems Caché, but unfortunately it does not work and throw some errors inside HIbernate. As I found in Caché documentation, I have not some many options, I just have to set Cache dialect, and set database url.

#Compatibility #FHIR #Java #Caché

0 13 1,355

Question

Marek Bernád · Sep 12, 2016

Class change trigger

Hello community,

#Caché

0 2 365

Question

Dmitry Maslennikov · Sep 9, 2016

FHIR outside of HealthShare

Some time ago, I was started to work at a new company even in other country, and more important in a different sphere when I have not been worked before, in HealthCare. It's a very new project even for company. Since I have not experience in HealthCare, I looked at what I can use in my project, and found that I should not reinvent the bicycle, and think about how to store all my data which I need and how to get access to this data. And I can use FHIR, which is looks like everything what I need, what else I need it's just a client.

#Ensemble #HealthShare #REST API

0 2 308

Question

Stephen Wilson · Sep 5, 2016

Can MERGE Statements using an $HOROLOG global index cause a race condition?

UPDATE: Found a reason in my code why this could be occurring. Still it would be interesting to hear what people come back with.

Consider the following MERGE statement.

#Caché #ObjectScript

0 1 226

Question

John Murray · Aug 25, 2016

New keys for Field Tests?

The FT keys InterSystems currently make available to us in the zips from the download pages are due to expire at the end of this month (31-Aug-16). Will there be new keys soon?

Also wondering when we might expect new FT builds for 2016.2 and 2016.3. The last published ones were 24-Jun-16 and 16-Jun-16 respectively.

I haven't seen an Atelier update for a while either.

#Caché #Atelier #Ensemble #Field Tests

0 2 246

Question

Nikita Savchenko · Aug 24, 2016

Caché Installation Unique Identifier

Hello community!

Is there any method/property/way in Caché to obtain something like unique identifier for installed Caché system? The idea is to get the identifier that will differ on any other installation/machine/etc, but will forever remain the same for the current installation, even if $zv changes (in case of update) or any data is removed from the database.

#Caché #ObjectScript

0 2 287

Question

Timothy Leavitt · Aug 17, 2016

What is the best pattern for reporting errors from an SqlProc?

Given a complex method flagged with [ SqlProc ] so it is available as an SQL stored procedure, what's the best way to report a non-system error detected in that method - say, for example, an error %Status - so that the SQL query calling it fails descriptively? Is it best to create and throw an exception, or are there special % variables involved (like in a trigger)? I haven't been able to find an answer in the documentation.

Thanks in advance!

#SQL #Caché

0 2 271

Question

John Murray · Jul 28, 2016

What does the "Routine Prefix" setting of a package do?

Studio's "Package Information" dialog, accessed from the context menu of a package on the Namespace tab of the Workspace pane, includes a field titled "Routine Prefix"

#Object Data Model #Caché

0 2 244

Question

Evgeny Shvarov · Jul 28, 2016

Pivot variables deployment

Hi!

How do you guys deploy DeepSee pivot variables?

Haven't found it in documentation.

Thank you in advance!

#IRIS Analytics (DeepSee)

0 5 241

Question

Raghu Kodumuri · Jul 14, 2016

Get the XML Subtree from XPATH DOM Resultobject

Hello,

How to get XML subtree from XPATH.DOMResult object as Stream or CacheString.

Here is my classmethod. My system receives XML message which has nested structures. The requirement is to send one message at a time to the destination. I have created the XPATH document and used EvaluateExpression method and which returns XML.XPATH.Result of type DOM. I am able to read the dom and get value of the element and its text. But I am looking to send back the subtree.

Code:

#Caché #XML #HealthShare

0 8 883

Question

Mike Dawson · Jul 12, 2016

Standards document for Objectscript developers

I need to create a standards document for new developers who are coming to Cache from other backgrounds.

Does anyone have an in-house document they could share with me?

Regards

Mike

#Coding Guidelines #Development Environment #Caché

0 8 1,063

Question

Evgeny Shvarov · Jul 8, 2016

Top from the group SQL query in Caché

Hi!
There is interesting question in Stackoverflow.
This query works for MS SQL:

SELECT * 
FROM 
(
    SELECT *, ROW_NUMBER() OVER (PARTITION BY client_id ORDER BY date_updated DESC) AS rn
    FROM client_address
) a
WHERE a.rn = 1

There is one answer there, which solves the task:

#SQL #Caché

0 5 1,762

Question

Javier Lorenzo Mesa · Jun 30, 2016

How to perform an SQL 'SELECT' with parameters.

Hi,

I'm trying to perform a SELECT with parameters using the EnsLib.SQL.OutboundAdapter. The SELECT returns results but seems to discard the parameters I try to send. I have tried two methods.

First:

Set par(1) = "20160630"
Set par(1,"SqlType") = 12
Set sql = "SELECT Cod, Ing, score FROM [bbdd].[dbo].[vw_Test] WHERE MyParam >= '?'"
Set tSC = ..Adapter.ExecuteQueryParmArray(.QueryResultSet,sql,.par)

Second:

#SQL #Ensemble

0 4 828

Question

Evgeny Shvarov · Jun 23, 2016

How to extract the root in Caché properly

Hi!

Here is the question in Russian Forum regarding roots extracting.

In Caché ObjectScript we use exponentiation operator (**) to raise an exponent to power. F.e. let's raise 3 to power of 3:

USER> write 3**3 

27

And we use the same operator to extract the root.

USER> write 27**(1/3) 

2.999999999999999963

And 2.999999999999999963 is not 3, obviously.

How to extract roots properly in Caché ObjectScript?

#Caché #ObjectScript

0 5 304

Question

Vladimir Prushk... · Jun 9, 2016

Create GUID

Is there a system function/method which can create a GUID ?

#ObjectScript #Caché

0 2 1,162

Question

Kenneth Poindexter · Jun 1, 2016

Best Way to Parse a HTML Page

I would like to write some code to parse a set of HTML pages from the internet in order to gather information from each web page.

All of the web pages are generated using a template, so the format of each of the web-pages is consistent with one-another and the information that I want to gather is always located in the same logical place within the page.

What is the best way to parse an html page in order to gather information at a specific place?

Can XML XPATH be used here? Does anyone have any examples of parsing HTML content?

#XML #ObjectScript #Frontend #HTML #Caché

0 6 1,075

Question

Evgeny Shvarov · May 30, 2016

Solution for T9 Spelling Problem in Caché ObjectScript

Hi, Community!

Last weekend we held the Final of InterSystems Contest on Caché, DeepSee and iKnow under the aegis of IT Planet Student Championship in Ekaterinburg. BTW, this year we had more than 1,400 participants in InterSystems Contest.

#Caché #ObjectScript

0 20 889

Question

John Murray · May 24, 2016

Is there a "what's new" list for new public builds of Atelier?

I just used Help\Check for Updates and updated my Atelier from 1.0.158 to 1.0.165. Is there any information published about what's new/fixed in this compared to previous public builds? Having that information might help us target our testing and so increase the value of our feedback to you.

#Atelier

0 1 213

Question

Evgeny Shvarov · May 12, 2016

Full series of dates in Time Dimensions in DeepSee

Hi!

Sometimes, especially when I work with Combined Cubes, I need to have all the dates in Date Dimension, not only members with rows in Fact table.

Is there any way to switch it on?

#IRIS Analytics (DeepSee)

0 6 250

Question

Evgeny Shvarov · Apr 24, 2016

Import/export data from InterSystems Caché

Hi!

Suppose I have full access to Caché database instance A and want to export consistent part of the data and import it into another Caché instance B. Classes are equal.

What are the most general and convenient options for me?

TIA!

#Databases #Data Import and Export #Object Data Model #Caché

0 11 5,619

Question

Richard Housham · Apr 22, 2016

Transformations

Hi this is my first post, so a little about my background. I've been programming in PHP/JavaScript for about 10 years.
I've got quite a bit of knowledge surrounding object orientated programming and know the basics.

Last year I looked into the Mirth integration engine and did some work around that.

I've now moved jobs and I'm doing some work (surprise, surprise) with Ensemble.

#DTL #Object Data Model #Tutorial #Ensemble

0 1 510

Question

Evgeny Shvarov · Apr 16, 2016

Atelier project hidden files. What should I commit?

Hi!

In every Atelier project you can find following hidden files:

.buildpath

.version

.connection

.project.

Should I include all of them into commit?

I understand that .project is mandatory. But what about the rest? Is there any general rule?

F.e. if we work in team and everybody has their own connection on locale machine .connection should not be included. Yes?

#Atelier

0 1 273

Question

John Murray · Apr 6, 2016

What does the + suffix at the end of a Studio document name denote?

Here is a screenshot from my 2016.2 FT instance of Studio and Ensemble:

I don't recall having seen the highlighted "+" suffix on document names previously. Who can tell me what it denotes?

I originally posted this in the Field Tests group but it turned out to be a 2016.1 feature that I hadn't previously noticed. So I subsequently moved the post to the Cache group.

#Studio #Caché

0 11 584

Question

Evgeny Shvarov · Apr 5, 2016

How to avoid writing duplicate code in dtl InterSystems Ensemble

Hi!

There is a question for Ensemble on Stackoverflow:

I have the below dtl. In the foreach loop, I am just copying the same code in another part under anif condition. How can I avoid this redundancy? Can I reuse using sub transformation?

Here is the dtl class file :https://docs.google.com/document/d/1snJXElyw13hAfb8Lmg5IaySc7md_DE8J40FB79hBaXU/edit?usp=sharing

#Ensemble

0 2 426

Social networks

InterSystems resources