All
Accepted answers
Mark OReilly · Nov 10, 2025 go to post

In a "code" block

Basically within it trying to error the transform when date invalid 

Mark OReilly · Oct 28, 2025 go to post

Yeah it is probably the way too do it; just it transforms it as part of that send so it's a loop it in same router job or pass it on to another router to go to the operation so was wondering if there was another way without this but doubt there is 

Mark OReilly · Oct 13, 2025 go to post

I don't really understand the best practices on building the IRIS REST apps and passing authentication through. 

I.e. do people just tend to authenticate the CSP page it goes to and that is fine .

Or after the authentication method do they tend to use that same user logged in to make the API call? 

i.e. (although should be in .env) do rest apps tend to look for if iris is authenticated or should it just use a set up user and pass to make the API call?

Mark OReilly · Oct 10, 2025 go to post

I dont understand. Password and ldap is allowed so yes it works; but thats with a hard coded user how can it use iris logged in user?

Mark OReilly · Sep 29, 2025 go to post

If you need any help with the example api let me know, annoyingly teams didn't record the audio and i haven't had time to re-record it along with the second version of the code we created

Mark OReilly · Jul 16, 2025 go to post

Thanks i had looked at the documentation the insert data from another table and the defining a table from another table. 

Yes the syntax wasn't quite like documentation (was solid normal sql syntax i think) . Still doesn't seem to like it via linked table 

ERROR #5475: Error compiling routine: %sqlcq.SRFT.cls301. Errors: %sqlcq.SRFT.cls301.cls ERROR: %sqlcq.SRFT.cls301.1(19) : <UNDEFINED>parseExtFromNode+1^%qaqcmx *mt("f","1^SAMPLE.TEST") :

Mark OReilly · Jul 16, 2025 go to post

Think linked table is external software running a cache db backend. It is IRIS for Health 2024 that is used as the TIE. 

The Foreign Table functionality is not free, it need to be part of the IRIS licence to allow you to use it, as i requested it and was told it would need added onto the licence to enable this feature. 

Mark OReilly · Jul 15, 2025 go to post

ah it's closed now, no matter, hopefully in clearer format anyway now for actioning

Mark OReilly · Jul 15, 2025 go to post

I have updated the structure on my 2 ideas, wasn't aware of the contest, was just creating ideas

Mark OReilly · Dec 18, 2024 go to post

EnumerateJobStatus returns what portal sees 

while resultset.%Next() {do resultset.%Print()}
"PAS Outbound Process"  OK  "2024-12-05 14:22:55.320" 1
"PAS Outbound Process"  OK  "2024-12-05 14:22:55.322" 1
"PAS Outbound Process"  OK  "2024-12-05 14:23:00.425" 1
"PAS Outbound Process"  OK  "2024-12-05 14:37:09.665" 1
"PAS Outbound Process"  OK  "2024-12-05 14:37:09.666" 1
"PAS Outbound Process"  OK  "2024-12-05 14:37:09.667" 1
"PAS Outbound Process"  OK  "2024-12-05 14:37:09.669" 1
"PAS Outbound Process"  OK  "2024-12-05 14:37:09.670" 1
"PAS Outbound Process"  OK  "2024-12-05 14:37:09.671" 1
"PAS Outbound Process"  OK  "2024-12-05 14:37:09.672" 1
"PAS Outbound Process"  OK  "2024-12-05 14:37:09.673" 1
"PAS Outbound Process"  OK  "2024-12-05 14:37:09.674" 1
"PAS Outbound Process"  OK  "2024-12-05 14:37:09.676" 1
"PAS Outbound Process"  OK  "2024-12-05 14:37:09.677" 1
"PAS Outbound Process"  OK  "2024-12-05 14:37:43.162" 1
"PAS Outbound Process"  OK  "2024-12-05 14:38:31.334" 1
"PAS Outbound Process"  OK  "2024-12-05 14:39:08.718" 1
"PAS Outbound Process"  OK  "2024-12-05 14:39:31.265" 1
"PAS Outbound Process"  OK  "2024-12-05 14:41:07.591" 1
"PAS Outbound Process"  OK  "2024-12-05 14:42:07.282" 1
"PAS Outbound Process"  OK  "2024-12-05 14:47:07.486" 1
"PAS Outbound Process"  OK  "2024-12-05 14:47:55.697" 1
"PAS Outbound Process"  OK  "2024-12-05 14:50:31.971" 1
"PAS Outbound Process"  OK  "2024-12-05 14:50:55.610" 1
"PAS Outbound Process"  OK  "2024-12-05 14:51:12.143" 1
"PAS Outbound Process"  OK  "2024-12-05 14:51:49.692" 1
"PAS Outbound Process"  OK  "2024-12-05 14:51:59.348" 1
"PAS Outbound Process"  OK  "2024-12-05 14:52:08.554" 1
"PAS Outbound Process"  OK  "2024-12-05 14:52:32.065" 1
"PAS Outbound Process"  OK  "2024-12-05 14:53:00.146" 1
"PAS Outbound Process"  OK  "2024-12-05 14:53:56.552" 1
"PAS Outbound Process"  OK  "2024-12-11 06:59:22.608" 1
"PAS Outbound Process"  OK  "2024-12-11 06:59:46.682" 1
"PAS Outbound Process"  OK  "2024-12-11 07:00:34.744" 1
"PAS Outbound Process"  OK  "2024-12-11 07:00:46.823" 1
"PAS Outbound Process"  OK  "2024-12-11 07:01:22.856" 1
"PAS Outbound Process"  OK  "2024-12-11 07:03:46.967" 1
"PAS Outbound Process"  OK  "2024-12-11 07:07:53.180" 1
"PAS Outbound Process"  OK  "2024-12-11 07:09:41.327" 1
"PAS Outbound Process"  OK  "2024-12-11 07:15:35.702" 1
"PAS Outbound Process"  OK  "2024-12-11 07:17:47.825" 1
"PAS Outbound Process"  OK  "2024-12-11 07:18:35.831" 1
"PAS Outbound Process"  OK  "2024-12-11 07:23:24.191" 1
"PAS Outbound Process"  OK  "2024-12-11 07:27:00.354" 1
"PAS Outbound Process"  OK  "2024-12-11 07:33:18.946" 1
"PAS Outbound Process"  OK  "2024-12-11 07:50:25.979" 1
"PAS Outbound Process"  OK  "2024-12-11 07:50:38.109" 1
"PAS Outbound Process"  OK  "2024-12-11 07:51:14.008" 1
"PAS Outbound Process"  OK  "2024-12-11 07:52:38.147" 1
"PAS Outbound Process"  OK  "2024-12-11 07:54:26.438" 1
"PAS Outbound Process"  OK  "2024-12-11 17:56:14.557" 1
"PAS Outbound Process"  OK  "2024-12-13 15:22:56.105" 1
"PAS Outbound Process" 12648 OK  "2024-12-18 14:15:16.105" 18

Mark OReilly · Dec 18, 2024 go to post

Ens.Job_Enumerate() returns only 1

I'm unable to run Call Ens.Util.Statistics.EnumerateJobStatus('name') or Call Ens_Util.Statistics.EnumerateJobStatus('name') as it errors in portal saying reserved word STATISTICS found

Mark OReilly · Dec 17, 2024 go to post

goes no job id selected when you click abort and not shown in processes everything there has ids

Mark OReilly · Dec 3, 2024 go to post

Other option from WRC we were told. 

Export and import the OAUTH2 globals and import 

 

Mark OReilly · Oct 25, 2024 go to post

I think it might be my misunderanding of how the rule editor works with foreach but the documentation is not clear 

I would expect to see trace "1" send, trace "2" send, not it running through the foreach until the end have a count of how much it succeeded and then send with userdata "2" twice. Is there a way to change this? Why it is this way around?

Mark OReilly · Aug 27, 2024 go to post

Rewrote the statement so going to mark Eyal's answer as accepted as it was the correct approach to try a different conversion function. 

Mark OReilly · Aug 27, 2024 go to post

Closing- this went to a WRC- even making a helper class wouldn't make it work like we would expect it to work. 

There is a JIRA for message bank to be improved- as realisitally is should be more like a standard Async member where you could have a different message purging cycle on it i.e. maintain on it for 1 year while only 30 days on main ect. 

Mark OReilly · Aug 5, 2024 go to post

The output is available in ^OrphanedMsgTask global if you view the message of the Messages succeeded and Messages Failed counts.

This could have been more elegant if i knew how to actually put that info into the task output itself but i couldn't get it to work

Mark OReilly · Aug 5, 2024 go to post

Hi:

The reason for counts rather than days was a more granular approach to deleting data with no day information about it i.e. Stream data which would not have a date assigned to it.

Also a lot of custom data ends up in the same table if you don't define a new location for the message data. This would cause an inability to run proper sql against it to clear out the data so a count based approach of where the last message id was required 

Mark OReilly · Aug 2, 2024 go to post

I had a look but still couldn't see where exactly zenPage is defined to be able to call one of the scripts to use the getComponent function from an external js script

Mark OReilly · Jul 10, 2024 go to post

Hi Josh:

It's interesting you find it is an intermittent issue. We had some very large rules and when we turned on the new rule editor no matter what would get an :( face. 

If we deleted a few rules up to a certain amount this would load up correctly. 

If you look in your devtools when this happens it is a timeout issue where the connection is being closed prior to the rule having loaded. 

With asking WRC and pointing out the issue the :( issue was replicated in 2023.1 but did not happen in 2024.x. 

What I think it is is the gateway timeout time is too small and if you update the timeout to a bit longer it might allow the web application to load. 

Alternatively go to web application /ui/interop/rule-editor and disable the application to go back to the old rule editor. This issue and No crtl+f find functionality has caused many people to divert from the new editor until it is optimised, as well as i believe in 2023 too much whitespace. 

Mark OReilly · Jun 28, 2024 go to post

Hi: 

I added a query in the q&a a month ago, as we are ready to use this my question was:

In a shared Mirrored environment where do you put the local git folder/ where is best. 

What happens if the server the local git goes down does this have any impact on any development on live while the local git isn't available?

Mark OReilly · Mar 13, 2024 go to post

IRIS for Windows (x86-64) 2022.1.2 (Build 574U) Fri Jan 13 2023 15:00:26 EST [Health:3.5.0-1.m1]

This has been an upgraded version from a previous i think 2016 version about a year and a half ago

Mark OReilly · Feb 20, 2024 go to post

Hi:

That's what i was trying to do as a calculated/computed field. 

Basically the table used states further what length the field is left/right padding and what string record it should be. 

I have a suitable enough work around not using a computed field. 

Mark OReilly · Feb 20, 2024 go to post

Thanks:

Over the weekend a viable solution has been found for this. A decision was made that actually the code being ran was probably too complex to be a computed field. This code was originally written in a Business process. The solution was to amend the custom method of the process and call a classmethod for this which could be run in a dtl or when setting up the class. 

The scenario was we had a property that is a long string of all the other values 

Decided best just to add to any DTL 

I would prefer it generating the function when the dtl is complete ect in the class without having to call it externally but i doubt it is actually possible

Mark OReilly · Feb 17, 2024 go to post

To clarify my question this is the library property helper class Library property helper when you look at the documentation for computed from documentation here Computed documentation

ClassMethod FullNameComputation(cols As%Library.PropertyHelper) As%String
{
    return cols.getfield("FirstName")_" "_cols.getfield("LastName")
}
// ...

But you can't seem to throw a parameter i.e.par= "Firstname" cols.getfield(par) in the code without it throwing errors

Mark OReilly · Jan 19, 2024 go to post

Thanks very clever i have used Code writes before including this week and showing a colleague using writes out for variables, didn't think that of course you could write out the raw content, looks good and very useful