Announcement Daniel Tamajon · May 21, 2018

As a developer, usually I'm concerned about how my code health is, and how the other coders code can affect to my own work.  And I'm quite sure most of us feel very similar.

In our company we use a Static Code Analysis tool to analyze code for different languages to ensure we are writing high quality and easily maintainable code by following a few best practices in terms of code structure and content. And the question was: why should be different for Caché ObjectScript language?

3
4 1233
Announcement Evgeny Shvarov · Aug 1, 2018

Hi, Community!

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

Most viewed

Atelier and Studio  1070

Caché and Ensemble 2018.1 Field Test Release  268

GraphQL for InterSystems Data Platforms  191

Cache Dynamic SQL Pagination  155

Caché SQL Queries  154

$ZF(-100,..) issues  145

InterSystems Platform Functions  127

Docker with overlay support  124

Atelier. Compilation returns "Failed to read /api/atelier/v1/..."  123

Error: CSP application closed the connection before sending a response  122

Use GZIP to compress/decompress files  112

K-Means clustering of the Iris Dataset  76

Intersystems Cache Python Object-Relational Mapper  74

The way to launch Apache Spark + Apache Zeppelin + InterSystems IRIS   72

Continuous Delivery of your InterSystems solution using GitLab - Part VIII: CD using ICM  70

Storage Performance Series - NetApp All-Flash FAS (AFF) A300  69

Load a ML model into InterSystems IRIS  57

Most voted

Caché SQL Queries  9

GraphQL for InterSystems Data Platforms  7

Caché and Ensemble 2018.1 Field Test Release  7

The way to launch Apache Spark + Apache Zeppelin + InterSystems IRIS   6

Use GZIP to compress/decompress files  3

Check audit settings programmatically  3

K-Means clustering of the Iris Dataset  3

Docker with overlay support  3

Load a ML model into InterSystems IRIS  3

Storage Performance Series - NetApp All-Flash FAS (AFF) A300  2

Most commented

Error: CSP application closed the connection before sending a responce  30

Create studio project file  14

Atelier and Studio  12

Cache Dynamic SQL Pagination  10

Unable to export lookup tables (.LUT) and HL7 schemas (.HL7) directly via Atelier to commit in source control (GIT)  9

Using regular expressions in a routing rule  9

zgetFile+8^User.Read.1  8

$ZF(-100,..) issues  7

Multi-line terminal commands  7

Querying ODBC SQL Server  7

0
0 420
Question karthik siva · Jul 31, 2018

Hi,

I want to include Info icon on DeepSee-Widget title bar like the image below. And when I click or hover on the icon it should display some information about the widget. I tried with the options available in Widget settings and referred InterSystems's documention as well, I couldn't find a way to get this.

Please help me to achieve this. Thanks in advance.

4
0 355
Question Stella Ticker · Jul 20, 2018

The REST webservice works perfectly when run on SOAP UI. This end point server is an https site that uses basic authentication (uname and pwd).  But when I run the request through an Enslib.Rest.Operation using a configured SSL and stored credentials, I get an "unauthorized" error, unless I explicitly hard code the password in the operation class. HS Version is 2014.1 .

I have 2 questions. Pardon me, they are both related!!

1: How can the httprequest object be viewed in Ensemble? It took a long time for me to actually troubleshoot this because I had no way to see the httprequest object before it

4
0 1234
Question Sebastian Thiele · Jul 31, 2018

Hi everybody,

we have some legacy ZEN applications build upon CSS2 style definitions. We moved the application due to an upgrade to a newer version of cache (2017.2.1). Anyway I have in mind that in one of the prior relases css3 style interpretation was enforced by ZEN and you could explecitly tell the framework to use CSS2 by setting a global. Anyway I can´t found any hints in the docs on that. Does anyone of the %ZEN gurus have this in mind?

best regards,

sebastian

1
0 270
Question John Jacobs · Jul 29, 2018

Working with a client who has two TryCache instances on his W10 machine. Trying to bring in globals from a text file which works fine in my environment but on his, he cannot make ^%GI accept a file from his C drive. His Cache is on C as is mine. Checking the path and the file name carefully, it is accurate. D ^%GI and enter the path with filename (as works fine for me on my system) and he gets a message [unavailable] and when he hits enter out of that message, he sees Cannot import from THIS device. I think I'm missing a config or security setting of some kind but I don't know what it is. Than

1
0 382
Question Jon Astle · Jul 26, 2018

I work for a large NHS Trust in the UK and we are using Healthshare and we process 1000s of messages each day.  Many of these are standard HL7 messages however for several months now we also pickup and drop off 1000s of PDF files.

We have our message purge set to 365 as we have to keep a years worth of messages as we have a retrieval and send process that enables us to replay any set of messages to any destination which we use to prepopulate end systems with activity and result history.

The issue we have is our database is growing out of control and I am not sure the best way to remediate this s

4
0 892
Question Julian Matthews · Jul 26, 2018

I have a process which is passed a .rtf within a GlobalBinaryStream. I am trying to then output just the .rtf to a folder on a server, but not even sure where to start.

Is there a Built in Operation that I can pass the GlobalBinaryStream to which will then write the file to a folder, or do I need to use a custom class for the operation?

Thanks 

2
1 1649
Question JAQUELINE KRIEGER · Jul 18, 2018

Hi community, 

I'm in a proyect that I have to load data that cames from 3 different sources and one of these sorces is a csv file that contain the name of a switch and the name of a port. My cube have also this information, but I have to show only the values that match with this information.  I'm trying to filter the cube through this method below, the problem was  the result of the method is not only a value, it is an array with many values ​​and I must use the IN operator and not this "&" symbol. I wanted to know if it's possible or not?

Result of : ‘acc23-mqui2.redip.clGi1/17’,’acc01-mqui2.r


6
0 470
Question Tom McDevitt · Jul 14, 2017

Is there a class Method that will return the number of OBX segments under the OBR segments? I see  method ChildCountGet

 and ChildCountGet is that the correct method any any examples how to use it?

5
0 987
Question Sergio Vidal · Jul 20, 2018

Hi,

I have a question related with EnsLib.SQL.OutboundAdapter adapter.

Is there a way to open an oracle transaction and do either commit or rollback depending on the query result?

Is posible to keep open an oracle transaction to execute a lot of queries on different methods on the same business operation and do a commit when the business process finished?

Thanks and Best Regards

Sergio Vidal

4
0 411
Question Scott Roth · Jun 29, 2018

I wrote a ZAUTHENTICATE.mac a couple of months back, and found recently that it is creating coredumps on almost a nightly basis. I think I have figured out this problem to be not clearing out my MsgSearch after I am doing 2 of them within the code.

1. Get User Attibutes from AD

2. Get User Groups From AD

So while I am trying to cleanup the code I thought it would be a good time to add a Certificate and TLS to the mix since I should of been using that all along. However I keep running into issues

Error message: Cache error: <UNDEFINED>ZAUTHENTICATE+104^ZAUTHENTICATE *LD

its not displaying the error

14
0 618
Article Benjamin Thorne · Jul 24, 2018 1m read

The following code allows a user to view the audit settings of their instance. Run the code by running the class method "test":


class objectscript.checkAudit Extends %RegisteredObject
{
	classmethod test() {
		w "Checking for Auditing...",!
		Set SYSOBJ = ##class(Security.System).%OpenId("SYSTEM")
		If +SYSOBJ = 0 Set SYSOBJ = ##class(Security.System).%New()
		i SYSOBJ.AuditEnabled {
			w "Security Auditing is enabled for the following services",!
			s rs=##class(%ResultSet).%New("Security.Events:ListAllSystem")
			s sc=rs.Execute()  If $$$ISERR(sc) Do DisplayError^%apiOBJ(sc) Quit
			while r
1
1 770
Article Athanassios Hatzis · Jul 23, 2018 5m read

Hi,

this is a public announcement for the first release of Intersystems Cache Object-Relational Mapper in Python 3. Project's main repository is located at Github (healiseu/IntersystemsCacheORM).

About the project

CacheORM module is an enhanced OOP porting of Intersystems Cache-Python binding. There are three classes implemented:

The intersys.pythonbind package is a Python C extension that provides Python application with transparent connectivity to the objects stored in the Caché database.

2
1 1264
Question Mitch Scobell · Jul 23, 2018

I'm trying to have my REST service return the entire data set for one of our legacy globals.  Currently I am parsing the object from a SQL statement into generic objects to be returned like this:


         Set specimenArray=[]
        
        WHILE resultSet.%Next() {
            Set specimen = {}
            Set specimen.SpecimenId= resultSet.SpecimenId
            Set specimen.ProjectId = resultSet.ProjectId
            
            Set Oref = specimenArray.%Push(specimen)
        }
        
        Set tProxy = specimenArray.%ToJSON()
        set %response.Status = 200
        set %response.ContentType

2
0 891
Question sansa stark · Jul 16, 2018

Hello  ,

         Ensemble Business Process seems like red color but it still processing message successfully. I have checked log, events, queue everything is clear. there is no log info or error in the history.  If BP is in red color in the sense might have some issues, but is still processing messages successfully.

 Can you guys please advice on this.

3
0 368
Article Niyaz Khafizov · Jul 19, 2018 4m read

Hi all. Today we are going to use k-means algorithm on the Iris Dataset.

Note: I have done the following on Ubuntu 18.04, Apache Zeppelin 0.8.0, python 3.6.5.

Introduction

K-Means is one of the simplest unsupervised learning algorithms that solves the clustering problem. It groups all the objects in such a way that objects in the same group (group is a cluster) are more similar (in some sense) to each other than to those in other groups. For example, assume you have an image with a red ball on the green grass. K-Means will split all pixels into two clusters. The first cluster will contain t












0
3 9809
Question Damian Jenkin · Jul 15, 2018

Hi,
  I cannot edit properties (title etc) of Widgets within Dashboards outside of the ENSDEMO namespace:
  I have a namespace "HL7Report" for example;
  I have some Pivots created looking into a cube's data;
  I click "DeepSee", "User Portal" from the Management Portal;
  I click "+", "Add Dashboard", folder/name/title/category all as "new", "OK", new dashboard appears;
  I click ">", "Widgets >", "+", and select a pivot to display as a table (chart / anything);
  I then CANNOT edit the properties of the Widget, I click the ">" again and every Widget I create is "new (Closed)"...
  I do the exact sam

3
0 402
Question Damian Jenkin · Jul 16, 2018

Hi hi,
  Is there any way to do an automated daily print-to-PDF of a dashboard (its' widgets / pivots etc)?
  I am able to add a "Print" Control to a Widget on a dashboard to do the default DeepSee Print functionality of a Control, but this is manual and browser dependent.
  Is there a way I can either:
    1) have say a scheduled task to automatically print the dashboard (as and instead of the manual Control click) including specifying filename?
    2) failing full-automation; is there a way to get the manual Print Control (when clicked) to print and save to file in one step and not open the PDF t

4
0 457