Hello Community,

we want to use a specific index on our sql-class.

The index we want to use is called "iFilter".
Currently we use the following technique of ignoring all other indices because the automatically chosen index is always too slow. 

SELECT TOP 100 d0.

I really love documentaries! Last weekend I was watching a Netflix documentary called This is Pop, because it was Analytics Contest time and I thought: Why not creating a pop song analytics with InterSystems Iris?

The first challenge was the database. I found on Data World project a CSV file with the Billboard hot 100 songs from 2000 to 2018, created by "Michael Tauberg" @typhon, that fits perfectly.

I was talking to @Henrique Dias and he gave me the idea of using Microsoft Power BI for good looking report with charts.

Which genres were most popular between 2000 and 2018?

Hey Community,

"Wonders of the World" journey on Global Masters is over - thank all for participating! Now it's time to announce the Raffle Winner!

🎉🎉🎉 Congratulations to @Goran Trbojević - the winner of the Nike Backpack! 🎉🎉🎉

His entry was randomly selected among 16 participants who completed ALL the challenges in the "Wonders of the World" campaign. 

And one of the challenges was to 📸 upload a selfie with one or two words that you associate with InterSystems. 
Just look at these exciting photos!
Your words for us are SO inspiring!
Thank you all who gave us your permission to share your photo on DC and social media:

Have you heard about some restrictions in cookies for tracking visitors to your sites?

One of our clients asked me about how to know really count of visitors.

Their site works on WordPress framework, hosted on classical NAMP hosting.

They can see some statistics from Yandex Metrika conter, but we was not sure about full coverage.

We gave him the AWStats, it takes data from Apache log files on hosting.

But there were no filter of robots and hearbeat systems such as UptimeRobot or Search Engines indexing robots.

I regret getting a late start in the InterSystems Analytics contest. I had tried a couple of times before to use Analytics, but I had not gotten too far. I have been recording financial transactions in Excel workbook ever since I had to retire Microsoft Money. Since my iris-for-money was not fully functional, I created a worksheet per account I was tracking. I had developed a CSP page in iris-for-money to import transactions by reading a CSV file. I realized this process requires escaping many characters that can cause the process to fail.

Hey Developers,

This week is a voting week for the InterSystems Analytics contest! So, it's time to give your vote to the best solutions built with InterSystems IRIS.

🔥 You decide: VOTING IS HERE 🔥

How to vote? Details below.

Hey Community

A new video is already on InterSystems Developers YouTube

⏯ Best Practices for InterSystems API Manager 
 

I'm using FOP 1.1 for ZEN reports and would like to install fonts within the Windows/Fonts directory.

I added the xml tags in fop.xconf but so far I have been unable to get the correct font.

<renderers>
    <renderer mime="application/pdf">

 <fonts>
        <directory>c:\windows\fonts</directory>
        <!-- automatically detect operating system installed fonts -->
         <auto-detect/>
       </fonts>

Any advice would be appreciated.

Hi Developers,

It's time to announce the Winners for August 2021! Please welcome our awesome Global Masters Heroes!

The storm of applause goes to these developers and their great contribution to DC in August 2021:

🥇  @Sergey Mikhailenko, Chief Specialist, AO Mosvodokanal, Russia

🥈  @YURI MARX GOMES, Software Architect, YM Services, Brazi

🥉 @Nigel Salm, Senior Systems Architect at Health System Technologies, South Africa

Learn more about the competition and our awesome winners below.

Hi Developers!

We had a set of technology bonuses for the InterSystems IRIS Analytics contest.

And here is how projects collected it:

I'd like to share with you some storage features that also exist in Caché but are almost 
unknown and mostly not used. They are of course available in IRIS and gain importance
with large and distributed storage architectures.

I am trying to get a list of databases using the DatabaseByServer method but I am only getting an empty string. I have not found any useful examples of the proper usage of this class/method.

I have tried 2 formats. First

set dbList=""

set db=##class(Config.Databases).DatabasesByServer("my-host",.dbList)

I also tried:

set db=##class(Config.Databases).DatabasesByServer("my-host",.dbList,"/cachesys/")

In each case dbList is empty string. I can not figure out what I am missing.

Hello,

I am a clinician and we use Trakcare Lab LIMS at our institution.

We understand histopathology reports are directly typed, stored and uploaded directly to the LIMS.

For clinical audit purpose we need to download these reports directly in text format in bulk. Can anyone offer some technical assistance in retrieval of these histopathology reports? Is there any script that can be run to access, retrieve and download these reports?

Previously I have already tried to play with Google Data Studio when I connected it to InterSystems FHIRaaS. It has quite a nice UI, with a few chart types available out of the box, it can be quite easily connected to some plain tables (stored as CSV or JSON, for instance), and gives the ability to build quite flexible analytics over it. So, I have decided to implement a new connector to InterSystems Analytics (DeepSee), with the ability to select a cube and do some queries on it.

Hi Guys,

when using $ZD(mydate,4) sometimes it returns year as 4 digits and sometimes two, and the documentation is saying ([YY]YY is a two-digit year if hdate falls within the active window for two-digit years; otherwise it is a four-digit year), what active window for two means and how can I force the year to be always 4 digits ?

Thanks

Hey Developers,

New video is already on InterSystems Developers YouTube:

⏯ Deploying & Upgrading IRIS with Kubernetes Operator

Does anyone know how to set an email as High priority when it is sent using a %Net.MailMessage object?  Somehow I can't seem to put my finger on it.

Thanks!

Hello,

Does anyone know if intersystems has a support document/ support guide on "Healthshare"? We need to share it with our L1 support team.

Any support document with a few known issues with their resolution, that the L1 team can expect and resolve?

Hi Developers,

The new video from Global summit 2019 is already on InterSystems Developers YouTube:

⏯ Intersystems IRIS Kubernetes Operator

Hi Community,

join the fun "Wonders of the World" journey on InterSystems Global Masters advocate hub! 

You'll see a challenge to provide feedback on Global Masters, a challenge with selfie photos (OMG that's so great to see the Community's selfies! That's not a public challenge so don't worry we will not publish it unless you gave us your permission!), challenges with interesting facts and tech video. 

We have started to see Journal Daemon inactive and DBLatency warnings in the Console log of our Healthshare server. OS is Windows Server 2008 running in a VM. See below

10/03/18-00:46:39:344 (3840) 1 Journal Daemon has been inactive with I/O pending for 10 seconds:
gjrnoff=6642068,iocomplete=6637348,filecnt=771,fail=0
10/03/18-10:08:47:620 (6064) 1 [SYSTEM MONITOR] DBLatency(c:\intersystems\healthshare\mgr\cachetemp\) Warning: DBLatency = 2300 ( Warnvalue is 1000).
10/03/18-10:08:47:755 (6064) 1 [SYSTEM MONITOR] DBLatency(d:\databases\adtfeed\) Warning: DBLatency = 1251 ( Warnvalue is 1000).

Hello everyone, 

I am new to cache. I want to know is there any direct command to know how to find maximum number of subscripts in global A through direct command.

I mean the answer is 9 but how to check it using a direct command on terminal.

Thanks in advance!!

^A(1)="A"

^A(1,2)="B"

^A(2,1)="CVB"

^A(3,2,7)="'DFGH"

^A(4,1,8,9)="ASDASD"

^A(5,1,2,4,5,6,7,8,9)="ASDASDASD"

Hello all,

I have a problem where one of our 3rd party systems is only able to accept HL7 messages with UTF-8 encoding but the originating messages have Windows 1252 encoding. Does anyone know a way in which I can change the encoding for the entire message from Windows 1252 to UTF-8? I have only been able to find the CONVERT method to change individual charachters but we would like to change the entire HL7 message encoding.

Thanks!

Is there an InterSystems supported dotnet core library or community contributed repo on the horizon?  At this time we are exploring installing the ODBC driver in our containers but would rather use more robust solution.

The OKR methodology (Objectives and Key Results or Objectives and Key Results) is used by the largest companies in the world (such as Google, Netflix, Spotify, BMW, Linkedin, etc.) for agile performance management. It was created in the 1970s by Andrew Grove, president of Intel, and introduced to the general public in his famous book “High Output Management”.

Around 1998 John Doerr, one of the world's top venture capitalists, after coming into contact with Intel's OKR, introduced the model to Larry Page and Sergey Brin, who started a small company called Google.

Hi,

I'm processing POP3 emails using the standard EnsLib.EMail.InboundAdapter adapter and %Net.MailMessage. I'm basically processing documents that are attached to received emails. This works fine if the document is simply attached to the email itself. But some systems are sending documents that are attached to an attached email which has content-type = message/rfc822.

How do I get the attached file from the attached email?

I'm using the following code to iterate through the email parts.

Hey DC members,

How could we make the Tech Article contest better? We want to hear from you all: both from our participants and from those who were unable to participate.

Please answer some questions to help us improve our writing contest.

👉 2-min survey: InterSystems Tech Article Contest Survey

Hi everyone - In IRIS we would like to arrange the access of two users in such a way that each has access to exactly one (his) database only. Which resource does this (%DB_%DEFAULT allows each of the two users access to both databases). If you create new resources (%DB_Database1 and %DB_Database2) and then add them to individual roles (each for the user to), the access for the users, for example, via a REST client does not give the desired separation (instead once Ok, other database 401 Unauthorized both OK). Is there something special to consider or a special resource that could do this or .

Hello everyone

I am new to cache. In an interview i was asked how to optimize a sql query.

I just said I will create index on conditions which are present in where clause. But as per interviewer I should check How query plan is getting executed. This will help in optimizing Sql queries. 

I want to know what will be the answer for how to optimize SQL query in cache. 

Thanks in advance!!

Hello Everyone

I am new to cache. I know there are 2 types of methods in cache. One is Instance method (Which can be call through object creation of particular class) and other is Class methods (which can be call through ##Class(MyPackage.Car).CarModels()). 

I want to know the difference when to create a instance method vs when to create a class methods.

Thanks in advance!!.