Encontrar

Article
· Sept 22 2m de lecture
Open Exchange

Dashboard of database free space

#Analyseur #Tableaux de bord #Bases de données #ObjectScript #Administration du système #InterSystems IRIS

Finishing my previous example for multiple IRIS instances, I tried
to compose a local single instance version.  The step from the external
Python app to a version using embedded Python seemed to be obvious.
This was a wrong assumption, as some Python libraries just refused installation
into my local Windows-based environment.
After several frustrating and fruitless attempts, I took a step back rethinking the case.

  • IRIS offers DeepSee a ready-to-use set of tools for all kinds of charts
  • It is ready to present the base data in tables
  • Dashboards allow the combination of graphs and tables on a single screen.
  • There is no need for an external store. 
  • And COS allows me any odd trick if ever needed.

The final result

The parts to be served

  • My Dashboards are a collection of Table views and  Charts
  • Tables and Charts are generated from Pivots created in Analyzer
  • I use 2 pivots
    1. based on raw numbers,
    2. based on $ZLOG(numbers) for better scaling of the chart  
  • Content for the Pivots comes from 2 separate Cubes
  • The Cubes are designed with DeepSee Architect from a persistent class
  • The class is refreshed for each view by a Class-Query in %SYS
  • To avoid useless Journal records, I use a temporary table in IRISTEMP
  • Finally, a Portlet provides the actual timestamp of the snapshot

The processing steps 

  • A CSP page is called by its URL
  • In method OnPreHTTP
    • The System Query fills the temp table from %SYS
    • Then both cubes are rebuilt
    • Finally, the Dashboard is launched by server-side redirection
  • The content of the initial CSP page is irrelevant and therefore empty

GitHub

3 Comments
Discussion (3)2
Connectez-vous ou inscrivez-vous pour continuer
Résumé
· Sept 22

Publicações Desenvolvedores InterSystems, Setembro 15 - 21, 2025, Resumo

#Communauté des développeurs officielle #Résumé
Setembro 15 - 21, 2025Week at a GlanceInterSystems Developer Community
Question
· Sept 22

Cache Locking - how to remove Cache lock from another process

#Caché

Hello to all my fellow Cache Developers/Experts out there :)

The purpose of this post is to get input/feedback regarding an issue we are having with our Cache LIS web-based application not being able to remove locks that were taken under a separate process.

Here is the background of how the LIS does the locking and details about the issue:

-> our LIS web-based application sets records into a queue for doing locks and unlocks (the LIS runs under one process - guessing its the CSP server processes that process the broweser-to-backend requests) NOTE:  Our LIS is a web application, so in order for locks to be honored across all running user sessions, the LIS web-based application had to implement a web-based lock manager (this was a recommendation from InterSystems circa 2007/2008)

-> our application has a background job that runs to process records placed into the queue that has the lock/unlock requests (this background job is a separate standalone process that would do the physical LOCK + or LOCK - commands)

-> Overall, the lock manager process (as it is called) works really well.  But there are times when an unlock request is not able to be processed and we end up with an orphaned lock. When that happens, the users are not able to do any work with the associated database table/record(s) until the lock is released.  So our LIS web-based application has a feature to display which accessions (cases) are locked and allows the user to select one or more of the locked accessions and click a button [Remove Lock] to remove the lock.  This is the feature that is NOT working.   We are guessing that is because the LIS web-based application is running under one Cache process and the background job that takes out the LOCK + is running under a separate Cache process.  And we are guessing the LIS web-based application does not have the proper permissions to be able to remove a lock for another Cache process.  We are unsure what permissions would be needed by the LIS application default Cache account to be able to remove locks for another Cache process, such as the background job that takes out the locks.

Your input/feedback regarding this issue and recommendations for how to allow the LIS web-based application to remove the locks is appreciated.

Best Regards and GO TEAM!!

4 Comments
Discussion (4)3
Connectez-vous ou inscrivez-vous pour continuer
Annonce
· Sept 22

[Video] Unlocking a World of Possibility

#Artificial Intelligence (AI) #READY 2025 #Vidéo #Summit

Hey Community,

Enjoy the new video on InterSystems Developers YouTube:

⏯ Unlocking a World of Possibility @ Ready 2025

This talk challenges the healthcare industry to accelerate progress toward true interoperability and patient-centered care. It highlights the rapid evolution of technology, especially AI, and contrasts it with the lag in healthcare system integration, where outdated methods like fax machines and CD-ROMs still persist. The ultimate vision: a seamless, connected system where patients experience healthcare as intuitively as ordering a pizza.

Presenter:
🗣 Kari Hedges, Senior Vice President, Blue Cross Blue Shield Association

Curious about best practices? Watch this and subscribe for more!

Discussion (0)1
Connectez-vous ou inscrivez-vous pour continuer
Question
· Sept 22

InterSystems health connect interface to transfer files to SharePoint

#REST API #InterSystems IRIS for Health #Health Connect

hi everyone

we are migrating a legacy script that uploads the files to a SharePoint site through webdav to Health Connect engine.

I wonder if anyone has ever done that, if yes, what did you do to achieve this?

 

thanks in advance,

 

Frank

3 Comments
Discussion (3)2
Connectez-vous ou inscrivez-vous pour continuer