Hi -

I'm trying to figure out an elegant way to select a row on a table pane when I don't have an index, but I DO have a value.

My page has a typical tablePane (with a tableNavigator) which is being populated from a table of records, and the value for each row is the object instance ID for the class that has the rest of the columns being displayed. What I'm trying to do is add in a URL parameter for a targeted object ID that will populate the specific "fields" elsewhere on my page, which are the same fields that are populated when I do an onSelectedRow() from my tablePane.

Hi folks!

Each IRIS installation has a /lib folder which is intended for 3rd-party libraries being used in the solution.

For IRIS installation the typical path is:

/usr/irissys/lib/

In ZPM the shortcut is ${libdir}.

What is the macro or internal function to obtain it programmatically?

Hi everybody,

Is there any functionality I could use that triggers real time user-defined code on certain audit events? Right now I am interested in triggering such code on a routine modification event, like the one below. I do know how to access this record programmatically, via %SYS.Audit.

Thanks in advance,
Anna

Hi Developers, 

We are pleased to introduce new 🎁rewards on Global Masters available for advocates of the Specialist level and above:

➡️ PRE-ORDER for Raspberry Pi 4 8GB + InterSystems IRIS Community Image Set

The set includes: MicroSD Card 64GB with Ubuntu 18.04 64 bit + Docker + InterSystems IRIS Community Image, Raspberry Pi 4 8GB, Red-white case.

Hi Developers!

Please welcome the new video on InterSystems Developers YouTube:

⏯ Embedding AI Services

There is a error when I try to use VSCODE to connect to my Ensemble Server. What's wrong with me？How can I Configure this /api/atelier web application

As a Belgian leader in developing and operating entertainment solutions in the sports betting and casino games sector, Bingoal is a dynamic and ambitious company looking for a passionate Back-End Software Engineer. Together with the IT team, you will be working to create scalable and easy to maintain software having an impact on the core of Bingoal’s activity.

We are looking for a developer with InterSystems ObjectScript Experience.

This is a demo to make use of a simple WebSocket Client with Embedded Python in IRIS.

How to Test it

• Run an Iris Session in Docker
• Select your WebSocket Echo Server
• Enter the text you want to send or generate it
• Send it and see the result

$ docker-compose exec iris iris session iris "##class(rccpy.WSockPy).Run()"

*** Welcome to WebSocket Embedded Python Demo ***

Collecting websocket-client
Using cached https://files.pythonhosted.org/packages/4c/5f/f61b420143ed1c8dc69f9eaec5ff1ac36109d52c80de49d66e0c36c3dfdf/websocket_client-0.57.0-py2.py3-none-any.

Hi,

So I am a front end developer working with REST API with Cache database on the BE. The BE guys are currently using Cache through a Windows virtual machine and they claim it is not possible to have a development server to work with. All the work they are doing is directly on the production server and changes are immediate and I think this is a bad idea going forward and we most definitely need a development server that has access to the same code base and different version (through git) to be able to do development. We also do all the testing on this production server with test accounts, but we cannot do automated testing with this setup.

Hey Developers,

Here is a digest of the Developer Community videos on InterSystems Developers YouTube Channel in January 2021:

I need another set of eyes to look at the following. Instead of a Data Lookup table, I wanted to try to lookup a value against a Cache table that I had build. So I thought I could write a function to run a simple SQL query against the Cache Table and return me a %Boolean value back to my routing rule. However today I found that it was not working properly.

Can someone take a look at the following method and verify that I am doing this correct?

Hi Developers,

Please welcome the new video on InterSystems Developers YouTube:

⏯ Building REST API with InterSystems IRIS Docker Container in 5 Minutes

In the context of IKO (Iris Kubernetes Operator) the question of Service not redirecting dynamically to the correct Pod is still pending.
In production this can be dangerous since an overload (or any other simpler problem) can cause you to change the main Pod and leave the application inoperable until we intervene.

Intersystems support warned that this is still an issue of IKO, but there are some possibilities that I am studying.

Hi,

I have a PV1 repeating field that can contain multiple or a single value. I'd like to always pull the last value in the field but am not sure how to configure this in my DTL.

The repeating field is in PV1:50().1

Could somebody shed some light on this?

Examples:

|15081942~15081951~15108961~15280550|

|15081947|

|15081939~15081940|

Thanks

*Analista Ensemble Júnior / Pleno

Próximo Metrô Clínicas

REQUISITOS:
* Conhecimento em barramento e protocolos RESTFull / SOAP 
* Integração com banco de dados Oracle / SQL Server

ATIVIDADES:
* Integração de sistemas hospitalares
* Administração do ambiente Ensemble
* Análise de Dados

Enviar CV com pretensão salarial
.

Contratação CLT ou PJ tempo indeterminado

Empresa ..................: JHealth Informatics
Email ........................: rh@jhealth.com.br

I'm just clarifying that 2017.1 is viable on 8.4-1H1. can someone please confirm, also what kind of support would we receive if we upgraded to 8.4-2L1?  I know that 2015.2 works on it. yet it says it's not supported. 

we really need to get to 8.4-2L1.  any help would greatly be appreciated.

thanks

Paul

Flyway is a open source product used to develop database code to migration, ddl version control, automate database procedures, etc. It is the most used product to do DevOps automation procedures to database. Do you consider create iris support to flyway?

https://flywaydb.org/documentation/contribute/contributingDatabaseSupport

In addition to charts on a dashboard we have a request to have a crosstab which would be populated by some entries queried out of an error log.  It's basically a detail query with mostly text data.  I have tried making a pivot widget for this using both a cube and kpi source, and while succeeding with the KPI, it leaves a lot to be desired. 

Firstly, the cube is a no go.  As far as I can tell the MDX subsystem in IRIS does not handle empty cells efficiently like other MDX systems such as Oracle's and Microsoft's.

How do we return a member from a set?  For example if I want a calculated measure to return the NAME of the date with the max transactions, to get the set ordered I might do something like:

ORDER([TransactionDate].[YearMonthDate].[Date].MEMBERS, [Measures].[TransactionCount], DESC)

But how do I access the first member in the set as a member so that I can get to the properties such as the member NAME (what I want to return in this case)?

In some MDX implementations like Microsoft there are kind of backdoor functions for this like:

ORDER([TransactionDate].[YearMonthDate].[Date].MEMBERS, [Measures].

Hi.

How can I add/substract hours from $Horolog in ObjectScript and the date part of $H is also affected?

Regards,

Matjaž

Two permanent job opportunities for Caché Developer/Programmers. Small company, remote positions. Offices located in Philadelphia and Ft. Myers, FL. Development team retiring in next two years. Looking for new team. Excellent benefits including stock options and work environment. Travel and financial services industries.

For further details, please send your CV to patrick.glynn@shelbyfinancialcorp.com

How to implement transaction processing when using healthConnect to link external data for data operation

Hi Community,

Find out how you can use the open-source iKnow engine in Python within InterSystems IRIS.

⏯ Using the InterSystems iKnow Engine in Python

Hi -

I know this is very "newby" of me, but here goes..

I have moved some classes onto my server, but these have never been in VSCode as edited files, and I'm just not finding the magic command or button or drop-down that says "pull this file from the server and make me a local copy to edit. I can see the class files on the server using the ObjectScript plugin - but I just can't find out where to make a local copy for editing

Thanks

I've define an upstream object in the IAM 0.34-1 and in it 3 targets. I now want to remove 1 of those targets.

I can not find the way to do that.

Hi ! 

There is a BusinessService be called by several callers,but now I get this error below on Event Log page:

<Ens>ErrGeneral: Failed to create document from string:

ERROR #6301: SAX XML Parser Error:processing instruction cannot start with 'xml'
while processing Anonymous Stream at line 1 offset 106

What may be the cause of this error？

How can I locate the parameter that caused this error?

Hi,

I use terminal + dbeaver,When I open the new terminal again,  will prompt the license information.

Is this database free？

Image search like Google's is a nice feature that wonder me - as almost anything related to image processing.

A few months ago, InterSystems released a preview for Python Embedded. As Python has a lot of libs for deal with image processing, I decided to start my own attemptive to play with a sort of image search - a much more modest version in deed :-)

A tast of theory 🤓

In order to do an image search system, fist it's necessary select a set of features to be extracted from images - these features are also called descriptors.

The docbook chapter "Importing XML into Objects" has the following tip:

You can call the Correlate() method repeatedly to correlate more than one element, although the examples in this chapter show only one correlation.

Does anyone have a good example of multiple correlations?  I've got code running that does multiple imports of the same file while changing the correlation and it's inelegant and not really what I want.

Hey developers,

As you know, the InterSystems Multi-Model contest has already ended. And now we want to get feedback from those developers who were unable to participate.

Please answer some questions to help us improve our contests! 

👉🏼 Quick survey: InterSystems Multi-Model Contest Survey