Hi, Community!

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

Most viewed

Output 9876543210 without using numbers  314

Atelier 1.1 Roadmap  313

Is Caché SQL essential to Caché Objects?  227

Virtualizing large databases - VMware CPU capacity planning  223

WebTerminal Over Telnet Is Possible. Should It Born? (v5) Open Discussion.  186

Ways and methods of Accessing Relationships with SQL  177

Meet John Murray, InterSystems Developer Community Moderator  165

Cogs.JsonClass 1.0  155

Decoding Base64 PDF File  152

Can you crack the Black Box?  133

Most voted

Meet John Murray, InterSystems

I have created a class that extends file operation, but can't find the object that has the value for the file path. Is that object in pRequest or is there an another object I should be used to see that value?

Hi.

It is easy to receive JSON representation or dynamic Array from %ListOfDataTypes:

set l=##class(%ListOfDataTypes).%New()
do l.Insert("a")
do l.Insert("b")
do l.Insert("c")

set arrStr=l.$toJSON()
zwrite arrStr
set arr=l.$compose([])
zwrite arr

How to make backward conversion? How to receive %ListOfDataTypes from dynamic Array an JSON string?

I've tried

SAMPLES>set list = ##class(%ListOfDataTypes).$fromJSON("[""a"",""b"",""c""]")

%FromObject+21^%Library.RegisteredObject.1 *%Exception.General Compose Compose %FromObject Unable to map from %Library.Array instance to %L

Here is an idea that would make the Developer Community immensely more valuable (to me anyway)

Have the capability of getting Listing output from searches or tags or groups.

In addition, have people put titles on their answers and comments,

And having a detailed list with all the answers and comments if needed

Then being able to sort the list by date or other criteria.

Something like:

Sub1 . . . .

-answer . . .

-comment . .

-answer . . .

Subject2 . . .

-answer . . .

Subject 3 . . .

-comments . . . 

Hi, we are trying to deployed a changed schedule to our DEV instance (from our TST).  And are getting an error:

Dear All,

I would like to block ADT_A18 and ADT_A47 HL7 2.3 messages with an empty MRG:1 field.

This is to prevent my current HL7 ADT router (Business process) sending blank Merges downstream.

I've attempted to create a business rule where this would return out the business role process.  However the messages still loop though the other rules.

Any advice would be great.

Kind Regards

Stuart

Hello...

I need to convert a array  (JSON) in a List Of String. I think, there is some method that does it directly.

Something like that:

SAMPLES>set list = ##class(%ListOfDataTypes).$fromJSON("[""a"",""b"",""c""]")

%FromObject+21^%Library.RegisteredObject.1 *%Exception.General Compose Compose %FromObject Unable to map frm %Library.Array instance to %Library.ListOfDataTypes

I have reading about this but I don't found some trick to help me.

https://community.intersystems.com/post/how-convert-json-listofdatatypes

Thanks!!

I have a class with text property, which contains html text (usually pieces, so it may be invalid), here's a sample value:

<div moreinfo="none">Word1 Word2</div><br>
<a href = "123" >Word3</a>

When I add iFind index on text, there are at least two problems:

• Words like moreinfo="none">Word1, so exact match with Word1 returns nothing
• Irrelevant results for href search

How can I pass plaintext into iFnd index?

When posts are displayed on the DC homepage they only show the first part of each post. This part is known as the teaser, or the trimmed version. The DC software does its best, but without being given any hint by you it can sometimes produce teasers that are of limited value, e.g. "Hi!"

When composing your post, the Preview button lets you see what the teaser will look like. For example, here's the preview of an initial version of this post:

And if you want to take control, put the cursor at the point you want the teaser to end, then click this button on the editor toolbar:

But sometimes all it t

Hi Community!

Please find the Developer Community video of the week:  

Monitoring : Don't Turn a Drama into a Crisis 

Sometimes, it comes in very handy (especially for the EAV model) to use array properties in a class and be able to qickly search by their elements: both the key and the value.

Let’s take a look at a simple example:

Hi

I get always the following error when I query our FHIR repository with a specific TAG

/csp/healthshare/fhirserver/fhir/Encounter?_tag=

ERROR #5002: Cache error: <INVALID OREF>zSearch+86 ^HS.FHIR.Repository.Operations.1

I've deleted rows from cache database. On the table HS_FHIR_Repository_Resource.Encounter as we had duplicate records...

Any help would be great

Kind Regards,

Joao Palma

Hi everyone!

We have many severs (DEV, QA and LIVE) besides many other slave servers (about 133) that are running Caché instances. Before writing this utility myself, I would like to know if anyone has done it before. We need to change the SuperUser password and do other credential setups like this on all of these servers and we don't want to do it one by one.

A few customers have seen this happen, so I thought it would be worth mentioning here on the Developer Community.  This could affect  users running versions between 2014.1.3 and latest who install or upgrade Wireshark.  There is a bug in the Visual C++ 2013 redistributable shipped with the current Wireshark 2.2.1. 

This is from Microsoft’s bug report  https://support.microsoft.com/en-us/kb/3138367 :

“When you install an updated redistributable package, binaries for non-target architectures are removed. For example, after you install an update for an x86-based application, the x64 Visual C++

I would like to start a discussion regarding Caché Objects and Caché SQL.

It is my understanding that the creators of Caché Objects see Caché SQL as the reporting arm of Objects and as such SQL is essential to Caché Objects.

I once met a Caché Objects programmer who was writing code to $Order through the Globals because that person thought that Caché SQL was too slow and inefficient. I attempted to convince the person otherwise.

So, what say you? Is SQL essential to Caché Objects?

Or

Is Caché SQL a nice to have but we can do without? Is it too slow? Is it too inefficient?

I really would like to have

Hi,

Can you please tell us how to create xsl file for CCD to SDA conversion using XSLT.

What will be the prerequisites.

I have tried to create an xsl file for the given xml given belowusing XSLT transform Wizrad:

<?xml version="1.0" ?>
<s1 title="s1 title attr">
  <s2 title="s2 title attr">
    <s3 title="s3 title attr">Content</s3>
  </s2>
</s1>

using the stylesheet below:

<?xml version="1.0"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
<xsl:output method="xml" indent="yes"/>
 
<xsl:template match="//@* | //node()">
  <xsl:copy>
    

FYI, on the Field Test page, the links highlighted below are currently broken:

UPDATE: this is now working again.

Can we use iknow in the Cache tool means if i don't have deepsee tool to work on like for doing some sample programs. Because i don't have deepsee tool with me?

And is there any open source for downloading deepsee? 

This is a translation of the following article. Thanks [@Evgeny Shvarov] for the help in translation.

This post is also available on Habrahabr^ru.

The post was inspired by this Habrahabr article: Interval-associative array^ru→en.

Since the original implementation relies on Python slices, the Caché public may find the following article useful: Everything you wanted to know about slices^ru→en.

Note: Please note that the exact functional equivalent of Python slices has never been implemented in Caché, since this functionality has never been required.

All right, let’s cut to the chase and take a look at some examples.

Hello,

I have been struggling and could use some help as I think I'm burnt.  I am trying to change a Textual 2.5.1 OBX;5 with multiple iterations to a simple non-iterating outbound result.  I have played around with $piece but can't seem to get it to work.  The outcome I would like is for OBX;5 to look like this: |Positive| and currently it looks like this: |Positive~_~_~_~_~|.  Any suggestions would be appreciated.

I am pleased to announce the Maintenance Release of HealthShare Health Connect v15.021 on data platforms 2016.1.4

This contains the HealthShare module Core: 15.021.8253

The version number for this kit is 2016.1.4HS.8253.0

The platform list is the same as for HealthShare Health Connect v15.02 for 2016.1.3. You can get details from the Supported Platforms document.

I just tried to read all the Answers and Comments for a post of mine.

Some were 5, 8, 3, etc. days ago and others were just hours ago.

They all seem jumbled up.

If I wanted to read the Answers and Comments in some sort of chronological order, I would be lost.

I don't understand the reasoning on whether somethings is an Answer and others are comments.

But would it be possible to have the option when reading all the follow-ons to re-sort them in some sort of order?

June 26, 2017 – Alert: Data Corruption with Mixed Endian Mirror Shadowing

InterSystems has corrected a defect that may result in corruption of Unicode data on a shadow system whose source is an async mirror member.

This defect affects all currently released Caché, Ensemble, and HealthShare distributions beginning with version 2012.2.0.  All platforms and operating systems are affected.

In order to be exposed to the risk the configuration must include mirror primary and async members, and a shadow of the async member.  Additionally, the async member must be of different endian than both the primar

Hi,

I am trying to create a new dashboard using zen page for different namespaces. Could someone give me a sample code on how I can start designing the page for different namespaces in a single zen page/zen application.

Hi,

I would like to retrieve the O.S version (Windows or Unix) and Cache installed directory.

which COS apis should I use ?

Thanks for your help.

I noticed this morning that a post to which I had responded was apparently deleted by the original poster. In most other discussion fora, once a post has any sort of followup, only a moderator may delete the thread.

Nothing significant was lost in my followup, but I'm concerned that good information may, at some point, be lost due to the OP changing their mind about the original topic.

Thoughts? Comments?

(I don't plan to delete this post )

I would like  to invoke some unix/windows commands from COS, any API could do that?

Also, I would like to set up  some Environment Variables for this process which would execute  the above external command.

Anyway to achieve that?

Thanks for your help.

Hi, Community!

A few months ago we introduced votes for postings.

Hi,

We have a method written in cache studio that converts XML file to JSON and JSON file to XML,  Can we use this method in ensemble production.

This post is originally posted on GitHub.

This discussion is open to anyone who use or know about WebTerminal project. It is a result of a long story of the project development, testing and maintaining.

While WebTerminal greatly improves user experience by enhancing standard terminal with additional features, there are numerous issues (#77, #92, #81, #87 and others) showing that it performs not as expected in some cases, and does not support some very basic things (like $ZA/$ZB variables). The reason is in fact that WebTerminal project tries to reimplement Caché TERM behavior over Caché ObjectSc