HI

-- We have our Pivot ready for some data for all accounts. And we want to now filter it by Account

[Account].[H1].Account.&[1]

It works fine at the pivot level and it filters the records. We save the pivot with no filter values as we want users to decide the Account they want to filter for

-Now If i save this pivot without a value of a filter , then obviously it has all records and I want to filter it at the Dashboard level on my page.

URL I am passing

..... .dashboard&SETTINGS=FILTER:[Account].[H1].[Account].&[1]&NOTITLE=1

The filter doesn't work If I pass it this

InterSystems has completed the verification process for OpenJDK 8.

Customers now have the option to either use the Oracle JDK, or the OpenJDK with all InterSystems products and versions that support Java 8.
 
Support for future versions will continue to be supported on both of these Java Development Kits.

Hi Community!

It's February and we have a new release of DC features!

What's new:

• Handy member mentioning, spoiler block and other editor enhancements;
• Subscription to post types;
• New Open Exchange apps promotional options;
• InterSystems Official tag.

See the details below!

Hello Everybody and Happy 2019!

I hope this finds you well, relaxed and ready to tackle the challenges we'll face in 2019.

When a new period of our life begins it is nice and at times useful to consider what the previous period has been like and as the sage of old used to say "historia magistra vitae" or history is a teacher for our lives, maybe we can try to get some insights for the future. So, what did we see and experience in 2018?

1 - Information, knowledge & the machine!

Hello all,

I have an XSL question and I wanted to see if someone within a community can help me out.  

To Summarize: I am working with XSL documents, single and multi-pages.  
Inside my style sheet XML document, which is supporting my pages, everything on the page, including a headers, footers and the items are calculated 
based on the portrait measurements. 
Pages come up on the screen as portrait, but sometimes, depending on dynamic data are wide, they do not print properly in portrait.

Hi,

I'm writing to an ODBC connection to a SQLserver database, and I seem to be sending the wrong data type to a date colum?

set tSC = ..Adapter.ExecuteUpdate(.intRows,sqlInsert,$ZDATETIME($NOW(),3,2), pRequest.ComposerName, [...])

I think  `$ZDATETIME($NOW(),3,2)` is ODBC datetime format: 

https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=RCOS_fzdatetime#RCOS_fzdatetime_tformat

Do I have it wrong?

Stephen

Problem

I got a quick answer from this forum yesterday so I'm going to try my luck again today!  I've hit an error in another table when trying to extract through the Cache ODBC driver, but this one gives me less details and I'm struggling to pinpoint what might be causing the error.

The table I am trying to extract is called REF_TABLE_ONE.

Here's the Error:

[Cache Error: <<NOLINE>%0AmBx1^%sqlcq.PRD.2249>]
[Location: <ServerLoop - Query Fetch>]

Research/Trial & Error

Based on my research, it looks like the error results from something missing in a routine. I have limited access to this system.

Hi All,

Can someone help me getting the security features & standards which InterSystmes Cache adheres to ISO 27001 & other security & privacy standards.

Also if you can tell me the algorithm used for database encryption & key strength by default.

This is required for a security audit.

Thanks in advance. Ashish

Hi Community!

Here is a digest of the Developer Community postings in January 2019.

Most viewed

VSCode extension for InterSystems ObjectScript update  319

Free IRIS Community Edition in AWS  265

InterSystems IRIS 2019.1 preview   203

Seeking field testers for an upcoming VSCode extension from George James Software  185

How to start development  173

Caché and Ensemble 2018.1.1 available  162

n00b questions  145

Save the Date — InterSystems Benelux Symposium 2019  145

IRIS Quarterly Container only releases and Studio  141

Collaboration with Git in Atelier  140

The One Query Performance Trick You NEED to Know? Tune Table!  132

Explore Text Data with InterSystems iKnow Entity Browser  126

Should you trust Codd or your objects?  112

SQL Performance Resources  106

Perforce Example of Shared Development with Atelier   105

Top 5 takeaways from 2018  95

On a csp page, when you return %Boolean from a cache script into a javascript script, you're getting a string, not a boolean  89

Iterate over dynamic object  52

Using PMML models in your Business Processes  51

Good morning,

I have another question regarding batch files and Ensemble/Healthshare. Is it possible for a batch file to check the status of the mirror monitor and return it as a status or value?

At present, we store the name of the instance in an echo and reference that. In the event we have to use a different echo, is it possible to have that in a different variable at all?

I hope this makes sense. If I can provide any other information please do let me know.

Kind regards, Alexi Demetriou

In most cases, if one class depends on another, the class compiler will detect this and determine the correct compilation order. For example:

• Compiling a superclass triggers compilation of its subclasses.
• Compiling a custom datatype class triggers compilation of any classes with a property of that type.

Yet sometimes, a developer needs to specify compilation order. InterSystems class definitions contain two keywords for this, DependsOn and CompileAfter, that are very similar but not identical.

Hi Community!

We're pleased to invite you to the InterSystems Benelux Symposium 2019!

Date: February 5 - 6, 2019

Place: Radisson Blu Astrid Hotel, Antwerp, Belgium 

Please find all the details here: https://bnl.intersystems.com/symposium-2019

Hi, please can you help me. I cant understand a thing on how to resolve this. I can run the query perfectly fine on SQL but when I run it in studio, it gives an error.

"0 "_$lb($lb(6023,,,,,,,,,$lb(,"Production",$lb("e^zSQLGWE
xecute+2^%Library.DynamicQueryGW.1^1","e^zExecute+14^%Library.ResultSet.1^1","e^
zIsRENAL+25^Production.FunctionSet.1^1","e^zS1+2^Production.ProcessMessageEMED.Thread1
.1^1","e^zSwitchState+90^Ens.BP.Thread.1^1","e^zOnRequest+8^Production.ProcessMessa
geEMED.1^1","e^zMessageHeaderHandler+19^IMP2HL7.ProcessMessageEMED.1^1","e^zMess
ageHeaderHandler+93^Ens.Actor.

Problem

I'm working on exporting data from an Intersystems Cache database through the Cache ODBC Driver. There is a particular table that is giving me an error message. The ODBC Driver crashes and reports an error from the Cache system. I think I was able to trace down where the error is coming from, but I do not know how to debug or fix the error.

The table I am trying to extract is called SEDMIHP.

Here's the Error:

[Cache Error: <<UNDEFINED>%0AmBd16^%sqlcq.PRD.

Hi Community!

New video is already on InterSystems Developers YouTube Channel:

Certificate Revocation, OCSP Stapling and KMIP

Hello Cache Developers:  I was curious if anyone has ever created a TWAIN interface to their Cache Application?   I am new to TWAIN and hence the reason for this question.  From what I understand, TWAIN is software used by various digital imaging software and TWAIN provides an API for applications to call to be able to import images into their application.   I work with a healthcare application and was wondering what types of things are required for a Cache Web Application to call the TWAIN API to be able to load images into a Cache table.

Hi,

I'm in the process of trying to convert my team to a Git-based workflow for source code version management (we use Ensemble and HealthShare, but build a lot of customizations on top). We are having a hard time working with Atelier in this regard for a few reasons:

• Atelier always wants to sync the local files with the Cache server files, so switching between git branches causes all sorts of mayhem with the synchronization. Creating new files locally leads to a similar problem.

HI Community,

I would like to store a tablepane currPage variable in %session.Data, and retrieve the value when returning from a detail page back to the tablepane.

My test code so far:

ClientMethod Test1button() [ Language = javascript ]
{
var table = this.getComponentById('relationTable');
var pageNo = table.getProperty('currPage');
alert (pageNo)
zenPage.SetPage(pageNo)
}
ClassMethod SetPage(pageNo As %String) [ ZenMethod ]
{
Set %session.Data("currPage") = pageNo
//&js<alert(pageNo);>
}
ClientMethod Test2button() [ Language = javascript ]
{
var pageNo = ""
zenPage.

Hello,

I am trying to copy an xml file generated on an Apache server into the Jenkins workspace post-build. I was thinking to use a 'send files over ssh' post-build script, but have not done this before and do not know how to refer to the file location on Apache server vs on Jenkins.

For example, if I want to copy from Apache's location of: "classes/UnitTest/Results.xml" into Jenkin's workspace: "/ReportFiles/Results.xml",

How does the script differentiate between whether the location address refers to the Apache server or Jenkins workspace?

Or is there a better alternative way to do this?
 

Hi I'm using ensemble/cache 2016 is a NTML auth possible. Any code examples?

Currently I've got

set hr3 = ##class(%Net.HttpRequest).%New()
set hr3.Username = "xxxxxx/xxxxxxxxx" 
set hr3.Password = "xxxxxxx"
do hr3.Get("http://xxxxxxxxx/CaseNoteTracking/api/CaseNoteTrackingAPI/Get")

From the looks of things I need a http 1.1 request?

Intro

Please note, this article is considered deprecated, check out the new revision over here: https://community.intersystems.com/post/tutorial-websockets

The goal of this post is to discuss working with Websockets in a Caché environment. We are going to have a quick discussion of what websockets are and then talk through an example chat application implemented on top of Websockets.

Today in docs I found this example using NULL:

 WRITE $LISTVALID($LB(NULL)),!

simplified

zzdump $LB(NULL)

and NULL can be case-insensitive:

zzdump $LB(null)

seems the same as just:

zzdump $LB()

But if null variable is defined then list would contain value from variable. Case sensitive in that situation.

Does anyone have any Idea what is this? Is NULL used anywhere besides as a list element?

Recently I needed a classmethod that returns annotation value based on a name of a activity.

As doing it at runtime seemed inefficient, I wrote compile-time utility that iterates over all business process activities and generates relevant code.

This code could be used in a variety of situations when you need to iterate over business process activities, just add it as a secondary superclass to your BPL processes.

How we can reduce the size of cache.dat file? Even after deleting the globals of a particular database from management portal size of its  cache.dat file is not reduced.

The preview release of InterSystems HealthShare Health Connect 2019.1 is now available!

Kits and container images are available via WRC's preview download site.

InterSystems HealthShare Health Connect version 2019.

Hello all,

I would like to know how to download HL7 and XML messages from the Message Viewer. Currently I have to open Contents -> View Raw Contents then copy and paste one by one.

Thanks.

Victor

Let Say I have 
Class Carrier Extends %Persistent

Property Employee As Array of Class Employees

Class Employees Extends %SerialObject

Property Name As %String

Property Address As Array of Class AddressDetail

Class AddressDetail Extends %SerialObject

Property Street1 As %String

Property Street2 As %String

I can get value for Employee Name  as Employee_Name.

But I want to Get Value of Address Street1 and Street2 of Class AddressDetail using SQL Query
How can I get that?

Let's say I have a property as a variable value:

set propName="Country"

Is there a method to determine, should I quote it to access the object, so would the correct code be:

write obj."Country"

or just simple

write obj.Country

is enough?

Hello,

I'm trying to set Caché-Python Binding on Mac, but there is a problem.

I performed installation and configuration of Caché-Python binding module based on the manual (URL)
including setting of PATH and LD_LIBRARY_PATH in "bash_profile", 
and they seems to be done successfully (there was no error in the process).

However, when I execute test python file (test.py), it failed with error massage as below.
-----------------------Error Massage----------------------
Traceback (most recent call last):
  File "test.py", line 2, in <module>
    import intersys.pythonbind3
  File "/$USER$/.

I'm finding that in a mobile app setting, that Cache is causing the worst User Experience that I have ever seen in a mobile app - I'm just saying this hoping that someone will be able to help me out, my intent is not to criticise Intersystems.

We have a Xamarin Forms mobile app that consumes web pages that are created by Cache. The app compiles into iPhone, iPad, Android Phone, Android Tablet, UWP (Windows 10, all of phone, tablet, and desktop), as well as MacOS.

The cache-generated html that we are wrapping in the app naturally uses a licence slot when a user opens the app.