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

1073 Application(s)
Filter
Show only
Last release on OEX
Categories
Works with
Industry
Application NameDeveloperMade withRatingLast updatedViewsInstalls

isc-global-size-tracing

Application to keep track of your globals and database size.

Lorenzo Scalese
Docker
IPM
5.0 (1)15 Apr, 2020 238 22

JuliaGateway

Interface to Julia programming language for InterSystems IRIS

E
Eduard Lebedyuk
Docker
AI
ML
ML
0.0 (0)09 Apr, 2020 706

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

CloudWatch-IRIS

Configuring AWS CloudWatch with InterSystems IRIS

A
Anton Umnikov
Python
0.0 (0)02 Apr, 2020 411

COVID-19 iKnow Content Navigator

Scripts to set up a data explorer for the COVID-19 research article database, powered by InterSystems IRIS NLP technology

B
Benjamin De Boe
Docker
5.0 (1)01 Apr, 2020 249

BlocksExplorer

Database Blocks Explorer for InterSystems Caché

Dmitry Maslennikov
Docker
5.0 (1)29 Mar, 2020 340

isc-tar

TAR compress tool

Dmitry Maslennikov
Docker
IPM
4.5 (1)26 Mar, 2020 634 25

cache-iris-app-tools

Application tools for technical support and DBMS administrator. View globals arrays, execute queries (including JDBC/ODBC), sending results to email as XLS files. Viewer class instances with СRUD editing. A few simple graphs on the protocols of the system. CSP application but based on jQuery-Ui, Uik

Sergey Mikhailenko
3.5 (1)24 Mar, 2020 305

iris-ci

InterSystems IRIS image for running unit tests. Useful for CIs, including GitHub Actions.

R
Rubens Silva
Docker
3.0 (1)23 Mar, 2020 222

iris-ci-demo

A demonstration of how IRIS-CI works.

R
Rubens Silva
Docker
3.0 (1)23 Mar, 2020 109

Reports from global

Based on the information from a global, using one query, we can create several reports at once.

alex kosinets
3.0 (1)22 Mar, 2020 169

Dynamic SQL to Dynamic Object

📟 ObjectScript function to convert any sql query into a dynamic object

D
David Crawford
Docker
4.5 (1)22 Mar, 2020 313

FileMailer

Ensemble solution to email contents of a file via File Passthrough Service using Email Passthrough Operation

O
Oliver Wilms
Docker
4.5 (1)21 Mar, 2020 185

CosFaker

Generate massive amounts of fake data for Intersystems Caché

Henry Pereira
Docker
3.0 (1)20 Mar, 2020 389

ISC-operationaldashboard

Here are some sample code to get you started. A detailed tutorial guide that accompanies this sample code can be found here on InterSystems Developer Community - https://community.intersystems.com/post/developing-operational-analytics-dashboards.

J
Jin Kim
3.8 (2)19 Mar, 2020 128

SEA BATTLE on EXCEL

An example of using virtual excel deployed in M

alex kosinets
4.5 (1)18 Mar, 2020 156

OpenCode

Well, perhaps it's a goal too ambitious to reach 100% but, exploring this idea, and starting with JSON, I've developed a bunch of classes that I thought it was good to share. If you want to test, change, modify or improve the code, or just take a look at it, you can do it. In GitHub repository you c

J
Jose Tomas Salvador
3.5 (1)18 Mar, 2020 296

iris-docker-dev-kit

A set of files to facilitate development with InterSystems IRIS using Docker and VSCode

Evgeny Shvarov
Docker
4.5 (1)15 Mar, 2020 283

objectscript-contest-template

The template repository for InterSystems IRIS, Docker and ObjectScript Online Programming Contest - https://community.intersystems.com/post/join-online-programming-contest-intersystems-iris-docker-and-objectscript

Evgeny Shvarov
Docker
5.0 (1)11 Mar, 2020 205

Port

A Caché project-based set of utilities with %Studio.SourceControl integration to import/export items in plain-text (UDL).

R
Rubens Silva
0.0 (0)03 Mar, 2020 235

iris-sample-rest-angular

Sample Angular app using InterSytems IRIS as backend.

A
Alberto Fuentes
Docker
0.0 (0)02 Mar, 2020 410

EXCEL SUDOKU

This game is made using EXCEL INTERFACE technology. -- to increase the difficulty level, click 5 (cell L3 ) - to get a hint click help (cell D3 ) on/off -- to restart click R (left-top)

alex kosinets
4.5 (1)01 Mar, 2020 237

REST Business Activity Monitoring

Send IRIS Business Metrics to a REST Endpoint, or host a REST API to retrieve Business Metric values

S
Stephen Pisani
3.0 (1)03 Feb, 2020 248

Reducing Readmission Risks with Realtime ML

Patient Readmissions are said to be the Hello World of Machine Learning in Healthcare. We use this problem to show how IRIS can be used to safely build and operationalize ML models for real time predictions and how this can be integrated into a random application.

A
Amir Samary
Docker
ML
ML
3.5 (1)29 Jan, 2020 841

Advent of Code ObjectScript Docker Template

Simple template to craft Advent of Code with ObjectScript in InterSystems IRIS

Evgeny Shvarov
Docker
5.0 (1)25 Jan, 2020 262

eXTreme for IRIS / Caché Example

A console .NET application which shows how to access, create and store globals from a .NET application using eXTreme.

I
Iryna Mykhailova
0.0 (0)13 Jan, 2020 179

PortletSamples

Sample DeepSee Portlets showing different ways to implement custom widgets

P
Peter Steiwer
5.0 (1)30 Dec, 2020 162

JSONExportManyToMany

Sample for %JSONExport against a class with Many to Many Relationship

P
Peter Steiwer
Docker
0.0 (0)30 Dec, 2020 169

iris-explorer

Angular Application that use the standard API discovery in InterSystems IRIS in order to inspect existing APIs and create new APIs using Swagger 2.0 OpenAPI specification

D
David Reche
Docker
4.3 (3)21 Dec, 2019 446

DeepSeeButtons

Tool for analyzing your DeepSee Environment

P
Peter Steiwer
4.0 (1)12 Dec, 2019 404

DSW Reports

Addon for DeepSee Web which provides online reports and PDF emailing reports from InterSystems DeepSee dashboards

S
Semion Makarov
0.0 (0)11 Dec, 2019 210