FROM HS_IHE_ATNA_Repository.Aggregation
WHERE LocalDateTime < '2016-12-01'
That is exactly what I would expect.
FROM HS_IHE_ATNA_Repository.Aggregation
WHERE IndexedDate < '2016-12-01'
That is NOT expected.
That is exactly what I would expect.
That is NOT expected.
Using the following...
//Get PDF stream object previously saved
Set pdfStreamContainer = ##Class(Ens.StreamContainer).%OpenId(context.StreamContainerID)
Try {
Set pdfStreamObj = pdfStreamContainer.StreamGet()
}
Catch {
$$$TRACE("Error opening stream object ID = "_context.StreamContainerID)
Quit
}Would it be possible to search the pdfStreamObj for certain values like a Medical Record, or Patient Name?
Thanks
Scott
Hi,
Thanks for your time.
Plain $ZF(-1) and $ZF(-2) calls from Cache Studio or Terminal have stopped launching the OS shell from Win10.
cmd (Windows Command Prompt) should be launched.
Configuration:
Windows 10 Anniversary Update, Ensemble 2016.2.0.585.0 Developer Edition x64
Is this common? I have enabled both %Developer role and a Cache CallOut privilege for all users that operate in this scenario.
In Terminal, W $ZF(-1) prints -1, W $ZF(-2) prints -1
In Studio, W $ZF(-1) hangs the IDE, W $ZF(-2) prints 0
In all four cases, cmd (Windows Command Prompt) is not launched!
Any ideas, anybody?
As web application gets more complex, more technologies are involved into the application development. Once it gets deployed in large scale the configuration gets more complex too. For sure one of the most difficult part of the story is the security. In a complex solution when independent servers are feeding single web pages with contents, it is indeed challenging to keep the integrity of such system. HTML5 introduced a (weak) security constraint, the Cross Origin Resource Sharing (CORS). This article tells how to enable CORS for CSP/ ZEN applications.
Beginning with the next release after 2017.1, InterSystems products will no longer be offered on macOS (OS X) as a Server platform. This platform has been re-classified and will be available as a Development platform in future releases.
Hi-
I am trying to figure out how to compare two dimension values in a MDX query such that records where two dimension values are the same will be filtered out.
To test this, I have modified the HoleFoods cube in SAMPLES namespace to have a new dimension called RandomRegion
I want to create a MDX query where the [Outlet].[H1].[Region] value is not equal to the [RandomRegion].[H1].[RandomRegion] value.
Here's the query I need to add the filter to:
SELECT NON EMPTY HEAD(NONEMPTYCROSSJOIN([Outlet].[H1].[Region].Members,[RandomRegion].[H1].[RandomRegion].
Hi,
I was looking at the ENSDEMO namespace in our Ensemble server. In the class Demo.REST.DirectoryOperation, there is a line that uses the macro $$$URLENCODE. I would like to know exactly what does this macro $$$URLENCODE() do. Specifically what value does it. Unfortunately, I can't find anything about this macro in the Ensemble Documentation.
Hello folks,
We have recently upgraded the cache (5.x) to cache 2016. All are working perfectly. But i am struggling in Telnet.
Working Good,
when i connect to telnet it automatically gets the username(for example when we give the system ip addr(148.168.2.50), the ip address is taken as username) and directly goto the Password field in Telnet on old cache (5.x).
Now my problem is,
I can't get the same from my new upgrade instance 2016. When i connect to telnet it directly goes to username field but not to password field.
What is the problem ?
Hi all,
Which routine use to get username and password (telnet) ?
cache version :Cache for Windows NT (Intel) 5.0.21 (Build 6408) Tue Jan 3 2006 13:28:20 EST
Thanks,
sansa.
Hello. When you export and then import a table of data, is the import smart enough to figure out if a row already exists in the new namespace, and if so update the row rather than just save/add the row?
For example, we have a table in DEV, and the same table in QA. The DEV table has more fields than QA. When we moved up the class, the field definitions went with the table into QA, so now the table definition is the same in both.
We need to export the data from DEV and import it into QA, but file each row in QA as an existing row, and just update its data.
All replies are appreciated. We have put our first client into our production cache database and we are looking at what kind of regular maintenance is needed. We were questioning whether we should defrag the database files using windows defrag program and whether we need to run the defrag for Globals regularly? Should we be doing these routinely , occasionally or not at all?
Hello. I'm just getting started in DeepSee, and am also a newbie in MDX.
I am looking to create a pivot table that will be used to drive a bar chart. The chart will have product classes across the bottom, and two bars per class: a calculated measure to derive Net Sales for the specified period last year, and a straight aggregation of a standard measure for the same period for this year. Ideally, this period can be chosen by the user via filters on the dashboard, and it could be week, month, or quarter. So, obviously, it's the calculated field (and perhaps the entire MDX query) I need help with.
We don't often use SQL within our org, which is mostly due to the performance issue we experience due to the quantity of data we are reviewing.
Aside from the standard performance measures for non-Caché databases, are there any recommended approaches when querying large tables?
The table would have roughly 50M records, but there are not a finite amount of sub-nodes.
Hi all,
How to set username while take telnet from particular ip in cache 16?
Thanks,
Sansa.
Enterprises need to grow and manage their global computing infrastructures rapidly and efficiently while simultaneously optimizing and managing capital costs and expenses. Amazon Web Services (AWS) and Elastic Compute Cloud (EC2) computing and storage services meet the needs of the most demanding Caché based application by providing a highly robust global computing infrastructure.
Is there a way to add a scroll bar to a widget on a dashboard. I want to shorten the width of my bar graph widget but it causes the bar graph to be scrunch together. Also, is there a way to expand the width between each bar on the graph?
Thanks!
Hi!
We updated the DC a bit.
Member's answers
With this release, you can see the answers on the member's page too.

E.g. see the answers by Timothy Leavitt.
Post updates don't move the post to top
So we can fix the tags, spelling and make other updates to the post and it would not be moved to top anymore.
Now only new answers and comments move the post to the top of the feed.
RSS and other bug fixes
Now bugs for RSS feeds are fixed.
Also, Votes renamed to Rating and has the color indication now. Green means good!
Stay tuned for the next DC improvements!
One of my application needs to be able to receive and forward (almost) any kind of Email Message that will be thrown at it. I am able to do that using %Net.MailMessage and %Net.SMTP and %NET.POP3 classes from Caché code. So far no problem.
The challenge: for a specific reason I want to be able to persist and track those message within ensemble. Now, If I simply use %Net.MailMessage and persist it as a serial object within an ensemble message body, I get issues, most of them caused by maximum string length definitions of the %Net.MailMessage. So, unfortunately it is not that simple.
Hopefully somebody can help with this :
Using healthshare - Ensemble::: I have an HL7 message (ORU^R01) where I have an RTF file embeded into an OBX segment as what appears to be plain text.
example below :
How would I extract this file out and create an email and attach this RTF file as an attachment?
I have a standard text file that is coming out of a system new line delimited. Each document will have the same field structure each time.
ID: xxxxxxxxx Name: xxxx,xxxx Age: xx Sex: x OSU Wexner Medical Center Harding Hospital Treatment at 7/14/2016 10:39:34 AM % Energy Set 50 % Charge Delivered 255.4 mC Current 0.91 A Stimulus Duration 7.0 Sec Frequency 40 Hz Pulse Width 0.
Some folks here may find this interesting:
https://groups.google.com/forum/#!topic/enterprise-web-developer-commun…
Hi all,
I am looking for an implementation idea for displaying a large amount of data received from a webservice. This data are essentialy HL7-Message as a GlobalCharacter Stream and some metadata (status,processed,timecreated etc.).
Since I need sorting functionalities for those metadata a tablepane in a zen page seems to be suitable. i know there are different ways to provide data for the table but in this case it´s complicated to get them data fetched.
Consider the following steps
1. Get the data from webservice
2.
I am pleased to announce the immediate availability of Atelier 1.0
This is the debut release of our new Eclipse based plugin for developing code on Cache and Ensemble.
Highlights include
Atelier will be released independently of various server releases. The first versions of Cache and Ensemble that fully support Atelier are 2016.2 and higher. Facilities within Atelier itself will manage updating as we make newer versions available.
Is there an equivalent to Studio's GoTo feature so I can easily navigate to zXXX+4^ABC label when debugging code?
I had no luck finding it so far.
Thank you!
Dan
| Task | Studio Action | Atelier Equivalent | Atelier Keyboard Shortcut | See also ... |
|---|---|---|---|---|
| Display line numbers. | View > Show Line Numbers | Window > Preferences > General > Editors > Text Editors > Show line numbers | CTRL+, | Atelier Editor Features: Line Numbers |
| Code completion assistance | Immediately suggests completions as you type, unless explicitly disabled. | You must type CTRL+SPACE to invoke content assist. | CTRL+SPACE | Editor Content Assist |
| Navigate to a specific line number. | Edit > Go To, select Line Number | Navigate > Go to Line | CTRL+L | Atelier Editor Features: Line Numbers |
| Navigate to a routine, class, or class |
Is there a Studio Inspector equivalent in Atelier?

Hi, Community!
We put in production the new DC update today. With this update we fixed some bugs, like publishing drafts with proper date and RSS fix and introduced the new look to the member page.
Now member's page consists of Posts, Comments, and Favorites: e.g. this is the page of Alexander Koblov:
With this update you can see all the contributions and interests of your favorite author on DC.
Hope you like it!
Next weeks we prepare some new good updates! Stay tuned!
It feels like a couple of months since the last update (1.0.255) to the Field Test version.
Hello Fellow Caché Developers,
The purpose of this post is to ask for everyone's thoughts and input around the use of transient, SQLCalculated/Computed properties within persistent classes.
This approach allows for extra data values needed in SQL queries to be available without having to join to other tables.
Very simple/basic example to illustrate the topic:
Let's say I have a persistent class named ICDAutoCodeDefn to hold ICD Auto-Coding definitions, such as:
Class ApplicationName.DB.MedicalCoding.
Good afternoon!
I faced a problem with HealthShare complete transfer to another PC. I have on the old computer a lot of interesting developments and test projects, including widgets, developments on DeepSee and other stuff.
Would you please describe the details how one HealthShare installation can be correctly transferred to another PC. And that this should be done.