As an AI language model, ChatGPT is capable of performing a variety of tasks like language translation, writing songs, answering research questions, and even generating computer code. With its impressive abilities, ChatGPT has quickly become a popular tool for various applications, from chatbots to content creation.
But despite its advanced capabilities, ChatGPT is not able to access your personal data. So in this article, I will demonstrate below steps to build custom ChatGPT AI by using LangChain Framework:

Open Exchange app
4 0
1 9.6K
InterSystems Developer Community is a community of 17,818 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!
Learn more

Hello Community!

The Global Summit 2023 in Hollywood has just ended but keynotes are already available for those who missed them while being on the premises or who couldn't attend this in-person event at all for some reason or another (or just for those who wish to refresh their memory and listen to them again).

InterSystems 30th Global Summit Welcomes Virtual Participants to Experience Innovation at its Best!

Enjoy watching all the keynotes from all three days of Global Summit 2023 via this YouTube playlist:

3 1
1 198

Hi all,
I am using ExecDirect() method to execute my SQL query which is something like "SELECT * from Account where AccountNumber = ? "
But when I am providing a accountnumber that don't exists it doesn't return anything as aspected. while I am trying to check resultset.%SQLCODE in this case it is giving me 0 not 100. What's wrong with my SQL query and Also I there any other Property through which I check for if my resultset is null or it has some values.

0 2
0 216
Article
· Jul 4, 2023 2m read
Build iris image with cpf merge

When it comes to build an iris image, we can use the cpf merge files.

Here is an cpf merge example:

[Actions]
CreateDatabase:Name=IRISAPP_DATA,Directory=/usr/irissys/mgr/IRISAPP_DATA

CreateDatabase:Name=IRISAPP_CODE,Directory=/usr/irissys/mgr/IRISAPP_CODE

CreateNamespace:Name=IRISAPP,Globals=IRISAPP_DATA,Routines=IRISAPP_CODE,Interop=1

ModifyService:Name=%Service_CallIn,Enabled=1,AutheEnabled=48

CreateApplication:Name=/frn,NameSpace=IRISAPP,DispatchClass=Formation.REST.Dispatch,AutheEnabled=48

ModifyUser:Name=SuperUser,PasswordHash=a31d24aecc0bfe560a7e45bd913ad27c667dc25a75cbfd358c451bb595b6bd52bd25c82cafaa23ca1dd30b3b4947d12d3bb0ffb2a717df29912b743a281f97c1,0a4c463a2fa1e7542b61aa48800091ab688eb0a14bebf536638f411f5454c9343b9aa6402b4694f0a89b624407a5f43f0a38fc35216bb18aab7dc41ef9f056b1,10000,SHA512
2 0
0 196

Prediction of server configuration for entry

The platform server entry configuration prediction application connects to Iris in Java and uses its Integrated ML technology to analyze data such as hospital outpatient volume, number of services, number of messages, and message save time. It can predict the server configuration required for the hospital entry platform before the hospital integration platform enters, providing convenience for customers.

Open Exchange app
2 0
0 123

In show Query messages in the message viewer the head.%Id is always used. How do you do this via your own sql/objectscript as fast as the portal does a search as using dates searching Ens.MessageHeader on portal is slow.

For instance if you try do a search saying (TimeProcessed >='2023-06-01 00:00:00.000' and TimeProcessed <'2023-06-02 00:00:00.000') it is slow but using the portal the search would know this is head.%ID >= 5344549861 AND head.%ID <= 5347641372. How do you utilize this in your own queries as can't see the logic in EnsPortal.MsgFilter.Assistant

0 3
1 178

I'm having trouble adjusting the protocol used for any CSP Requests. Currently all request to the system are sent over HTTP 1.1

When loading 40+ images on a page, the browser starts stalling request. According to google HTTP 1.1 only allows 6 parallel TCP Connections before suspending the remaining.

I have looked through the Web Gateway Settings, %Net.HttpRequest.HTTPVersion and SSL Configuration but haven't found anything.

0 7
0 219

Hey Community!

It's been almost three weeks since the end of the Global Summit 2023 (here is a brief reminder of day 1, day 2 and day 3) and you may want to relieve the excitement or, maybe, wish to see the sessions. Here is your chance to influence the order in which those sessions are published here, on the Developer Community.

Here is a full list of sessions so please write down in the comments the ones you look forward to the most! And we'll do our best to satisfy the demand 😉

3 1
0 170

Hi Developers,

The annual competition for InterSystems IRIS developers is fast approaching!

We're super excited to invite you all to join the Grand Prix contest for building open-source solutions using InterSystems IRIS data platform!

🏆 InterSystems Grand Prix Contest 2023 🏆

Duration: June 12th - July 9th, 2023

Prize pool: $26,000

13 18
2 2K
Article
· Jun 29, 2023 3m read
IRIS Api Tester

Hello Community!!

I just upload my lastest application "IRIS Api Tester" to the Open Exchange.

It's a docker project with InterSystems IRIS + Newman that will allow you to test your Postman Collections in a quick and easy way..

It's ready to work out of the box, you just have to clone the repo: https://github.com/daniel-aguilar-garcia/irisapitester

Run the docker-compose file:

Open Exchange app
2 1
1 367
Hello and welcome to the Dev Community Post Digest for June 2023.
General Stats
✓ 177 new posts published in June:
– 36 new articles
– 33 new announcements
– 105 new questions
– 3 new discussions
✓ 315 new members joined in June
✓ 11,589 posts published all time
✓ 9,745 members joined all time
1 0
0 189
Discussion
· Jun 29, 2023
The idea for iris-user-manager

I want to deploy IRIS apps running in containers in Kubernetes with user accounts configured.

I have a %ZSTART routine which looks for an XML file with Users export data and if the %ZSTART routine finds this file, it imports it. This Users export data can be obtained by running a class method.

I have defined a task which can be scheduled or run on demand. This tasks imports user data from an XM file.

In Kubernetes I can provide a ConfigMap to stage the Users data for the %ZSTART routine.

1 2
0 168

InterSystems IRIS Cloud SQL is a fully managed cloud service that brings the power of InterSystems IRIS relational database capabilities used by thousands of enterprise customers to a broad audience of application developers and data professionals. InterSystems IRIS Cloud IntegratedML is an option to this database-as-a-service that offers easy access to powerful Automated Machine Learning capabilities in a SQL-native form, through a set of simple SQL commands that can easily be embedded in application code to augment them with ML models that run close to the data.

Today, we announce the Developer Access Program for these two offerings. Application developers can now self-register for the service, create deployments and start building composable applications and smart data services, with all provisioning, configuration and administration taken care of by the service.

5 0
0 301
Announcement
· Jun 30, 2023
[Video] Managing Database Size

Hi Community,

Watch this video to see how to expand or truncate a database using the Management Portal in InterSystems IRIS data platform, and learn about the best times to do each:

⏯ Managing Database Size

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

Motive

Am just plain curious about how people may be approaching this area.

The Question

The %SYSTEM.License API wraps an IRIS key that is specific to a range of InterSystems products with

  • Platform features
  • Platform behaviors
  • Expiry date
  • Capacity / Usage limits

If a company is implementing deployed products that:

  • run on top of IRIS
  • optionally support other vendor IRIS products

For example:

0 2
0 183
Question
· Jun 23, 2023
Dateconversion

Hi Community,

I need to convert date 1997-08-09 10:38:39.700000000 into this format 1997-08-09T10:38:39Z

I have tried using all date function $ZDH,$ZDT no luck can anyone help me to convert this into required format.

Thanks,

Smythee

1 5
0 264

Hi all

I need to do hardware maintenance on a physical HealthConnect server which forms one half of a mirrored pair, and It will require multiple restarts.

So, I will need to prevent any HealthConnect services from restarting until all maintenance is completed. Is this just a case of disabling the service "HealthConnect Controller for <SERVERNAME>", or is there anything else I need to be aware of?

Andy

0 2
0 148

InterSystems FAQ rubric

For volatile tables (tables with many INSERTs and DELETEs), storage for bitmap indexes can become inefficient over time.

For example, suppose that there are thousands of data with the following definition, and the operation of bulk deletion with TRUNCATE TABLE after being retained for a certain period of time is repeatedly performed.

3 0
0 208

We are trying to come up with huge DataStore which needs to store HIPAA transactions and Data getting partitioned with idkey - YYYYMM. Current Live data get inserted into current Month DB - HIPAA_202306. 10 years (Hipaa retention policy) old data is going to be sitting in to 120 DBs ( 201606_HIPAA, 201607... 202305) for historical audit legal compliance purposes.

Currently if we create Namespace we get 2 databases - CODEDB for routes/classes & DATADB for journals data.

0 7
0 318

Hi All,
I was creating a unit test directory with the below script. But it not creating any directory as mentioned in code. I am working on MacBook with irisusr User as standard installation process.

if '$data(^UnitTestRoot) {

set mainFolder = "UnitTest\NewDir\"

set st = ##class(%File).CreateDirectoryChain(mainFolder _ testSuite)

if $$$ISOK(st) { set ^UnitTestRoot = mainFolder }

else {

write !, "UnitTestRoot folder could not be created. Consult with instructor."

do $system.Status.DisplayError(st)

}

}

0 2
0 170

Hi Community,

I would like to know how I can query a list of patients that were revoked on HealthShare for the month of April and May.

Messages are sent using FHIR and a revoke is handled with active:false as seen below. A non-revocation will have active: true on the patient resource.

I wanted to check SQL tables but I am not sure which one to check if so. Please advise on how to go about getting this report.

Regards,

0 0
0 116

Getting INVALID OREF error while unit testing. Also ResultDyanmicObj.Headers.%Size(),DummyResponse.Headers.%Size() these are working fine getting 7 value from both. but still it is not working.

do $$$AssertEquals(ResultDyanmicObj.Headers.%Size(),DummyResponse.Headers.%Size(), "Validation for Headers")

error - INVALID OREF>TestAccountSearchWithoutAccount+6

0 1
0 195

Mycroft Core Release Notes: 8/14/2017 - Mycroft

Welcome to the June'23 Developer Community Release!

We're stoked to share with you the latest improvements we've made to the usability of the Developer Community:

📌 Location in bio

📌 New filters in search by Members

📌 Job Opportunities

📌 Ideas Portal on the About page

Let's have a closer look at all these updates.

8 5
0 325

Hi All,

I am trying to execute my SQL query using ExecDirect() method and it returns a ResultSet. No doubt it works fine after this I am trying to fetch each value using a loop code below. But before that, I am also checking for %SQLCODE = 100 which is for an empty resultset I think. However, It is not working as desired. In the case of an empty resultset also I am getting %SQLCODE = 0 until result.%Next() is called. Also, %ROWCOUNT is giving 0 in a case where my query is return 1 result row. I am so confused about this.
while resultset.%Next() {

// code

}

0 4
0 160

Has anyone come across a good using Embedded Python to convert a Python List object to an IRIS %List object?

My use case is I want to open an SQL entry with an Objectscript class method, then pass some information from that row into a separate Python class method which will then create a Python List object, then have the Python class method return that list back to the Objectscript class method in such a way that the Python List can be converted to an IRIS %List object for me to then use in the Objectscript code.

0 3
0 208