Hey,

I have a value in epoch time in which I need convert in order to be able to lookup a table that has dates in YYYY-MM-DD HH:MM:SS format

I thought the below would work but it is not.

select COUNT ('Arrival Time') FROM dbo.table where 'Arrival Time' < DATEADD(ms, CONVERT(int,LEFT(1603173432000, 20)), '1970-01-01 00:00:00')

0 8
0 420
InterSystems Developer Community is a community of 24,952 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!
Learn more

Presenter: Anton Umnikov
Task: Identify your slowest SQL queries and tune them for better performance
Approach: Use InterSystems’ query profiling and analysis tools. Discuss how system configuration can affect performance

This session will show you how you identify the weakest link in your application SQL and introduce you to the fine art of tuning those queries. To do this we will take a look at InterSystems query profiling and analysis tools, as well as how system configuration can impact SQL performance.

Problem: Obscurity on how our SQL engine works

Content related to this session, including slides, video and additional learning content can be found here.

0 2
0 400

Hey Developers,

Don't miss the new exciting promo video from our Brazilian developers on InterSystems Developers YouTube:

🍿 Promo video + Screencast for No Project Mess By IRIS

https://www.youtube.com/embed/gyvpdnPkV5c
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

Open Exchange app
9 1
0 242

Hi

Has anyone used Health Connect/Ensemble to receive results directly from POCT devices (Glucose monitors etc)?

I've been looking for information on the POCT01-A protocol, and as far as I can tell it is a HL7v3 XML schema, I should be able to get results from these devices, though I expect I need a webserver endpoint. (though I can't find any reference in the Health Connect documentation)

Does anyone have any knowledge of this?

KR

Stephen

EDIT: from the silence I'm wondering if this in normally handed off to specialist middleware?

0 2
0 280

Hi, I am new to IRIS and We are planning to setup a CI pipeline on AWS VM deploying the iris data platform container. I am trying to find out which folders needs to be inside the source control and where (exact folder) the updated code needs to be pulled in the container. I would be much obliged if anyone cant point the CI CD related documentation.

Thanks,
Raj

0 1
0 655
InterSystems Official
· Oct 20, 2020
ObjectScript extension for VS Code reaches 1.0

Hello Developer Community!

Once again I'm here to talk about the ObjectScript extension for Visual Studio Code, and this time we are excited to announce the release of version 1.0!

The community has come together in an unprecedented way to deliver this product with InterSystems, and its only fitting that a tool so critical to developer productivity would be built with community testing, feedback and source code from the very beginning.

Open Exchange app
16 0
0 1.1K

Hi Community:

How did Credit Suisse, the VA, and UC Davis advance their digital strategies during the pandemic? Find out on Day 2 of our first-ever InterSystems Virtual Summit. Plus, you’ll hear from our heads of Client Services, Healthcare, and Data Platforms on the ways we’ve adapted, innovated, and built new solutions to help you weather any storm ahead.

To join us:

1 0
0 187

This year's Virtual Summit has more content around Analytics and AI than ever before. We've made this quick video to guide you through the program and put things into context with respect to InterSystems overall strategy for Data & Analytics.

https://www.youtube.com/embed/fTcNimWi2y0
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

6 0
0 280

Hey Developers,

Are you joining us for the InterSystems Virtual Summit 2020?

⚡️ THE REGISTRATION IS NOW OPEN ⚡️

There will be something for everyone at Virtual Summit, whether you’re a tech-savvy executive, a technical manager, a developer or a systems integrator. And this year all sessions are free to attend!

The general theme of the summit is Interaction & Information. And what awaits you at the Summit?

8 2
0 677
Question
· Oct 18, 2020
XML string query

Hi,

I am stuck with simple logic. I have a below string

set a="<Name>ABC</Name><RollNo>45</RollNo><Name>XYZ</Name><RollNo>66</RollNo><Name>xyz</Name><RollNo>89</RollNo>"

I need logic to replace the values of roll no with "***". Is there any single command which can help in this scanerio.

I need to store this value in database after replace.

Thanks

0 6
0 571

Hello every one,

I am a rookie and i am willing to gain some experience on IRIS for Health by doing some development.

I went through the website and found only an online development environment.

But I want to take it a step further ahead bu downloading the software for my own and trying something new.

But, unfortunately I did not find a link to download the IRIS for Health.

I would be pleased if there is any one who has the link to help me out with it.

Hoping to hear soon.

Regards.

Stay Blessed.

1 5
1 1.7K

Hi Community!

We're pleased to invite you to the Online meetup with the winners of the InterSystems Full Stack contest!

Date & Time: Friday, October 16, 2020 – 11:00 EDT

What awaits you at this virtual Meetup?

  • Our winners' bios.
  • Short demos on their applications.
  • An open discussion about technologies being used, bonuses, questions. Plans for the next contests.

5 3
0 317
Question
· Oct 30, 2016
ISCAgent debug

Good day!
Is there an opportunity to debug the ISCAgent behaviour (in Linux)? ISCAgent uses /etc/iscagent/iscagent.conf as configuration file, but in docs I've found a description only for two parameters (port number and interface - http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=...). Other parameters I can see by running /usr/local/etc/cachesys/ISCAgentCtrl status:

1 8
0 3K

Hi Community,

You may know that you get rewarded with points on Global Masters for each your application published on Open Exchange. Recently we introduced bonus points for ZPM applications. So now, you get extra 400 points for each ZPM application! Points are automatically adjusted.
Check out points & available rewards on Global Masters - and see you there today!

4 0
0 222