Pesquisar

问题
· 十月 23, 2024

How to search message details in LIVE based on MRN

Hello Experts ,

Could you help to search message details based on MRN in intersytems iris. 

We have created 100+ interfaces and currenly in live (interystems cloud) . Now I try to search message details based on MRN using below query. it is working fine in DEV. but in prod it is taking ages.

SELECT Header.SessionId, Header.SourceConfigName ,Body.RawContent
FROM Ens.MessageHeader AS Header 
JOIN EnsLib_HL7.Message AS Body ON Header.MessageBodyId = Body.ID     
 where  Body.TimeCreated BETWEEN '2023-03-15 13:10:22.993' AND '2023-03-15 13:10:25.993'
 AND Body.RawContent LIKE '%40103262%'

could you please provide me any idea .

thanks you

2 Comments
讨论 (2)3
登录或注册以继续
公告
· 十月 23, 2024

20,000 members on the InterSystems Developer Community!

Drumroll, please...

🎉 The InterSystems Developer Community has officially surpassed 20,000 registered members! 🎉

But that’s not all – we’ve also achieved some impressive milestones:

📝 21,500 published posts

👁 10,000,000 views

We want to take a moment to celebrate with all of you who have made this possible!

In what feels like the blink of an eye, our community has EXPLODED in size 🤯. We’ve doubled in size in just two years' time! It’s not just numbers — it’s the impact YOU are making, and we couldn’t be more grateful!

This phenomenal growth is all thanks to you — our amazing community of developers, contributors, and trailblazers! Whether you're sharing your expertise and next-level insights, asking thought-provoking questions, or collaborating with others, you are the heartbeat of this Community. ❤️‍🔥 You’re transforming this platform into a powerhouse of ideas and solutions, and we are here for it!

🌍🫂 With six regional communities in different languages (EN, ES, PT, JP, CN, FR), we’re uniting developers from all over the globe, making the InterSystems Developer Community a truly global hub.

👏 A special shoutout to our superstar moderators, content managers, and admins who keep this incredible machine running smoothly. Your dedication keeps the gears turning, and we couldn’t do it without you!

But guess what? This is just the beginning!
We’re excited to keep growing, learning, and innovating TOGETHER. Whether you're new to the community or a long-time member, there’s so much more ahead for all of us!

THANK YOU!

---

Sincerely yours,
InterSystems Developer Community Team

讨论 (0)1
登录或注册以继续
文章
· 十月 23, 2024 阅读大约需 1 分钟

file2Xml 一个将文件转换成Studio导出的xml格式的工具

file2Xml 

一个将文件转换成Studio导出的xml格式的工具

通过此工具可以将本地文件转换成xml格式文件,然后通过Studio导入到服务器中,而不再需要其他工具将文件传至服务器。


下面以为ensemble2016自带的一个示例界面增加背景图为例。

http://localhost:57772/csp/samples/cinema/Cinema.csp

1.选择数据版本信息并录入web应用程序(SMP--系统--安全管理--Web 应用程序)

确定此示例界面的Web应用程序为:/csp/samples

2.点击“选择文件”,选择需要转换的文件

选择本地电脑要作为背景图的图片

3.录入每个文件导入后相对于web应用程序的路径和导入后的文件名

想要放到cinema下,故相对于web应用程序的路径为:cinema

想要将文件命名为:search_bg.jpg

4.勾选最终需要转换的文件,并点击“转换”

5.录入转换出的xml文件名,点击“确定”

讨论 (0)1
登录或注册以继续
公告
· 十月 23, 2024

Developer Meetup on Gen AI, RAG, Hallucinations [Nov 19, Cambridge, MA]

Hi Developers! Join us at our next in-person Developer Meetup in Cambridge, MA. Topic for this meetup:

Talk 1: Deep dive on RAG and AI Hallucinations - by Thomas Dyar, Product Manager, MA - InterSystems
Talk 2: Leveraging AI to Transform Audio Data for Improved Clinical Outcomes in Healthcare - by Vishal Pallerla, Sales Architect, InterSystems

>> Register here

    

⏱ Day and Time: November 19, 5:30 p.m. to 7:30 p.m.
📍CIC Venture Café in Cambridge, Massachusetts

Save your seat now!

Food, beverages, and networking opportunities will be provided as always.
Join our Discord channel to connect with developers from the InterSystems developer ecosystem.

讨论 (0)1
登录或注册以继续
公告
· 十月 23, 2024

InterSystems Ideas News #16

Hi Developers!

Welcome to the 16th edition of the InterSystems Ideas news! Here's what you can expect from it:

​​​​✓ Ideas implemented in Q3 2024

✓ Select an idea to implement from "Community Opportunity" ideas

✓ Vote and comment on new ideas submitted in Q3 2024

 

  We are starting this newsletter with the list of ideas implemented in Q3 2024.

👏 Thanks to all the InterSystems developers and Developer Community members who contributed to making these ideas a reality. 👏

 Most popular "Community Opportunity" ideas are waiting to be implemented.

Select an idea you like from "Community Opportunity" ideas and implement it to get into the Ideas Portal Hall of Fame!

 To round up this newsletter, please find new ideas with "Needs review" status. InterSystems experts regularly triage and analyze new ideas. Vote for ideas you like and comment on them to show your interest.

👏 Thank you for posting these ideas. Special thanks to @Scott Roth for posting a lot of ideas last quarter! 👏

Stay tuned to read our next announcements!


In the meantime, post your brilliant ideas, vote for existing ideas, and comment on them on our InterSystems Ideas Portal!

讨论 (0)1
登录或注册以继续