#InterSystems IRIS

Hi,

I'm after feedback and comments on the sort of tools and approaches the wider InterSystems community uses for QA Testing applications written in Cache/Ensemble or IRIS. I am aware of the %UnitTest package, and understand how that works... but:

- Do you use an alternative or framework built around this native Unit Testing tool ?

- What is your experience with %UnitTest if you use it ?

- Is there a tool you would recommend for your UI (I know this is not specifically an InterSystems' related question)

I was hoping for some input on the best way to deploy code to site with the following criteria:

- No source code, only compiled code to be deployed.
- Classes and Routines are part of the application.
- Data and code reside in the same database.
- Deployments might be partial updates (i.e. cannot just send a complete CACHE.DAT).

At present the idea is just to export the .obj, any suggestions?

As a normal IRIS user how can I view who's made changes to a process? There are over 10 people on my current team and it would be amazing to be able to click on a process or rule and see who created it or who made the most recent changes. I'm not seeing anything in the documentation. Journaling doesn't seem to capture that information either.

The question is pretty much in title. I'm developing a REST API, it has a search endpoint with 10 optional parameters. How do I pass them and stay RESTFul?

To ease the question a bit let's agree that:

• all parameters are AND parameters, user can't make combos, ORs, etc. User can only provide values
• all values are integers so I don't have to think about URL limits
• all values are atomic
• all conditions are about equivalency

Some options I know of:

1. URL parameters.

I'm trying to convert a CSV inbound to an HL7 MFN^M16 outbound. I know I'm using book information as the CSV but I don't think that matters. Please let me know if that's incorrect.

My service is reading the file in just fine and when I don't have a DLT transformer the raw message passes through to outbound file folder just fine. However, when I include a basic DLT that simply copies a couple of fields over I get the "Ens.StreamContainer" error. Everything also seems to be good in the Record Mapper.

I need to know the current rss memory consumption. On earlier Cache versions I used this method:

set sc = ##class(%Net.Remote.Utility).RunCommandViaZF("smem -u cacheusr | grep cacheusr | awk '{print $6}'",,.rss)

It doesn't work because we use $zf(-100) on IRIS 2019.1.

New version:

Hi Team,

When I use below statement , I got SQLCODE=0.

SET rs = ##class(%SQL.Statement).%ExecDirect(, "SELECT * FROM LISDB.ExternalUsers WHERE UserId = 83")

If I display above query using Write (rs.%Display()) it gives me below result but (rs.%Get("Prefix")) method give me null value.

Please help

What's the best way to replace character groups?

I want not to remove character groups as $zstrip does but to replace them with whitespaces.

$translate needs explicit character list.

Effectively I want to remove any characters besides letters, numbers and a small (known) subset of punctuation characters, replacing everything else with whitespaces.

Hi all,

I recently discovered the Monitoring Activity Volume feature in IRIS and I was amazed by it. So, I put it to work in one of our productions. It is nice how easy it is to set up and all the possibilites that came with it.

But there's something weird: the numbers. Actually, one of the BP is stating a time of more than 6 seconds to process:

Hello Everyone,

I want to Know Caché or IRIS has some way to communicate with DDE or RTD from Excel?

Att. Flávio.

Hi,

I want to do ordering dynamically in Query. I mean to say that order by value will not be hard coded in query, it will be passed in parameter.

I have tried to it following way, but it is not working for me. Can you please advise me how can I achieve it?

In below code, Order by :objSearch.SortingField is not working.

OAuth server to be deployed on the IRIS learning cloud platform. Clients - one on the other instance of the learning IRIS server, the other client locally on my computer in the container docker.

Both clients get a seemingly correct link (through ##class(%SYS.OAuth2.Authorization).GetAuthorizationCodeEndpoint()) to the login request form:

I got below error when passing Date in timestamp format.

I am using %JSON.Adaptor. Please refer screen 2

I need RowId of inserted record.

I have used below logic to get max row id,

but it will not give desired result when multiple people enter record in the table at the same time.