IrisWebClient

Rich GUI Web Application for InterSystems IRIS

A modern web client built with Delphi + uniGUI and connected to InterSystems IRIS via ODBC. The application demonstrates full CRUD operations, referential property handling, and IRIS-native filtering using implicit JOINs.

How to Test

If you want to test the app without installing anything

https://demo.irisclient.org

login: demo
password: demo

Features

• Full CRUD (Create, Read, Update, Delete) for IRIS persistent classes
• Insert/update of referential properties such as:
  • Person → Spouse
  • Employee → Company
• IRIS implicit JOIN filtering:
  • Filter by nested referential fields
  • Examples:
    • Person.Spouse.Name
    • Employee.Company.Name
    • Address.City
• Rich web UI built with uniGUI
• ODBC connectivity for SQL access to IRIS
• Zero-installation browser client

Architecture Overview

• Frontend: uniGUI (Delphi) https://unigui.com/
• Backend: InterSystems IRIS https://www.intersystems.com/
• Connectivity: IRIS ODBC driver
• Data Model: Person, Employee, Company, Address (with referential relationships) ObjectScript-Native-API-demo
  https://openexchange.intersystems.com/package/ObjectScript-Native-API-demo

CRUD Demonstration

The application implements full CRUD for all major entities:

Referential Property Handling

The application demonstrates how to:

• Insert and update objects with references
• Display referential fields in grids
• Resolve nested properties (e.g., Person.Spouse.Name)
• Maintain referential integrity through UI controls

Filtering with IRIS Implicit JOIN

IRIS automatically resolves referential properties in SQL queries. This application shows how to filter by nested properties without writing explicit JOINs.

SELECT * FROM ONAPI.Person WHERE Spouse->Name LIKE 'A%'

Installation on Windows host

• Install IRIS
• Load sample classes to IRIS
  use ObjectScript-Native-API-demo
  

  git clone https://github.com/r-cemper/ObjectScript-Native-API.git

  load classes

  
    USER>do $system.OBJ.LoadDir("...\ObjectScript-Native-API\src\ONAPI","ck")
    

  run the database installtion, this is interactive process, you will be asked how many Persons, Employee, Companies to create
  

  USER>do ##class(ONAPI.demo).Run()

• Configure ODBC DSN
  Create a 'User DSN' for InterSystems IRIS ODBC driver
• Build the uniGUI IrisWebClient.exe application in Delphi
• Update connection.ini with ODBC connection parameters and make sure the file is located in the same direcotry as IrisWebClient.exe

    DataSource=...
    User_Name=...
    Password=...
    ODBCDriver=InterSystems IRIS ODBC35
    Database=...
    DriverID=ODBC

• make sure login.html is located in the same directory as IrisWebClient.exe
• run IrisWebClient.exe and navigate browser to the default address:port http://localhost:8077

Screenshots

Main Dashboard

Assigning referencial properties

Select a Person, click button in SpouseName column, select a Spouse, click 'OK' to confirm assignment

Searchable Lookup combobox

Assign Employee->Company finding a comany in the Lookup combobox

Filtering using referencial properties

Use 'Filter' button to call Filter dialog and add filtration criteria

Calendar widget in the Grid

License

MIT LICENSE