Syndicate content 0  
 
All time

I have the need to query an external database and write the result set/snapshot to an internal %Persistent [ DdlAllowed ] table that I built. I have built inbound SQL Services before and write them externally to replace SSIS jobs, but how would querying a database via a Service and writing the data to an internal table work?

Can I just take the inbound query structure and write it to the class file of the internal table in a DTL? If so, what would be the Target? Or does this need to be done within a BPL as a Code block?

0 2
0 51

Hi Community,

I've created a method in my File Service to do a cleanup for every file load. Currently, I've set it to delete data when LastUpdated date is greater than maxdate. However, I want to do a cleanup for every new file load. Any suggestions or advice on how to do this? Thanks!

Method Cleanup()
{

0 0
0 53

Hi Guys,

how do I know that my service is running in a production, I've this receiving service and the as blow that says lost TCP then closing TCP connection, then last one says ConfigItem starting job, and in the Jobs tab it says Listing.

0 1
0 52

Ho Ho Ho, Community!
The integration between Global Masters, the Developer Community, Open Exchange, and the Ideas Portal has now been restored!

The points should now be updated for all contributions made during the downtime of Global Masters.
Please note that we’ve made several adjustments to the awarding system, we will announce the changes soon.
A bug affecting badges for the number of views was detected, so we had to manually update the points for some of you.

1 0
0 53

I'm fairly new to InterSystems and I've been tasked with building a portal that can show DataCheck States among other details, the GetStateBySystem seems to be fit the bill but I don't see a why to call directly from the .Net SDK. I tried sql and can get data from the table but does include "state" information ("starting, stopping, running etc..."). I did find github example around .Net but none fit the bill. If anyone can point me to the right example or documentation it would be greatly appreciated.

Thank you,

0 0
0 53
Question
· Jun 11
Multiselction Zen component

Hi Guys,

I'm looking for a Zen component that allow me to populate a list of items and the ability to multiselect, similar to checklist?

I've thought of using MultiSelectSet component but don't know how can I populate it like to a query or resultset?

a short sample code would be helpful.

Thanks

0 7
0 45

Hey Community,

Enjoy the new video on InterSystems Developers YouTube:

⏯ SMART on FHIR: Introduction & FHIR Server Setup

https://www.youtube.com/embed/OHaZ5qiyQ1c
[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]

1 0
0 52

Hi developers!

While developing web apps the security practice I consider safe and convenient is to create a special Role (e.g. equal application name) which contains security resources which application will need (SQL tables, priviledges, database access, etc) and assign it to the Web Application.
So the user gets this role once it loggs in to the application (via password, no password or delegated).

Convenient, right?

So, the question is, when I deploy the app as an IPM module what should I put as a database access?

0 4
0 48

I am brand new to using AI. I downloaded some medical visit progress notes from my Patient Portal. I extracted text from PDF files. I found a YouTube video that showed how to extract metadata using an OpenAI query / prompt such as this one:

ollama-ai-iris/data/prompts/medical_progress_notes_prompt.txt at main · oliverwilms/ollama-ai-iris

0 0
0 52

I'd like to ask you for recommendations on how to properly use repository dependencies when using VSCode and Client-side editing.
Suppose I have projects A, B and C, with A being independent, B depending on A, and C depending on A and B.
I am currently working with the main project C, and I want to be able to contribute to all the other projects in a single VSCode window (instead of opening three instances). How do you solve this problem? Git submodules? ZPM? Something else?

0 1
0 51

I have an MDM interface with a DTL that takes OBX:5 and replaces "{\E\rtf" with "{\rtf" and "\X0A\" with nothing. Most rtf's this works without a problem, some others, it corrupts the document.

Code:

<assign value='..ReplaceStr(..ReplaceStr(source.{OBXgrp(k1).OBX:ObservationValue(1)},"{\E\rtf","{\rtf"),"\X0A\","")' property='target.{OBXgrp(k1).OBX:ObservationValue(1)}' disabled = '0' action='set' />

My question is - anyone know of any other "gotchas" that could possibly need to be replaced or something?

0 1
0 51

Has anyone tried the Ansible module for qlist in the article "Ansible modules and IRIS demo"?

There appears to be a bug in the qlist code as it assumes that the qlist output has an undocumented field.

I do not have the undocumented field in the output.when I run qlist so I keep getting the error "Unexpected IRIS qlist output format".

I assume that in most cases there is no undocumented field in the output.

0 0
0 52

I am having issues trying to send SOAP requests to a Cloud Based AWS Application that lives outside of our network.

It is using a Basic Authentication, Key, Certificate Authority and Whitelist for Security.

If I attempt the connection using wget from the command line I am able to connect,

0 3
0 48

WSDL for a CDC vendor was provided with a URL using a custom socket (non 443). Everything generated fine, but when making calls to their https:// URL that has their custom port in the URL - no response comes back. The assumption is, their server isn't even processing the request, as Postman does using the custom https://path.to.server:NNNN port in the URL.

0 3
0 48

Hey everyone.

I'm currently looking at a process where we're utilising the Class Ens.StreamContainer, and was looking to do some deletions outside of any purge routines.

Having been burned before, I wanted to make sure that deleting the container also deletes the contents within.

From looking in the class, the %OnDelete ClassMethod appears to be removing an index from a search table and nothing more.

1 2
0 49

Prompt

Firstly, we need to understand what prompt words are and what their functions are.

Prompt Engineering

Hint word engineering is a method specifically designed for optimizing language models.
Its goal is to guide these models to generate more accurate and targeted output text by designing and adjusting the input prompt words.

Open Exchange app
8 0
5 51

Hi Everyone!

The Certification Team of InterSystems Learning Services is currently developing an InterSystems ObjectScript Specialist certification exam. Earlier this month we reached out to our community for feedback that will help us evaluate and establish the contents of this exam. We are still currently accepting responses and would love to hear your feedback!

0 0
0 51

Hey Community,

Here is a digest of the Developer Community videos on InterSystems Developers YouTube Channel in August 2024:

New Videos
№ Video Views
1 What is RAG? (Retrieval Augmented Generation)Amazing LLM System for Enhanced UX #ai #chatgpt #shorts 14755
2 InterSystems IRIS: What's New & Next 109
3 Leveraging Developer Ecosystem Tools for Success 62
4 SQLzilla – Unleash the Power of Your Data 57
5 How Netsmart Moved to InterSystems IRIS in the Cloud 56
6 HealthShare Deployment Automation at Warp Speed 55
7 Updating Legacy UIs for Modern Browsers - Lessons Learned & Steps Forward 53
8 Introducing Managed Solution for Asset Management 38
9 CommonWell Connection 29
10 Winners of the InterSystems Python Programming Contest 2024 28
11 SQLZilla in action #shorts 26
12 Online Meetup with the Winners of the Python Contest 25

0 0
0 51
Question
· May 1
Embedded Python query

Hi Guys,

How can I use this same objectscript principle in embedded python to get the value of each field in my loop?

s sql="SELECT ID, Name, Age FROM Sample.Person WHERE Age="_Myage

Set RS=##class(%ResultSet).%New()

Set Ret=RS.Prepare(sql)

Set Ret=RS.Execute()

While RS.Next()

{

Set name=RS.GetData(2)

}

0 2
0 48