Welcome to Open Exchange

At InterSystems, we deeply appreciate the rapid innovation enabled by open-source development. Our team acknowledges the significant impact of the community's dedication, which has been a driving force behind the evolution of software and data technology.

Top contributors

Featured applications

447 Application(s)
Filter
Show only
Last release on OEX
Categories
Works with
Industry
Technology Example
Clear filters
Application NameDeveloperMade withRatingLast updatedViewsInstalls

bdb-sql-utils

Various utilities from the SQL cookbook

B
Benjamin De Boe
Docker
IPM
4.5 (2)04 Feb, 2025 800 82

Mimic-SQL-Host-Variables

Allow SQL Host Variables outside embedded SQL

Robert Cemper
Docker
IPM
5.0 (1)03 Feb, 2025 68

InterSystems Ideas Waiting to be Implemented

Programmatic reports

The report creation is a tedious and non-productive task. You need an IDE, create a connection, create a SQL query, define report bands, drag-and-drop/design report columns, fields, labels, summarizations, margins, charts and prepare perfect pixel reports for print. To create a tradicional report the effort takes 4 to 12 hours. The idea is to define reports using object script instructions. With some minutes and with writing a few object script lines you can get a report equivalent to a tradicional report, with the benefit to create dynamic content for the reports (productivity). The idea includes yet the feature to allows to the developer set print restrictions for the PDF report generated (reduce carbon emission, not allowing print, only read). Benefits of this idea: 1 - Productivity - develop a report in minutes not in hours 2 - Reduce carbon emission - is possible restrict the PDF print 3 - Create dynamic reports using ObjectScript 4 - No need to install a report server, saving processor and memory resources (decreasing emissions) To create a report using source code, see this sample with Java, but could be in ObjectScript too: TextColumnBuilder<String> itemColumn = col.column("Item", "item", type.stringType()); TextColumnBuilder<Date> orderDateColumn = col.column("Order date", "orderdate", type.dateType()); TextColumnBuilder<Integer> quantityColumn = col.column("Quantity", "quantity", type.integerType()).setFixedWidth(50); TextColumnBuilder<BigDecimal> unitPriceColumn = col.column("Unit price", "unitprice", type.bigDecimalType()); ColumnTitleGroupBuilder titleGroup2 = grid.titleGroup("Group 2", quantityColumn, unitPriceColumn); ColumnTitleGroupBuilder titleGroup1 = grid.titleGroup("Group 1", orderDateColumn, titleGroup2).setTitleFixedWidth(450); report() .setTemplate(Templates.reportTemplate) .columnGrid(itemColumn, titleGroup1) .columns(itemColumn, orderDateColumn, quantityColumn, unitPriceColumn) .title(Templates.createTitleComponent("ColumnTitleGroup")) .pageFooter(Templates.footerComponent) .setDataSource(createDataSource()) .setSecurityRule(PrintRule.READ_ONLY) //if you want restrict print .printPDF();

Y
by Yuri Marx

5

Votes

3

Comments
Vote

Samples-Aviation

Provides sample data for use in exploring InterSystems IRIS Text Analytics capabilities. Also includes sample analytics model elements.

Evgeny Shvarov
Docker
IPM
4.5 (2)03 Jan, 2025 456 130

mongoCDC

A sample of using embedded python with interoperability

N
Netanel Frankel
Docker
5.0 (1)22 Dec, 2024 82

iris-http-calls

Interoperability Adapter and Service for making HTTP calls

O
Oliver Wilms
Docker
IPM
5.0 (1)22 Dec, 2024 207

Database-Size-Monitoring

Monitor database size growth and issue alerts

s
sara aplin
Docker
IPM
4.0 (1)20 Dec, 2024 161

docs-intersystems

Generated InterSystems Class reference

Dmitry Maslennikov
0.0 (0)16 Dec, 2024 135

iris-global-yaml

InterSystems IRIS Global Data as YAML content

Yuri Marx
Docker
IPM
4.5 (1)15 Dec, 2024 54 4

rest-api-contest-template

Template repository for InterSystems IIRS REST API Programming Contest

Evgeny Shvarov
Docker
IPM
5.0 (1)13 Dec, 2024 515 29

ServiceInspection

A simple application for monitoring Iris service information

W
Wolis Oliavr
Docker
Python
IPM
5.0 (1)13 Dec, 2024 273

FHIR Primitive Extension

How to create a FHIR primitive extension

K
Keren Skubach
0.0 (0)12 Dec, 2024 69

DICOM Image Demo

How to create a DICOM message and how to add a JPG image to it

K
Keren Skubach
0.0 (0)12 Dec, 2024 92

Vector Search for MPI

Example of vector search applied for patient identification

Luis Angel Pérez Ramos
Docker
AI
4.0 (1)11 Dec, 2024 96

LLM QuickStart

Example codebase to match Dev Community Article

C
Chris Stewart
Docker
Python
AI
0.0 (0)10 Dec, 2024 69

IRIS_ISTIO

Common IKO Deployments (used with Istio Service Mesh in Article)

A
Ariel Glikman
0.0 (0)10 Dec, 2024 55

iris-python-lookup-table-utils

IRIS Python Lookup Table Utils (pylotaut is a simple CRUD API)

J
Johannes Heinzl
Docker
Python
5.0 (1)01 Dec, 2024 299

iris-graphql-demo

Example of using GraphQL with InterSystems IRIS with Graphene, S

A
Alberto Fuentes
Docker
Python
5.0 (1)27 Nov, 2024 138

Native-API-for-ObjectScript

A small demo on how to use it

Robert Cemper
Docker
IPM
5.0 (1)26 Nov, 2024 455 41

function-ISJSON

A function to check if string is JSON object

Robert Cemper
Docker
IPM
4.0 (1)26 Nov, 2024 384 39

SPOOL-demo

Demo Code using SPOOL

Robert Cemper
Docker
IPM
4.5 (1)26 Nov, 2024 238 19

CPIPE

Example of using CPIPE programmatically

Robert Cemper
Docker
5.0 (2)26 Nov, 2024 439

ObjectScript-Over-ODBC

Allow running ObjectScript and especially Global copy over ODBC

Robert Cemper
Docker
IPM
4.5 (1)26 Nov, 2024 417 18

Global-dump-to-SQL

Show Global by SQL SELECT

Robert Cemper
Docker
IPM
5.0 (1)26 Nov, 2024 590 25

workshop-iris-oauth2

Using OAuth2 framework in InterSystems IRIS. Learn how to act as Client, Authentication Server or Resource Server.

A
Alberto Fuentes
Docker
4.8 (3)22 Nov, 2024 1.1k

iris-presto-sample

Sample for iris-presto package (using IRIS and PrestoDB )

Yuri Marx
Docker
Python
5.0 (1)17 Nov, 2024 77

recomendacao-filmes-intersystems

Example of using Vector Search for movie recommendations

D
Davi Massaru Teixeira Muta
Docker
Python
5.0 (1)16 Nov, 2024 69

irisChatGPT

Application uses LangChain framework which is built around LLMs

Muhammad Waseem
Docker
Python
IPM
AI
4.0 (1)12 Nov, 2024 1.5k 11

DNA sequence Gene finder

Find certain genes in DNA sequences

F
Filip Kašpar
Python
AI
ML
ML
0.0 (0)10 Nov, 2024 57

character-slice-index

Indexing text by characters

Robert Cemper
Docker
IPM
5.0 (1)27 Oct, 2024 167

WebSocketIRIS.js

using IRIS Native API for Node.js

Robert Cemper
Docker
5.0 (1)24 Oct, 2024 309