hi

  I execute sql from Terminal

SET result=$SYSTEM.SQL.Execute("SELECT TOP 5 name,dob,ssn FROM Sample.Person")

but I got error "<METHOD DOES NOT EXIST> *Execute,%SYSTEM.SQL"

Why?

Thanks

Hi,

we are trying to use Atelier and GitLab for our Software-development. Our Software has round about 1000 classes that got developed over years.

What we want to achieve is that one repository holding the complete code of one namespace. We also want to create branches to develop new small parts.

The main problem is that Atelier don't have the project view like in Studio where you can add/remove code and have an overview  of the project. It's like viewing the Namespace-Tab in Studio.  The complete source is always present in Atelier.

Hello. I am a student from Syktyvakar Forest Institute(Russia). 

I need to make Research : "Databases for working with spatial data
Consider MySQL, PostgreSQL and 1 to choose from". I want to explore Cache with subject library of spatial data.

Help.

Does Someone from the developers write the libraries of spatial data?

Caché offers a number of methods for going through a collection and doing something with its elements. The easiest method uses a while-loop and lets you fulfill the task in an imperative manner. The developer needs to take care of the iterator, jumping to the next element and checking if the loop is within the collection.

 But is it really what a developer should be concerned with?

Hi

Has anyone worked out any tricks to overcome this issue in 2015 and IE11 where the Dialog content is masked. I'm trying to fix it in a custom one, but you can see that the same issue is happening in the Standard Color Selection one as well.

Hi everybody, 

I have to create a pivot that shows the result comparing the last week of the current date with the last week of the last year in the same month. I tried using the function LAG, but didn´t work.  Works only if I want to compare the months between the two years.  If someone has some idea, i will appreciatte a lot. 

Thanks.

Jaqueline Krieger

Good day, I have this issue. I have global like: ^myglobal(varX) = $LB(var1,var2). I need to delete all globals that have variable var1 in that list same without a need to iterate through all globals and checking their value.

Exact example:

- in database exist following:

^myglobal("Marek") = $LB("code2",1400)
^myglobal("Ondrej") = $LB("code1",12)
^myglobal("Nikita") = $LB("code2",32)
^myglobal("Evgeny") = $LB("code1",76)
^myglobal("Maks") = $LB("code2",99)
^myglobal("Eduard") = $LB("code1",14)
Now! How to delete all globals that have in list in the first place value "code2" please?

I know this may sound like sour grapes, but really it is not.

I hear all the exciting things about the up coming InterSystems Conference, and I am sure it is.

But it is way, way out of my price range, and I am sure out of the price range of most of the Cache/MUMPS developers, without company backing.

Just wondering what others think.

Is there an available API for creating a business service? Is it just a table that Business Service Wizard is inserting the data into or it is something more? 

Good day, I would like to find out the size of Caché ObjectScript variable in order to guarantee that my program will not leak, equally in terminal and Caché globals.  For example how huge number I can store in that variable ? And what happen in Caché when variable will leak ? How is this behavior treated? (how much memory is reserved for common variable?)

Thanks  in advance for your answers.

How do we generally create an error object of %Status?

Set status=$SYSTEM.Status.Error($$$GeneralError,"Something went wrong")

Now, like $$$GeneralError there are many more macro defined within %occErrors include file by Intersystem which we can use.

i.e.

In my cache studio i couldn't find the a namespace of iknow so how can i check is my studio version is compatible to to the one i am using now. If i don't have one then can be able to create a new namespace in studio?

Hi Every Body

I'm studying AngularJS now ( looking for a substitute for my zen-mojo application ) , I would like to understand how can I connect from the client (AngularJS) with the server , passing data & invoking methods server side.

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?

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 %Library.

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?

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.

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?

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.

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.