I am having a datatype DATE value from db 41966. And I want to convert it to epoch time.
Also, in case of DATETIME value how can I convert it to epoch.

Good day,

Is there a way to change the theme in management portal? or at least the color of the header.

Issue is, some users have access to Development and Testing and Production environments. I would like a way to color-differentiate the environments to reduce the errors.

NOTE: This content was originally presented at the InterSystems Global Summit in 2014, however related topics often come up on the Developer Community so I have decided to turn this into an article for easier reference and discussion. However, much of the content was pulled directly from the presentation slides so the article format resembles that of a PPT deck more than paragraphs.

Hi colleagues!

InterSystems Grand Prix 2023 unites all the key features of InterSystems IRIS Data Platform!

Thus we invite you to use the following features and collect additional technical bonuses that will help you to win the prize!

Here we go!

• LLM AI or LangChain usage: Chat GPT, Bard and others - 6
• InterSystems FHIR SQL Builder- 5
• InterSystems FHIR - 3
• IntegratedML - 4
• Native API - 3
• Embedded Python - 4
• Interoperability - 3
• Production EXtension(PEX) - 2
• Adaptive Analytics (AtScale) Cubes usage - 3
• Tableau, PowerBI, Logi usage - 3
• InterSystems IRIS BI - 3
• Columnar Index Usage - 1
• Docker container usage - 2
• ZPM Package deployment - 2
• Online Demo - 2
• Unit Testing - 2
• Implement InterSystems Community Idea - 4
• First Article on Developer Community - 2
• Second Article On DC - 1
• Code Quality pass - 1
• First Time Contribution - 3
• Video on YouTube - 3

As you know, if you regularly read the articles that are published in the Community, last May InterSystems organized the JOnTheBeach2023 Hackathon held in Malaga (Spain). The topic that was proposed was the use of predictive analysis tools that InterSystems IRIS makes available to all developers with IntegratedML.

Introduction

A password manager is an important security tool that allows users to store and manage their passwords without the need to remember or write them down in insecure places. In this article, we will explore the development of a simple password manager using the Flask framework and the InterSystems IRIS database.

Key Features

Our password manager application will provide the following key features:

Our objective

In the last article, we talked about a few starters for Django. We learned how to begin the project, ensure we have all the requisites, and make a CRUD. However, today we are going a little further.
Sometimes we need to access more complex methods, so today, we will connect IRIS to a Python environment, build a few functions and display them on a webpage. It will be similar to the last discussion, but further enough for you to make something new, even though not enough to feel lost.

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:

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.

It's time for a Code Golf round!

Isogram

A word or phrase that has no repeating letters, consecutive or non-consecutive.

Implement a method that checks if the received string is an isogram or not.
Assume the empty string is an isogram.
Ignore the letter case.

Allowed inputs: A-Z, a-z.

As usual, the shortest solution wins!

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.

If you utilize Quality Code Analyzer in your open source application this will be shown on Open Exchange:

1. On the main OEx page you can filter all the apps which passed Object Script Quality test

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: