I use the 2012 version of the caché, and I need to export data in an Excel file, the point that seems to complicate is to use the dropdown list in the cell and then trigger a validation if I exceed an interval of two values.
Help me, by your seggestions, solutions Thank you
This series of articles would cover Python Gateway for InterSystems Data Platforms. Execute Python code and more from InterSystems IRIS. This project brings you the power of Python right into your InterSystems IRIS environment:
The plan for the series so far (subject to change).
Hi Community,
The new video from Global Summit 2019 is already on InterSystems Developers YouTube:
%SQLRESTRICT is a special %FILTER clause for use in MDX queries in InterSystems IRIS Business Intelligence. Since this function begins with %, it means this is a special MDX extension created by InterSystems. It allows users to insert an SQL statement that will be used to restrict the returned records in the MDX Result Set. This SQL statement must return a set of Source Record IDs to limit the results by. Please see the documentation for more information.
This is useful because there are often times users want to restrict the results in their MDX Result Set based on information that is not in their cubes. It may be the case that this information may not make sense to be in the cube. Other times this can be useful when there is a large set of values you want to restrict. As mentioned before, this is not a standard MDX function, it was created by InterSystems to handle cases were queries were not performing well or cases that were not easily solved by existing functions.
Intersystem Cache is a commercial operational database management system from intersystem, used to develop healthcare management, banking and financial, government sectors software applications.
InterSystems Cache is the world’s fastest object database. However, high performance is achieved only for transactional operations that have a significantly hierarchical nature
Hello community!
I have 2 productions A and B on the same IRIS instance sharing one operational database.
I'm looking for a simple and efficient way to send a message from production A to production B.
Any suggestion ? Could it be done through the database only?
And I wish you a happy new year!
Thanks :-)
I generated a REST API from a Swagger document with basic security.
When I send a request to that API, I now get an authentication error 401 always.
I entered a user api and a password and gave it the role %All.
I tried to call the API with the URL
http://solidara.net:52773/csp/solidara/get_components/solidara?username…;
What's am I doing wrong there?
Launching IRIS Using Docker
This brief document will walk through the steps to launch IRIS community edition using Docker on the MAC. For those new to Docker, the first two pages explain how to install Docker, and run some basic commands that will be needed to get the IRIS community edition running. Experienced Docker users can skip directly to page three.
Ease into the new year with the latest content from InterSystems Learning Services! Get info on:
Hi Developers!
This is the digest of new solutions and applications submitted to InterSystems OpenExchange in December 2019!
Math library for InterSystems ObjectScript
Author: @Peter Steiwer , OEX Profile
Sample for %JSONExport against a class with Many to Many Relationship
Author: @Peter Steiwer , OEX Profile
InterSystems ObjectScript zpm-registry
Server-side hosting service for ObjectScript packages installable via ZPM client.
Author: @Evgeny Shvarov, OEX Profile
Publisher: InterSystems Corporation
SUDOKU game written in InterSystems ObjectScript
Author: @Robert Cemper, OEX Profile
Sample DeepSee Portlets showing different ways to implement custom widgets
Author: @Peter Steiwer , OEX Profile
Advent of Code ObjectScript Docker Template
A simple template to craft Advent of Code with ObjectScript in InterSystems IRIS
Author: @Evgeny Shvarov, OEX Profile
Ingestion Speed Test
Shows how IRIS can ingest thousands or millions of records per second while allowing for queries on the same cluster. Works on a single IRIS instance or on an IRIS cluster on the cloud.
Author: @Amir Samary, OEX Profile
With this class, you could simulate Game of Life world that John Conway invented in 1970. We can see how John Conway universe evolves in our terminal
Author: @Jose-Tomas.Salvador, OEX Profile
Hi All,
I am planning on doing some maintenance in 2020, I was wondering if it is possible to run a query to get a log on when a DTL and/or Business Rules was called in HEALTHSHARE, the idea behind this is to do some cleaning and remove some clutter.
Your help or ideas are highly appreciated.
LW21
Is there a way to get a good performing index on a date field? I have tried various date property indexes and the query plan is always in a pretty high range. Below are query plan result values I have observed:
StartDate > '2019-12-01' --cost = 699168
StartDate = '2019-12-21' --cost 70666
StartDate between '2019-12-21' and '2019-21-28' --cost = 492058
The query plans above were for type %TimeStamp.
Hello All,
I am working on Files where I have to compare contents of two files and display result. e.g Suppose file1 contains data in Name and Roll form and file2 contains data in name and class form, so it should compare name from file1 and file2 and display those matching data(Name,Roll,class).
I have piece of idea about file system so any help would be appreciated. Thanks in advance.
Regards, Gunwant
Hi All,
I am getting server application error in salesforce outbound message after upgrading the HealthShare (from version 2015.1.0 to 2015.1.4). Please guide me to resolve this error.
The message in Ensemble has been retained for only 20 days, but the amount of data is still more than 300G. What should be done to reduce the storage capacity?
Hi,
I have written a procedure with the help of object scripting to export data to a csv file. There is more data than the csv limit.
Can anyone please tell me how to get the row count of csv file using object scripting, so that I can write an if condition and write to a second csv file.
Please find the code writing to the csv given below.
while (ind '= ""){
set row = ^CacheTemp(repid,"MAIN",ind)
use filemain write row,!
; Get next row index for MAIN report
set ind = $order(^CacheTemp(repid,"MAIN",ind))
}close filemain
}
Thanks
Jude
Hello,
I would like to catch an Adapter error in a try/catch. I have a problem with SMTP and SFTP adapter when the connection failed after 15 seconds.
Here is an example of my code for the SFTP adapter:
646Try{
... //creating a stream file character
//Trying to get a Status error if the PUTSTREAM doesn't work
set tSC = ..Adapter.PutStream("file.pdf",streamfile)
//If any error : throw
if $$$ISERR(tSC) THROW tSC
}catch Exception{
set pOutput= ##class(MyResponse).%New()
set pOutput.errorString = Exception.DisplayString()
}Hi Developers!
Happy New Year!
And I'm pleased to share the notes on the new DC Release. What comes?
See the details below, here we go!
Hey Developers!
Advent of Code 2019 is over! Thanks for participating in our COS marathon!
And now we're pleased to introduce the winners and distribute all the prizes!
Big applause goes to these winners:
Kevin An (w/ repo)
And here's the final Leaderboard:
Hi Team,
I want to save image/file using inter system iris web api.
I am sending file as Base64 formate in JSON object to api .and I want to save it at D/Images folder.
please refer below code that i was tried.
Obj.OrganizationLogoBase64--> has base64 value of image
Set decode = $System.Encryption.Base64Decode(Obj.OrganizationLogoBase64)
set file = ##class(%Stream.GlobalBinary).%New()
do file.Write(decode)
Hi Team,
I want to read image stored in "D:/temp/test.png" and then convert it to base64.
Hi Developers,
It's December the 1st! And this means that the Advent of Code 2019 has been started!
And you are very welcome to participate in the ObjectScript contest!
In the previous part of this series, we saw how to reference a web page that will enhance our dashboard experience. Now we will look into referencing data that is already in our cubes.
In this example, we will be referencing the controller object and we will be extracting data from it. This data will then be displayed as text in our Dashboard. In Part 5, we will show how to incorporate this data into other charting libraries.
Hi Community,
Great news for all Global Masters lovers!
Now you can redeem a Certification Voucher for 10,000 points!
Voucher gives you 1 exam attempt for any exam available at the InterSystems exam system. We have a limited edition of 10 vouchers, so don't hesitate to get yours!
I am trying to use the %ListOfDataTypes functionality, but am hitting a limit of 50 characters for each entry, when being used in a Web Service. Is there a way to increase the number of characters that can be used in the %ListOfDataTypes through a web service?
Hi!
I am wondering how I can test that my application can be installed through ZPM before I publish it to Open Exchange. How can I accomplish this?
Peter
Hello team,
I am trying to do a basic read file of HL7 messages. Need to count how many FT1 segments are there in each file and how many messages are in each file.
Any help will be appreciated. I have the stream object.
Just need to loop through the stream and get the info in some way.
Any help will be appreciated.
Thanks,
Jimmy Christian.
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.
Hi,
The class %JSON.Adaptor is very convenient,
I wonder if anyone faced the following scenario using it-
Exporting an object, that has a many to many relationship, and getting the details of the related objects.
For example, if we have three classes - Teachers, Students, and an intermediate class TeacherStudent .
The classes extend %JSON.Adaptor, and we would like to open a Student object, use %JSONExport, and get a JSON
That includes the details of the student and all the teachers that teach the student, something like:
