All
Accepted answers
Mark OReilly · Mar 30 go to post

Thanks that is what the vibe i got and what AI leant towards. 

I see now it is baked in this tIsLookup bascially saying it needs to be in the Ens Rule function set or Util function set and it's called Lookup or for the exists function. It is no problem it was just an ask if missed something, can always select the standard one if need the lookup dropdown then write v2 afterwards. 

Set tIsLookup = ((tClassName = "Ens.Rule.FunctionSet") || (tClassName = "Ens.Util.FunctionSet")) && ((tFunctionName = "Lookup") || (tFunctionName = "Exists"))
Mark OReilly · Mar 30 go to post

Thanks this looks right and indeed i think a correct answer for use in other classes. 

I gave this a go pretty much (less elegantly)

SELECT List(distinct TableName) FROM Ens_Util.LookupTable
Parameter SETTINGS = "LookupTableName:selector?context={MyApp.Utils.LookupHelper.GetLookupTableNames}";
Property LookupTableName As %String;

In my case like Julian says think it's baked into the zen page within the dtl editor

Mark OReilly · Feb 25 go to post

Also saving passwords has led to somewhere a password getting cached and kept locking out my AD account dispite updating them all and had to reset studio extension completely so don't want to save passwords 

Mark OReilly · Feb 25 go to post

Thanks the option to have this off would be nice. I appreciate the standard logic as a "sign in once" design, it just becomes an annoyance of a multi system multi tie model on one workspace which i suspect having one workspace in the norm as someone just then opens the server they want from that. I could have 6 login prompts every time when I only want to select one of those 6

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.