Hi, Community!

We are starting  InterSystems Developer Community meetups:  events to discuss InterSystems technology in person.

This would be 2-3 hours evening events to meet and discuss the best practices, new features, share experience regarding implementation of InterSystems technologies and products.

Besides free discussion and networking there would be 3-4 sessions delivered by InterSystems engineers. Local partners are very welcome to participate as speakers too!

Join InterSystems Meetup group in Cambridge and come to our first meetup in Cambrdige, MA on 22nd of June.

I am trying to apply a temporary time-limited key for our organization to a Cache Server that I built out a few weeks ago for testing purposes. When I navigate in the portal to activate a new license key, I get this "ERROR #8610: License keys are not accepted on a Single User (SU) platform."

Is there something I need to do for this system in order to make it compliant for the key or do I need to request a new key from InterSystems that will work for this system? I didn't turn up anything on the web site here or via Googling the error and error text.

Looking for a way in which I could possibly pass a flag through a property when performing an Insert statement, on a mapped class.

insert into my.class (serialNumber, modelNumber, myFlag) value ('testSerial', 'testModel', 0)
    myFlag is not stored in the DB.

The mapped class then calls a legacy routine (MAC) via CodeMode = 'objectgenerator', (Insert method within the 'objectgenerator')

Within the legacy routine, I am setting an index... but I don't always want to set it (multiple inserts, and I will only set the index on the LAST insert)

Wanna Cry

Most of you should be aware that the Wanna Cry virus is massively infecting un-patched windows machines all around the world. It's particularly affecting the NHS, one of my main clients. 

Wanna Cry is one of a line of Viruses that exploit SMBv1 over ports 135 and 445.

A kill switch has been enabled, but this won't protect machines sitting behind http proxies, and there are already reports of new versions without a kill switch.

All windows machines should be isolated and updated a.s.a.p. 

If automatic updates is not on, a patch can be dowloaded from here...

https://technet.

Hi Team,

                 I am interesting to learn IKNOW concepts in Cache.Will need your guidance.

                 I. What is iKnow.

                 ii. Where we are using Iknow(Real time example)

                 iii. How to we work on iKnow(Did any tools Need?)

                iv. Please give notes and articals

Thanks ,

Ponnumani Gurusmay

Hello everyone.

I'm new to Caché.

I would like to know how I can connect my PHP application to the intersystems database.

Is it the same as MySQL?

Need help.

Thank you

Hi community,

I do not understand why I get a 'javaScript exception'?

Purpose is to search for a [Country] based upon a [Code] as search parameter.

this is my code:

<hgroup>
<text id="CountryID" name="Code" label="Code" size ="8" />
<spacer width="5"/>
<text id="CountryName" name="CName" label="Country" size ="24" />
</hgroup>
<spacer height="5"/>
<button caption="Search" onclick="zenPage.searchValue();"/>
</page>
}
ClientMethod searchValue() [ Language = javascript ]
{
var ctrl = zen('CountryID');
tVar = ctrl.getValue();
alert (tVar); ///test-show text value
zenPage.

Recently I have encounter an issue to get the columns out from a query without execute it.

For example:

I have a Query looks like below. How can I get the 'col1,col2,col3,col4' or the text of the query("select col1,col2,col3,col4 from mytable") back?

Query myquery() As %SQLQuery(CONTAINID = 0) [ SqlProc ]
{
 SELECT col1, col2, col3,col4
 FROM  mytable
 }
 

It is taking several hours to read  a large text file because the while loop uses ReadLine() !  Is there some way in Cache to  process a single file using multiple processes. Something comparable to this:-

http://stackoverflow.com/questions/11196367/processing-single-file-from…

I was looking at the OrefToArray^%occRun in the %CSP.ErrorLog page in version 2016.  However, we're on version 2014, and that method does not seem to exist yet.  I would love a good way to swizzle out the info in the %request, %session, %response objects for the error log for my own error page, in version 2014.  I don't want to have to go through and get all the properties manually, but I will if I must.  Any other good way  already written?

Thanks,

Laura

Hello All,

I have a question / issue regarding the calling list.FindOref(<object from indexOpen call>)
Here is a simple way to reproduce the issue: 
2 classes: Utility.contacttypes and Utility.person
*************************

Class Utility.contacttypes Extends %Persistent
{
Property description As %Library.String(TRUNCATE = 1);
/// Index for property description
Index descriptionIndex On description [ Unique ];
}

*************************

Class Utility.person Extends %Persistent
{
Property types As list Of Utility.

Most viewed

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

Let's write an Angular 1.x app with a Caché REST backend - Part 1 of Many  281

Compilation gotchas and a request for change  250

Bug killing development tips  175

Let's write an Angular 1.x app with a Caché REST backend - start here  125

WebSockets vs Long Polling vs Short Polling?  122

Authentication with REST  114

Containerization Caché - let's add our application  108

Node.js: create a basic web app with React - part 1  101

Is it possible to change GUID of an instance?  98

Let's write an Angular 1.x app with a Caché REST backend - Part 2  96

Hi,

I would like to list out unchecked mapped items ( classes in management portal )  classes of a particular namespace. Is there any code or terminal command which i can use ?

I am able to list out classes of namespace . But I need to list out unchecked mapped items classes

do ##class(%SYSTEM.OBJ).GetClassList(.result)

Hi,

I would like to know if there is any code to compare and update two directories/namespaces for class files.
If file is present in directory1 and not present in diectory2, it should import the classfile.
If file is not present in directory1 and it is present in directory2, the corresponding file should be deleted from  directory2.

Please suggest code for the task.

Thanks,
Arpitha R

Something that shot up the popularity stakes last week was this article on a very interesting initiative: RealWorld:

https://medium.com/@ericsimons/introducing-realworld-6016654d36b5

I decided it would be a good idea to use this as a way of creating an exemplar implementation of a RESTful back-end using QEWD against their published API (https://github.com/gothinkster/realworld/tree/master/api)

The results are here:

https://github.com/robtweed/qewd-conduit

Actually it's the first 3rd-party implementation out of the blocks!

Hi Community,

I'm just editing a class in Atelier. I have added below code into the class.

Set tStream=##class(%Stream.GlobalCharacter).%New()

When I type tStream. , It's not automatically suggesting properties of that object instance in Atelier. If I click "Ctrl+Space", It says "No completions available". 

Is this functionality not available in Atelier yet Or Should I make some configuration changes in Atelier to make it available?

I'd like to have production specific settings for different environments (OTAP). I have set the system default settings on my production to override the default settings. However, this does not seem to work. It is my understanding that the system default settings override the settings I have set on the production (I thought I heard my Sales Engineer say this). However, reading the documentation I am not sure of this reading either. However, when I clear the values for the adapters on my production my system default settings are still not apply.

Is there any good book where is described process of mapping globals to classes? And book about Storage? 

I didn't find much information about these questions in documentation :-(

Greetings.
I'm trying to do some experiments using the Atelier REST API, but I noticed a bug that I simply can't bypass.

When requesting the Atelier server asking for an array of docs, it seems to fail when using it with multiple formats.
Like: [ "RCWWW015.int", "Class.cls" ]
While this method does return the class's source code, it fails when fetching the routine.
Like this:

      {
        "name": "RCWWW015.int",
        "db": "DEV",
        "ts": "2017-01-24 11:37:05.851",
        "upd": true,
        "cat": "RTN",
        "status": "ERROR #5001: Missing Source for Document: RCWWW015.

Using the CSP Gateway is there a  way for an web application to mimics MLLP sockets connection? I have a requirement for no PHI in the DMZ and I wanted to see if there is a way to install the CSP Gateway in the DMZ to received inbound/outbound messages where the DB is in the protected zone.

We at George James Software are pleased to announce the release of version 2.6 of Serenji, our editor and debugger for Caché, Ensemble and HealthShare.
The main enhancement in 2.6 is the ability to run on a Linux <edit> or OS X </edit> workstation using Wine 1.8. More release details are here.
This is a free upgrade to users already holding an activation key. For new users a free 30 day evaluation period is granted upon installation.
John Murray
Senior Product Engineer
George James Software

What is a correct way to pass parameters to the  %CONTAINS in embedded SQL statement when searching thru %Text property?

s sp="child,health"

&SQL(

DECLARE c1 CURSOR FOR

SELECT ID INTO :id FROM ICD WHERE Name %CONTAINS (:sp)

...

is not the same as executing the following in the SQL Manager

SELECT ID FROM ICD WHERE Name %CONTAINS ('child','health')

Hi ,

From the below code, we are able to import the class file to the namespace ( specified path is C:\temp\distr ) 

I have a class file and a folder in the above specified path. When i run the code, it is importing only the class file but not the class files present in folder. 

I would like to know is there any code to import the class files present in folder as well. 

Include %occInclude

Class User.InsClass
{

/// You can see generated method in zsetup+1^App.Installer.1
XData Install [ XMLNamespace = INSTALLER ]
{
<Manifest>
    <If Condition='(##class(Config.Namespaces).

How is the security handled in intersystems for GUI and web services testing part ? Does it have inbuilt security handling packages ? what are the limitations ? Please enlighten.

Hi All -

Our environment has multiple instances of HealthShare installed and most are on separate VMs/servers. Does anyone have any ideas on how to efficiently manage user accounts across all of these multiple instances of HealthShare? As you can imagine, creating 10 separate Cache accounts on each instance during onboarding of new associates is cumbersome and tedious as is disabling them. We have yet to integrate with AD but we do have a Cyberark initiative under way but it is in the very early stages.

Hello,

I am interested in working with a third-party API in my instance of the Community Portal.  I was curious as to how you all work with third-party apis.  Do you typically connect directly from within a ZEN Mojo Page or do you route the request through an operation in the management portal?  Are there any sort of best practices I should be aware of?

Thanks,

Bob

I am new to Intersystems and I am wondering if there exists a NYC tri-state regional or NE regional group for Ensemble?

If anyone has any information, please reply.

Thanks,

George Cornejo

NYC Health and Hospitals Corporation

55 Water Street

NY, NY

Please let know if it is feasible to integrate Security tools ( W3af and Iron Wasp ) with intersystems. If so, please let know how to do that..

I want programmatically select last added row in tablePane. How I can do it?

I am using a method: %OverrideGuidAssignment("NEW GUID HERE") to override my GUID, and would like to know if there are any parameters, which allow this method to return a status & or error msg? If you currently set it to a variable it returns the new GUID you originally passed in, regardless of if it failed to override or not.

Thank you in advance