What is FHIR and How to work with FHIR in Cache.How to we write a web services using FHIR.
Please give the Example.
InterSystems Caché is a multi-model DBMS and application server. See more details here.
The dataCombo property columnHeaders is a comma-delimited list of column headers displayed in the dropdown list.
Comma is a delimiter.
But, if I want add comma to columh header, for instance "House number, apartment" - this is value for header of one column.
How can I escape comma in this case?
"House number\, apartment" - is not working.
Hi
Does anybody know what happend to %SYS.GSET routine in Cache 2016 ?
In Cache 2013 it still existed, I didn't find anything about it in Cache realese notes 2014 and 2015.
Uri
tl;dr I have discovered that using $THIS in a very specific way will make persistent objects go stale.
I found that it only happens when using $get on an array that contains the OID reference of $THIS. I assume that this is an unwanted feature and have raised a WRC. The problem can be recreated following the steps below, I have also posted the workaround that I am currently testing and looks to be working fine.
1. Create a persistent class...
Class Test.Store Extends %Persistent
{
Property SomeValue As %String;
Method SomeMethod()
{
//this will cause $THIS to go stale in this process
if
{
Property SomeValue As %String;
Method SomeMethod()
{
//this will cause $THIS to go stale in this process
if
Hi all,
I need to create a routine to modifiy some values in a global.
My first attempt was:
// Search the first position of Messages
set pos=$Order(^Ens.MessageBodyD(""))
while(pos > 0){
// Get the class name
set clase = $Order(^Ens.MessageBodyD(pos,1))
if (clase="MensajesRestResponse")
{
// Do the convertion
}
set pos = $Next(^Ens.MessageBodyD(pos))
}
set pos=$Order(^Ens.MessageBodyD(""))
while(pos > 0){
// Get the class name
set clase = $Order(^Ens.MessageBodyD(pos,1))
if (clase="MensajesRestResponse")
{
// Do the convertion
}
set pos = $Next(^Ens.MessageBodyD(pos))
}
but if I use a *.bas file (cache basic script), I'm not able to use these commands ($Order and $Next) and I don't know how to translate theses words.
please, could the comunity help
I worked through the Community for proposals to provide end users
in an easy way with data formatted as EXCEL sheet.
There is a great article Tips & Tricks - SQL to Excel
there's an important message embedded: "EXCEL can interpret HTML tables and display them as usual"
Where's the light weight export to EXCEL ?
Good old CSP is well equipped to produce HTML tables accepted from EXCEL as input.
With modern Browsers you don't even need <head>and <body> tags.
So the required code around your SQL result set is really slim.
And you are free to add any formatting you need either by HTML or in SQL.
The
Hi,
I have been working on a csp page and trying to export it to excel using the standard activex object. I would like to know if it is possible to export the table on the page with formatting to excel? Thank you in advance for any insight.
Thank you,
Subba.
This post will guide you through the process of sizing shared memory requirements for database applications running on InterSystems data platforms. It will cover key aspects such as global and routine buffers, gmheap, and locksize, providing you with a comprehensive understanding. Additionally, it will offer performance tips for configuring servers and virtualizing IRIS applications. Please note that when I refer to IRIS, I include all the data platforms (Ensemble, HealthShare, iKnow, Caché, and IRIS).
[A list of other posts in this series is
Hello everybody,
We have a piece of Caché software which calls an external utility using $zf(-1,command). It works fine under Linux, but under Windows an external process occasionally hangs (due to some internal problems out of the scope here) and need to be killed programmatically. Having PID, it's easy to kill a process. If a Caché process is called with JOB command, the caller can easily get its PID from $zchild, but alas $zf(-1) does not seem to return the similar info. Is it possible to get it somehow?
This is the first article of a series diving into visualization tools and analysis of time series data. Obviously we are most interested in looking at performance related data we can gather from the Caché family of products. However, as we'll see down the road, we are absolutely not limited to that. For now we are exploring python and the libraries/tools available within that ecosystem.
The series is closely tying into Murray's excellent series about Caché performance and monitoring (see here) and more specifically this article.
Disclaimer I: While I will be talking in passing about the
I was wondering if there was a way to if the user is using Studio and changes a file to get the users name and have a function run when the file is changed.
Ive got this working for .int files but not for .csp or .js or .css or any other kinds of files.
When we edit code we are logged in to the Cache backend’s server through Studio by using an iPaddress (which is on our network).
I know now there are concepts of file locks and logs for when certain tasks are ran or when a user maybe edits a file
I was thinking there might be a way to get that Info because of the fact of being logged in through
Project related quality assurance efforts have revealed a number of concerns for the current release of 2017.1.0 and 2017.1.1 on all OpenVMS platforms. In certain situations, the impact can be severe. InterSystems will address these issues with the upcoming 2017.1.2 release, and in the meantime, will remove all 2017.1.x kits for OpenVMS from our Download Servers.If you have immediate needs correcting existing deployments of this version, please contact the InterSystems WRC (support@intersystems.com).
Explain data expression and selection expression?
Hello all,
In my ZEN login page, I found a way to bypass the submit button and force a user to click on the Sign In button, thus forcing the code to call my OnSubmit(), like this:
<!--ondefault="return true;"--><!-- this removes the ability to use "return" to login - forces button click to login -->
<loginForm id="loginForm" ondefault="return true;">
<text name="CacheUserName" />
<password name="CachePassword" />
<!-- the submit button is special, and submits automatically without checking first -->
<!--<submit caption="Login" id="login" /> -->
<button caption="Login" id="login" onclick="zenPage
After Microsoft updates my Cache Cube has stopped working. I checked my cconsole.log and corrected my journaling errors. However, I still receive Native Code 450 errors but now I am receiving Network Errors. However, now there do not appear to be any errors logged in my cconsole.log.
I have reinstalled Cache Cube multiple times without success. Can anyone please provide some assistance?
Thank you,
Nancy Grimes
903-786-2590
Hi!
When trying to receive xml response
set sc = ##class(%XML.TextReader).ParseString(str,.reader)
I'm getting error bellow:
Invalid character (Unicode: 0x1A) while processing Anonymous Stream at line 2 offset 281
How I can ignore this error? Thank you.
In $system.SQL.Shell(), it would also report the number of global references for a given query.
Is it possible that I could also get this statistics from the %SQL.Statement interface when I launch a dynamic sql?
Thanks.
Quite a few enhancements have appeared over recent months in QEWD for easing and simplifying the creation of REST-based services. It's now even more slick and powerful, allowing you to very quickly create very high-performance, highly-scalable REST (and Web) services that make use of Cache.
I've therefore updated the training presentation deck (Part 31 on developing REST Services with QEWD). It describes all the new features with worked examples. See:
https://www.slideshare.net/robtweed/ewd-3-training-course-part-31-ewdxp…
Here's one way to determine if a class is mapped (i.e. it is in a package whose definitions come from a database other than the default code database for the current namespace):
SAMPLES>w ##class(%Library.RoutineMgr).IsMapped("Cinema.Film.cls")
0
SAMPLES>w ##class(%Library.RoutineMgr).IsMapped("%iKnow.Objects.Source.cls")
1
SAMPLES>If you pass a by-ref second argument to IsMapped you can also discover what database the class definition is stored in:
SAMPLES>w ##class(%Library.RoutineMgr).IsMapped("%iKnow.Objects.Source.cls",.db)
1
SAMPLES>w db
^^c:\intersystems\ens171\mgr\cachelib\I want to retrieve all the names of classes which are %Persistent in a namespace by COS.
Any suggestion, Thanks.
Hyper-Converged Infrastructure (HCI) solutions have been gaining traction for the last few years with the number of deployments now increasing rapidly. IT decision makers are considering HCI when scoping new deployments or hardware refreshes especially for applications already virtualised on VMware. Reasons for choosing HCI include; dealing with a single vendor, validated interoperability between all hardware and software components, high performance especially IO, simple scalability by addition of hosts, simplified deployment and simplified management.
I have written this post with an
Has anybody defined their own Cache ObjectScript (COS) commands and symbols? Is it even possible? For a list of currently used commands and symbols please use the following link.
http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=RCOS
TablePane1 is populated when a %ZEN.Component.button on a form is clicked from a JavaScript onclick method.
<button caption="Search" onclick="zenPage.onSubmit();"
TablePane1 also has a JavaScript onselectrow method zenPage.onSelectRow() that gets the currently selected RowID.
onselectrow="zenPage.onSelectRow()"
This JavaScript method gets the RowID and feeds it into ClassMethod GetAuditLogs(ByRef pRowId) [ ZenMethod ] to get the audit events for that record.
ClientMethod onSelectRow() [ Language = javascript ]{ var table=zenPage.getComponentById('table1'); var dataRow=table.getRowData(
I'd like to access and view the soap log. Apparently there is a global for that (^ISCSOAP) (http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY…), but insofar I have been unsuccessful finding the exact cache command for viewing the soap log or changing it so that it logs both incoming and outgoing traffic. Can anyone enlighten me?
I.e. I am trying stuff like:
set ^ISCSOAP("Log") = io
write ^ISCSOAP("Log)
but those don't work.
I use %SQL.Statement. The original column names are not contained in the metadata.
Sample query:
SELECT column1->name as name, column2 age FROM sample.table
How to get:
- column1->name
- column2
Hi
I've got a Service that get ACK Messages originated by another system.
I want to get the details of a Message when the ACK is CE (Failed Message).
I don't know whether this is the best approach but, at the moment, I have a DTL and I would like to search the Cache Database for a Message with the Control ID on the ACK in the MSA segment.
Any help with this would be great.
Tks.
Please excuse my ignorance. I am trying to identify what areas would be best to review in the System Dashboard (for Cache 2010.2) for performance issues with the database. It seems to be running slower than usual, but I am trying to find out the best way to go about identifying what the issue is.
The following are captures from the System Dashboard.
As always, thanks a lot for your help.
Hi,
I am new to coding web services and trying to connect to an API that returns its format in xml or json.
I have a class as follows.. when I run I get back a 6059 in my status - Unable to open TCP/IP socket to server
Can someone help me identify what I am missing? Thanks
Class Common.WebDownload Extends (%RegisteredObject, %XML.Adaptor){ClassMethod Connect(){ Set aa=##class(%Net.HttpRequest).%New() Set aa.Server="https://www.actualwebaddresshere.com" Set aa.Location="/service/actual location path and my API key here/" Set aa.ContentType="text/xml" set bb=aa.Get() breakHello!
Intersystems is a fascinating yet niche marketed. We are using it, but we struggle to find good developers to join us to work on Caché or Ensemble products.
Who is interested into joining us? the job will be in Geneva, Switzerland!
For more information, please drop me an email to: erika.stegagnini@ch.randstad.com or call me directly +41 58 2015408.
Thanks! Erika
Hi all, I'm running into an issue with the installation, it seems like almost everything is working alright but upon trying to actual access the Management Portal, the site cannot be reached. I've noticed that the terminal indicates that Sign-on is inhibited.
To add some context, I've installed Cache following the Unix instructions for MacOS (El Capitan).I can share the log or any other info that may be helpful.Here is some of the terminal output from the installation if it would prove at all helpful.