go to post Mark OReilly · Jul 16 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") :
go to post Mark OReilly · Jul 16 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.
go to post Mark OReilly · Jul 15 ah it's closed now, no matter, hopefully in clearer format anyway now for actioning
go to post Mark OReilly · Jul 15 I have updated the structure on my 2 ideas, wasn't aware of the contest, was just creating ideas
go to post Mark OReilly · Dec 18, 2024 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
go to post Mark OReilly · Dec 18, 2024 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
go to post Mark OReilly · Dec 17, 2024 goes no job id selected when you click abort and not shown in processes everything there has ids
go to post Mark OReilly · Dec 3, 2024 Other option from WRC we were told. Export and import the OAUTH2 globals and import
go to post Mark OReilly · Oct 25, 2024 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?
go to post Mark OReilly · Aug 27, 2024 Rewrote the statement so going to mark Eyal's answer as accepted as it was the correct approach to try a different conversion function.
go to post Mark OReilly · Aug 27, 2024 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.
go to post Mark OReilly · Aug 5, 2024 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
go to post Mark OReilly · Aug 5, 2024 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
go to post Mark OReilly · Aug 2, 2024 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
go to post Mark OReilly · Jul 10, 2024 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.
go to post Mark OReilly · Jun 28, 2024 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?
go to post Mark OReilly · Mar 13, 2024 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
go to post Mark OReilly · Feb 20, 2024 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.