Hi Community! Here is a digest of the Developer Community postings in December 2019.
Most viewed
646Ease into the new year with the latest content from InterSystems Learning Services! Get info on:
- How to get hands-on with Docker containers and InterSystems IRIS®
- Designing healthcare productions with InterSystems IRIS for Health™
- A new certification exam for InterSystems IRIS Core Solutions Developer Specialists
- Improved UX with InterSystems documentation
Hi Developers!
This is the digest of new solutions and applications submitted to InterSystems OpenExchange in December 2019!
New applications 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:
Try{
. //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.Hi Developers!
Happy New Year!
And I'm pleased to share the notes on the new DC Release. What comes?
- New design for Articles
- Voice over for Articles
- Format painter feature for editor
- New private messages informer, Github profile and other minor enhancements
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.
Why use this?
The controller object contains data from an MDX result set.
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.
After that, If I still try to click to the studio, the pop-up will appear to ask if I want to restart the
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.
Does anyone NOT use a debugger? I can't remember the last time I did. It's not because I don't dislike them, I just don't need to use them. The main reason for this is because I have a certain development methodology that either produces less bugs, catches them at a unit test level, or makes tracking them down much easier.
Here are my tips...
1. Write your own COS cheat-sheet.
This is mainly for anyone that is new to COS. One of the biggest bug hazards is not knowing how certain commands and functions work.
Hello All
Could someone help me in the details of the ODBC connection I need to connect to the Healthshare Cache databases for the CMC application?
Much appreciated in advance
Andrew
Hi Community!
Thank you so much for being with InterSystems Developer Community yet another year!
We want to know how helpful the Developer Community is for you today.
Could you please go through this short survey which will let us know what do you think and what could be improved.
➡️ Developer Community Survey 2019 (4 min)
We wish you a Merry Christmas and a Happy New Year! ✨
Sincerely,
Your InterSystems Developer Community Team
Hi Developers!
Often we need to use relatively small arrays with constants, static arrays in algorithms, etc where we need to do something with each element of an array. There are several ways to deal with it in ObjectSctipt.
Previously I used to use globals, locals, PPG for this but not so long time ago figured out that %List is a way too handy.
Indeed, suppose we have an array of months and need to set up and use it in our code.
Is there anyway to improve the performance of the display of DeepSee dashboards?
It takes minutes to do the cell calculations of computing the axis members.
Any direction or help would be appreciated.
Thanks,
LG
How to calculate median and mean in SQL?
Merry XMas and Happy New Year!
Hope to hear from you next year!
Hi Developers!
Recently we updated the look and feel of articles on DC:
The font is bigger, with no ads on aside.
Articles look like that now:
The intent was to make reading process for articles more focused cause sometimes we want to share a deeper thought with article and this needs more concentration and less distraction.
Do you like it?
Share your thoughts, please?
