Hi Experts

I am trying to pull the code tables Information and this code table has linked code table not exactly obviously joined by SQL tables or columns. This is confusing me. Please can you clarify how to link these two tables.

I will be generic to ensure, any privacy is protected

CT_Hospital has CT_Staff linked in.

When CT_Hospital has data, for that relevant hospital code, CT_Staff can be clicked and data entered.

When I see in the Components - > Items I do not see any SQL table or SQL column common between CT_Hospital and CT_Staff.

Interesting issue we found. When making an ODBC connection from a host via RDP, the IP address shown as making the connection is the client IP address, not the host from where the connection initiated. Has anyone seen that or know how to get around it?

Example:

My Computer(10.X.X.112) -> RDP to Host1(10.X.X.93) -> ODBC connection to Server1(10.X.X.12). Cache Portal -> System -> License Usage -> Usage by User shows My Computer's IP address as making the connection rather than Host1.

Hello,

I'm hoping to get some feedback on the OAuth process flow for Payer-to-Payer authorization. It doesn't seem that "Authorization Code Flow" is needed as there will not be a need for a login. I am leaning towards recommending "Client Credentials Flow", but wanted to get some community feedback before making a decision. I prefer to follow what the standard will be if possible. What would you recommend? Thank you in advance for your input.

https://docs.intersystems.com/irislatest/csp/documatic/%25CSP.Documatic....

method Export(savertn As %Boolean = 0) [ Language = objectscript ]

So I am working with an inherited SQL query that queries 8 different tables. 5 of which have over a million records.
I have 3 different servers.

Server 1, Server 2 and Server 3. They all have the same data/tables/structure across all servers.
Server 3 has an Iris database engine and the other 2 are Cache 2015.1.4.

I have a problem with views and performance across the servers being inconsistent.

Thankfully Server 1 is the current live server that performs "fast enough".
Server 2 is being synced from Server 1 and acts as a report server.

Hi,

How to send push notification from production in case of error ?

Thanks

This post provides useful links and an overview of best practice configuration for low latency storage IO by creating LVM Physical Extent (PE) stripes for database disks on InterSystems Data Platforms; InterSystems IRIS, Caché, and Ensemble.

Newbie to working with silent installs. is there a variable to pass in what/where you want to place your journal files?

Hi Community,

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ iKnow: Open Source NLP in InterSystems IRIS

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

Hello!

Want to get 5000 points on GlobalMasters?

I'm launching a bug bounty for a bug with which I've been struggling for the last 4 years. Have tried to resolve it many times, but no dice - can't track it down.

Here's the issue.

To claim this bounty you need to:

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.

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:

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.

Hey Community

A new video is already on InterSystems Developers YouTube

⏯ Best Practices for InterSystems API Manager

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