InterSystems Caché is a multi-model DBMS and application server. See more details here.
If I have defined a class query in one of my classes and I want to use that query from a method of another class, what are the pros and cons of using the %SQL.Statement interface versus the %Library.ResultSet interface?
I believe %SQL.Statement is the newer interface.
So if the old way is:
USER>s rs=##class(%Library.ResultSet).%New("%Library.File:FileSet")
USER>s sc=rs.Execute("c:\s\","*.txt")
USER>w sc
1
USER>while rs.%Next() {w !,rs.Data("Name")}
...then the new way is:
Hello!
I'm trying to run a simple SQL query in atelier but it complains about the manager. I'm not sure if this is the best way to do it but here is what I got so far:
In the documenations at this location http://docs.intersystems.com/enscomm20152/csp/documatic/%25CSP.Documati…, the normalize method applies normalizaion for text using the defined manguage and dictionary.
I want to normalize my iFind queries. How can I use the normalize method ? any code sample ?
I want also to delete properly the iFind index. Deleting all the rows in the table is sufficient ?
When quering iFind is it possible to get also TFIDF scores ? any code sample for this ?
Thank you for the help.
I have a tablepane in my Zen page that is tied to a class query. When the page first loads, the table is empty. A button onclick event causes the tablepane query to execute and load query results into the table. I want an onchange event from a datalistbox to clear the tablepane so that it looks empty as it was when the page first loaded. I have had no luck fiddling with javascript in the datalistbox's onchange.
A simple and rather automated search portal leveraging iFind capabilities for rich text search in 2016.1. It has simple faceting, result ranking, highlighting of search results etc and just works off any table you point it to that has an iFind index by appending ?t=MyPackage.TableName to the URL.
See also https://github.com/bdeboe/isc-iknow-ifindportal for more details and the latest version.
I need to perform additional checks before Cache user logins (let's say in a terminal for simplicity) and allow access only to those, who passed them. How do I do it?
After reading about delegated authentication in docs I created this ZAUTHENTICATE routine:
ZAUTHENTICATE(ServiceName,Namespace,Username,Password,Credentials,Properties) PUBLIC { #include %occErrors #include %occStatus quit $$$ERROR($$$GeneralError,"No access") }and set Password and Delegated as Allowed Authentication Methods in %Service_Console (it's a windows install)
Expected result: no one can login via the terminal
I would like to know how to get the key value from a dropdownmenuitem placed on a navbar.
I have tried to get from onselect and onchange events of the template class, but it didn´t work.
According to the snapshot attached I am trying to retrieve the values from 'action-1' and 'action-2'.
I have attached a ZIP file with a snapshot which value I am trying to retrieve and example classes.
Thanks.
Hi,
Can a Cache Mirror be used in the cloud ? (ie stand up a Primary and Backup member instances in a High Availability Cache Mirroring configuration)
I'm investigating the validity of this configuration, because I was of the understanding that this may not possible due to these cloud servers not (typically) having fixed ip addresses, which interferes with the Virtual IP settings for the mirror set.
Is this correct, and if there are workarounds (like Load Balancing ?) can I have details on how this should be configured ?
I just saw this new posting by Mike Kadow on the "Caché, Ensemble, DeepSee" Google Group announcing the availability of his new book, "Caché and MUMPS - Part II"
There's also more information about it at his site http://www.cosmumps.org/
Hello good afternoon.
It is possible to change the background string " output " of the studio?
I would like to add a line in green or red line (TDD).
I am pleased to announce the next 2016.2 field test kit, 2016.2.0.609.0.
This is a relatively light update with only a few dozen changes from the previous field test, spread out across all areas of the product. Also, in a break from the recent past, this update doesn’t contain any new fixes to problems found in the field.
Please download the kit and give it a try; the latest field test of 2016.2 is available HERE. And, as always, we welcome your feedback.
Steve Glassman, Director of QD
There have been a few use cases recently within InterSystems where we've needed to connect to Caché-based web services from PHP. The first of these was actually the Developer Community itself, which uses web services as part of Single Sign-On with other InterSystems sites/applications. The following example demonstrates how to connect to a Caché-based web service (particularly, the web service in the SAMPLES namespace) from PHP, using password authentication.
When developing or maintaining Caché Objects applications, or even ones written in plain COS code, it's sometimes useful to investigate dependencies. Yuzinji is a tool that analyzes the Caché class dictionary plus the COS code within methods and routines, then feeds its results into Structure101g Studio.
Find out what sets the InterSystems Document Data Model apart in the industry.
February 25, 2016 – Alert: Incorrect SQL Results InterSystems has corrected a defect that can cause incorrect results for certain SQL INSERT, UPDATE, and DELETE statements.
This defect is present only in Caché and Ensemble 2015.2 and HealthShare distributions based on them. The problem affects all platforms.
Incorrect results occur only when two or more of these statements are nested within each other.
The example below demonstrates one possible way for this problem to happen:
When my COS code is executing in a Caché process it might want to interact with the host operating system. For the purpose of this post I'm focusing on a Windows host, but much of it applies to other host OS platforms as well.
A common example of host OS interaction is when my process wants to read from or write to a file. What credentials will apply when Windows is checking whether or not to allow me access to the file?
To answer that we need to consider another question. How did our process start?
Hi
In studio when I right-click a package there is no option to delete it.
Also how do I upload an image to this post without linking to an external site?
If you've got more than one developer on a project, do you each work in your own namespace? Or do you all use a common namespace?
Through my work at George James Software I have encountered many different Caché and Ensemble development setups. At risk of over-generalizing, the older and more established users of InterSystems technologies seem more likely to have all their developers working in a common namespace, whereas the newer 'converts' tend to favour giving each developer their own namespace.
Hello,
This package may be of interest...
Link: https://github.com/litesolutions/cachedb-import
I have programmed this over a hunch, in order to facilitate the retrieval of source code from a Caché installation. It makes use of the Java API provided by Caché.
Right now, I use it as a means to salvage sources in order to analyze them using the SonarQube plugin I develop for my employer. Unfortunately this plugin is not open source.
I am calling for help here, on two fronts:
RESTful API Call From Cache to Particle.io Electron
Tom Fitzgibbon | Multidata | 212-967-6700 x537 | tom@mul.com
Summary: Simple Blink Tutorial for Particle.io Electron Device from Cache
Electron device is a tiny ARM processor ($40-$60) that connects to Particle’s world wide leased 2G/3G network (about $3/mo) and runs off an included LiPo battery. Using Cache’s %Net.HttpRequest you can send/receive data, control hardware and read sensors.
Step by Step (about 1 hour)
1) Get the Electron from store.particle.io.
2) Set up the Electron from setup.particle.io.
I am pleased to announce the next 2016.2 field test kit, 2016.2.0.605.0.
There are about a hundred changes from the previous field test kit, including the following fixes to problems found by those using the kits in the field:
The cdirectmgr utility will no longer be included with product distributions beginning with the Caché 2016.2 release . This was an older VB application (predating the Caché cube) which allowed users to define server connections for Visual M/Caché Direct applications. As VB 6 is no longer supported by Microsoft, we will no longer ship this component. The same functionality is already available from the cube utility.
It is also posted in Compatibility blog.
Zen Reports has offered multiple choices for direct printing including use of Adobe Reader or Foxit reader. Recent changes in Windows 10 and in the readers themselves have made it no longer possible to invoke these readers from background processes in Windows 10 and all future versions. Because of this Zen Reports will no longer support printing with these tools on Windows 10.
Windows 10 support was added for 2015.1 and 2015.2. On Windows 10, the only option for direct printing with Zen Reports will be Qoppa JPDFPrint.
Good morning people.
The use of TDD is currently being reference for software delivery more confiabilitade and quality.
At the company I work developing web applications , we create tests for method class in a deteminado package and running the steps that the documentation recommends:
1 export the tests classes to a predefined folder.
2- And running the test ( D ## class (% UnitTest.Manager ) .RunTest (,"/nodelete" )
It is a lot of work to do the export and run these tests would have a resource that we could only run the tests without the need for export ?
Hello!
I'm trying to use iKnow but I get the following error "No iKnow-enabled namespaces found" in the Management Portal.
It was working on the 2015.2.2 version but now on 2016.2.0 it doesn't. I very new to Caché and iKnow so it's probably a simple problem.
I was able to create a iKnow domain using the terminal and I can view it in the learning portal (http://localhost:57772/csp/sys/exp/_iKnow.UI.IndexingResults.zen).
What can I do to make it work in Atelier? I've tried authenticating with SYS:SYS and USER:USER but neither seem to have any namespaces.
Very thankful for any help!
I have been meaning to make a post about this topic for a few weeks and the other day an issue came in through the WRC about it so it seems this is a conversation we should be having. I want to begin by taking a few moments to explain "Why Atelier" then we can talk about what this means in the general sense for Studio and Atelier and Caché developers. We have wrestled with what to do with Studio for years. When I moved to Product Management in 2008 this was already a "thing". At the time we could not reach a consensus. Some felt Studio was fine as is. Others wanted to investigate a path
Is the default language (i.e., $$$DefaultLanguage, which is used as the basis for localization with $$$Text/etc. at compile time) always "en" for new Caché installations, or could it be different? How is this determined? I don't see an option to select a language during Caché installation.
Also, is there a supported/preferred API for setting the default language? Looking at %occMessages.inc, one option would be:
Set $$$DefaultLanguageNode = "en"
But I'd expect there to be a classmethod for this somewhere (and haven't managed to find it yet).
Attached is an example of a web service client that can be used to do a lookup against the CMS NPPES database to validate and retrieve information about a given National Provider Identification (NPI).
I'm working on a proposal for a deployment tool development project and I was wondering if anyone had any experience with such a thing.
We use Healthshare and implementations for new clients are tedius and lengthy. Lots of ensemble service, registry value, lookup tables, namespaces and other things have to be created and configured.
I would like to create a Zen or CSP page based deployment tool that can do all this with a few parameters and some custom code.
Has anyone done this? What are some pitfalls you ran into? Any unique ideas you included? Other general thoughts?
InterSystems is pleased to announce that Caché and Ensemble 2015.1.4 are now available as maintenance releases.
For a complete list of the corrections in 2015.1.4, please review the release notes.
Caché and Ensemble 2015.1.4 are available today for the same platforms as 2015.1.3.
The complete set of supported platforms, including specific point releases and/or patches, is detailed in the Supported Platforms document.