I'm looking for some existing solutions to compare 2 global structures.
- by subscripts
- if subscripts match then by content.
Caché
InterSystems Caché is a multi-model DBMS and application server
Posts: All
Sorting: By Date
Period: All
Last answer 1 days ago Last comment 17 hours 3 min ago
I'm looking for an efficient way to use in Studio "Search in Files"
typical setup
- search in all A*.MAC
- look for " O " OR " O:" or " OPEN " or " OPEN:" ; it's long an short notation also with Postcondition
- the Filter didn't help
Last answer 1 days ago Last comment 1 days ago
I try to set a cookie with expire time like this:
Last answer 1 days ago Last comment 1 days ago
In this article I'll show you how you can easily convert between many different document formats, these to be precise:
- in: html, odt, doc, docx, rtf, sdw, txt...
- out: html, odt, docx, rtf, pdf, txt, tex, xhtml...
and many more, check out this table. We'll use LibreOffice as a conversion engine.
Last comment 1 days ago
Prmoetheus is a really good to combine measures, and export them in graphical dashboards
I would like to write some a caché exporter for Prometheus, that will allow to expose some metrics of the database, or even some metrics of my own
Did anyone already tried ?
Thank for the answer
Last answer 1 days ago Last comment 11 October 2016
Hi everyone,
I've encountered this annoying issue so many times before, if any one also encounter this issue, please share here if you have any solution.
So, I've been working on a web service project using HealthShare 2015. Sometimes I have to set a debug target to a csp file to debug it. If I pause the debug process about 3 minutes above or so (to examine an object, variable, etc..) the studio will hang.
Last answer 2 days ago
When using $SYSTEM.Status.DecomposeStatus(tSC, .tErrorList) in ObjectScript to get the lsit of errors (I need to do this so that I can generate a custom JSON with the error messages) what is the type of tErrorList returned and how to intialize?
Last answer 2 days ago
Backup, Best Practices, Deployment, InterSystems Data Platform Blog, Mirroring, System Administration, Tips & Tricks, Caché, Documentation, InterSystems IRIS, InterSystems IRIS for Health
In this post I show strategies for backing up Caché using External Backup with examples of integrating with snapshot based solutions. The majority of solutions I see today are deployed on Linux on VMware so a lot of the post shows how solutions integrate VMware snapshot technology as examples.
Last comment 2 days ago
My project need to restore the previous part of the log, and I use the rountine "^JRNRESTO" and filter. After recovery completed, the table structure is restored, but the table data is not restored， also unable to insert data into the table.
The filter is defined as follows：
Last answer 3 days ago Last comment 2 days ago
I am trying to make architecture for my project. And for it, it needs to make list property in which there is list of objects of another table, the data must be unique, therefore I make sql-query to check objects of another table if it is used or not, but I can't make sql-query to check elements in list in property with elements of another table. Can you help me? In property ID of object is used.
Last answer 2 days ago Last comment 3 days ago
I'm playing with Cache web apps (CSP pages) and local dev . . .
Last answer 2 days ago Last comment 2 days ago
I'm having trouble with a server printer where nobody can open a particular device. I've seen all over documentation that you can't open a device if another process already has it open, but I haven't been able to find out what process has a device opened already.
Last answer 2 days ago Last comment 8 days ago
Class Queries in InterSystems Caché is a useful tool that separates SQL queries from Caché Object Script code. Basically, it works like this: suppose that you want to use the same SQL query with different arguments in several different places.In this case you can avoid code duplication by declaring the query body as a class query and then calling this query by name. This approach is also convenient for custom queries, in which the task of obtaining the next row is defined by a developer. Sounds interesting? Then read on!
Last comment 3 days ago
does Health Connect have an out of box setting to send some type of "Keep Alive" packet? This is for a TCP connection. I have a vendor that will disconnect from the engine if there is a 2 hour idle time. would like to send something across every hour (if its idle) to prevent the disconnection. I'm assuming this may be something custom that needs to be created, but thought I asked the community first.
Last answer 3 days ago
Is it possible to use a class parameter in class query?
Example:
Class SomeClass
{
Parameter SOMENAME = "Name1";
Query SomeQuery() As %SQLQuery
{
SELECT ID || ..#SOMENAME || Name FROM Table
}
}
Last answer 9 October 2017 Last comment 3 days ago
Databases, Debugging, DevOps, Globals, JSON, Microsoft Windows, ObjectScript, SQL, Caché, Job Opportunity
An exciting position has arisen for an Application Support Analyst 3rd Line, in an established support team. The role will suit candidates looking to work in the software industry who want to provide good customer service, enjoy finding solutions for problems and are enthusiastic about software and technology. http://codas.com
Databases, Debugging, DevOps, Globals, JSON, Microsoft Windows, ObjectScript, SQL, Caché, Job Opportunity
An exciting position has arisen for a Junior Application Support Analyst in an established support team. The role will suit candidates looking to enter, or are at the start of their career in, the software industry who want to provide good customer service, enjoy finding solutions for problems and are enthusiastic about software and technology. http://codas.com
I have SQLCompute with SQLComputeCode on a couple of Properties in my class.
These work fin when I insert/update via ObjectScript or SQL from the ManagementPortal.
However, if I insert (create new record) via my C# app using the Caché ODBC DLL the SQLCompute is ignored, it does not run.
Is this expected InterSystems Caché behaviour? We are on latest IRIS platform.
Last answer 4 days ago Last comment 3 days ago
Hello everyone,
I try excuting a SQL Query like this SELECT ID, CompanyName FROM Company WHERE CompanyName LIKE 'condition'
But if I want to search CompanyName have special char %, ex: '100% Co' , 'Group of Mr.%', 'The %TaxProp'...
How can I take % to query, with
Last answer 29 November 2018 Last comment 3 days ago
In the previous article, I have demonstrated a simple way to record data changes. At this time I have changed the "Audit Abstract Class" which is responsible for recording audit data and the data structure where the audit log will be recorded.
I have changed the data structure to a parent and child structure where there will be two tables to record the "transaction" and the "fields its values" changed on that transaction.
Take a look at the new data model:
Last comment 3 days ago
Pretty straight forward.
I'm tempted to hard-code ISO-8859-1 inside my VSCode extension when working with CSP because this seems to be the encoding used by default, but I need to know if there's any other possible configuration. So can you share your experience when working with CSPs? Like issues with encoding, discoveries regarding it, workarounds etc.
Also, can someone tell me if it's possible to work with UTF-8 encoded CSP files using Atelier without breaking the encoding of the output file?
Last answer 4 days ago Last comment 3 days ago
Hi guys,
our end users in Prague, Czech republic, are seeking for new members of their teams. They are large and first class hospitals who are in the process of improving and implementing Ensemble based systems (with option to move to InterSystems IRIS in the future). For this they're seeking motivated team members (analysts, developers, devops, testers) who can contribute to team's success. These are long term opportunities, open to everyone - students, fresh graduates or senior experts.
Last comment 4 days ago
Hello good afternoon!
We're testing a REST Operation, to View Devices using OneSignal API
We are sending the request from Production's Operation Test tool, using the following code:
.png)
What happens is that it tells us error of SSL Configuration:
Last answer 4 days ago
Hi,
It turns out that on windows if you run a command with a windows command file you need to escape the % character as %%
In my case I could test freeze and thaw calls at the command line successfully as
..\bin\cache -s. -U%SYS ##Class(Backup.General).ExternalFreeze()
...but when my freeze script ran it would fail.
it turns out that a single '%' is striped when run in a windows command file, and it must be escaped as '%%' windows gets:
Last comment 5 days ago
InterSystems IRIS supports a unique data structure, called globals, for information storage. Essentially, globals are persistent arrays with multi-level indices, having several extra capabilities—transactions, quick traversal of tree structures, and a programming language known as ObjectScript.
I'd note that for the remainder of the article, or at least the code samples, we'll assume you have familiarised yourself with the basics of globals:
Last comment 5 days ago
Hi,
I am trying to use the %Net.HttpRequest Class, and the request has to pass through a proxy server that requires authentication.
I am usually able to do that by using the following code:
Last answer 5 days ago Last comment 5 days ago
Distributed Data Management, ECP, InterSystems IRIS Experience, System Administration, Caché, Documentation, Ensemble, InterSystems IRIS
During migration from Caché to IRIS I can preview a situation where some instance
have migrated to IRIS while others are still on Caché.
For various reasons this may be in place for some weeks or even months as the big bang isn't feasable.
So far I found a lot of statements related to mixed endinans,
but nothing related to cross operation beween IRIS and Caché.
?? any hints ??
?? any experience ??
Last answer 6 days ago Last comment 6 days ago
Hi,
I believe the healthshare Debug module did this (if you added it) but I no longer have access to Healthshare to look so am asking here.
Suppose I have;
Set fruit="apple"
set person="john"
d ..Something(fruit, person)
quit
ClassMethod Something(objs...) {
; Names of variables passed in
}
In side "Something" how can I see the original name of the variable passed in (i.e. know the variables passed in were called fruit and person and not just their values).
Last answer 3 September 2019 Last comment 4 September 2019