I am trying to return the maximum of the value of 2 fields: LastViewed and LastDownloaded  AS a local variable -LastAccessed for each row, using a SQL query . These values are stored as $ H format.  Is there an existing SQL command that compares two column values ? I could not find one, so I tried using a $Select statement . I got an error that said A term expected beginning with either of: identifier, constant, aggregate, $$,(,:,+....)

Here is the SQL Query I am trying to run:-

0 5 554

I am configuring a SOAP HL7 Receiver to handle HL7 Query messages.

I have set up a new class based on EnsLib.SOAP.Service and configured (correctly I hope) the parameters needed.  I have also amended the OnProcessInput Method skeleton provide to send messages on to the Business Process needed.

I am struggling to work out what is needed in the Web Methods and how to create them. 

Any help with this would be much appreciated especially examples that I can adapt for what I need.

Many thanks 

0 1 232

I have been following the online Zen Quickstart Tutorial using the lastest release documentation. In addition to playing around with the styling and making a few minor functionality tweaks, I wanted to add an additional column that shows a count of the number of phone numbers for that Contact (as shown in the image below).

0 4 318

I have a tablePane ZEN Component and I am trying to get a filter running on the Specimen Id / Lab Number. The SQL is fairly complex with 3 UNION ALL statements joining 4 tables and a couple of lookup tables.

How would I get the filter on SpecId to work for my tablePane? It's not automatically applying the filter for me so I think I need code something.

0 1 269
Todd Johnson · Mar 2, 2017
TLS Cipher Suite selection

Our client is a test out of 2016.1 (Build 656U) Healthshare that wants to do a one way SSL connection to our Java 1.7/Tomcat 8.0 server.  We have yet to come up with a secure cipher set that Healthshare and Java agree on for the handshake.  So far we've had to use these ciphers identified which are not recommended (though it does do a handshake properly).

0 1 699

If your Ensemble environment is actually a HealthShare one, here's a snippet of information that I wasn't able to find in the documentation.

When a namespace is HealthShare-enabled it gets some mappings added to it in order to fetch stuff from the HSLIB database. The most obvious mapping is a package mapping that gives your namespace all the HS.* classes.

0 4 314


Consider I have a class Package.Data with Property UniqueStringValue as %String.

I introduced the Index for this property:

 Index ValueIndex on UniqueStringValue [Unique];

It works well.  But if I try to check if there is an object with the certain value in code like this:

if ##class(Package.Data).ValueIndexExists(value)  

this expression fails, if value="value", even if there is an instance with instance.UniqueStingValue="Value"

How can I set the index to prevent saving case sensitive values in this class?

0 6 350


I am trying the following command in order to freeze the instance before backup is done:

    csession CACHE -U%SYS "##Class(Backup.General).ExternalFreeze()"

The command requires user name and password to be supplied when prompted. Is there any way that this command can be run where it doesn't query the credentials? I am wondering if it can use OS level permissions (root or effective user who owns Cache processes etc) .

My test is on a CentOS 6 machine if that helps. 



0 2 831
Seth Jaffe · Feb 13, 2017
Connecting using factory


  The following code in .Net using  CacheObject.dll  version 2016.1.2.206 com library

                  ConnectionString  =  "cn_iptcp:[1972]:PHDEMO:PHSYSADM:***********" 

                  b = factory.Connect(ConnectionString  )
                  objCacheObject =  factory.Static("CacheObjectConnection")     
                  clist  = factory.GetConnectionList()

  for the above code, b is true and clist is  Local,cn_iptcp:[1972]: 

0 1 297

For reasons that I won't go into here, I need to run Cache Terminal in Linux using Wine.

It starts up ok, but when I try to establish a connection to a remote server I get the following error:

Ctermsecure Read Error
Could not obtain terminal server client name.
Reason: (10035, 0x2733) unknown error

If I launch CTerm.exe from a command line then I get the following:

0 3 586

I am in the planning stages of making things more uniform in our routines and I would like to know what the easiest way would be to include an .inc at the beginning of each .mac routine. Has anyone written something that would open all routines and place something into the first row while leaving the rest of the routine unchanged? Thanks for any guidance you all may provide.

0 3 241

Per the information at http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=... I am trying to use a call to $ZF("GETFILE") to obtain information about an OpenVMS file. But I get an <ILLEGAL VALUE> error.

For example:

w $zf("GETFILE",filename,"UIC")



My filename variable contains the full path and name of a file that I own. I hold the %All role in Cache.

0 4 308

Hi all,

We have a big problem with spanish accent and special characters using Data Transformation (HL7 Messages).

We have some DT to transform HL7 messages to other type (OUL^R22 To OML^O21) so it copys the PID segment to the new one, but if in the PatienName field has any special character, the transformation stops and it not continues with the transformation.

This is the message

0 1 626
Konstantin Dualcore · Jan 25, 2017
Debugging web app

Hello, I'm trying to debug web app in Atelier remotely.

In Studio I could use "Set as debug target" option for this purposes. The class launches with CSPDEBUG option in browser and everything goes fine. But I can't find how to do this in Atelier.

Can anyone help me?

0 1 280

Can someone direct me to where in the documentation we can find how consumption may be calculated for global storage?

Caché Version2010.1
Operating SystemHP OpenVMS 8.4

EDIT: After receiving some responses, it seems I was unclear in my initial inquiry. I am looking to determine our rate of consumption of storage; however, I am having some difficulty in doing that.

0 6 492