go to post Mark OReilly · Feb 16, 2023 Thank you, it is a 700gb database, good to know this is ok thought this would be the case so will go with this strategy of truncating
go to post Mark OReilly · Sep 27, 2022 Can the import/export code finally used Mike be shared as a solution for this? Would be useful
go to post Mark OReilly · Aug 24, 2022 Thanks didn't see that have changed to the below which works from your answer Set node = $Query(^FromExtraMed(""),1,nodevalue) while (node '="") { write nodevalue,! Set node = $Query(@node,1,nodevalue) }
go to post Mark OReilly · Jul 27, 2022 Solved by WRC. By pressing enter first on the Search bar then this issue disappeared. Issue presumed browser Caching issue
go to post Mark OReilly · Jun 23, 2022 The example with the @ with this still brought back any other nodes of je1 not just that "not configured" node found the following to do what required from Use a global stored in variable. | InterSystems Developer Community | s global="^je1(""NotConfigured"")"s sub=""f s sub=$o(@global@(sub)) q:sub="" w !,sub
go to post Mark OReilly · Jun 23, 2022 Hi Still not working. Might be my misexplaining Two values from the global veiw page 1: ^je1("NotConfigured","CBB") = "" 2: ^je1("NotConfigured","CH11") = "" Total: 2 [End of global] All i'm getting is the first Set node = $Query(^je1("NotConfigured")) WRITE !,node FOR { SET queryary=$QUERY(node) QUIT:queryary="" WRITE !,queryary SET node=queryary } In terminal we would have used ^%G then je1("NotConfigured", looking the exact same but in code in objectscript queryary is blank after the first query so node is blank
go to post Mark OReilly · May 19, 2022 Thanks Oliver this has been great. I have created a fork of this original code for our own use- i don't use github too much so hope this is an ideal way to keep the information sharing from your initial work done that was great. I have not included on an error section due to trying to keep things simple on a monitor screen but it could be added if others wish. If there are further updates will try keep my code on github for this up to date if possible and still quite non bespoke as seems fair for anyone who wants a better solution.
go to post Mark OReilly · May 13, 2022 I plan to be accessing it via a website saved in intersystems server to be accessed on the server. I have some ideas how it will look/work. Is mainly the finding the current errored services as one of the things I just can't seem to find in existing code how to get the status. I plan to have any suspended and queues or where intersystems has stopped a operation because of E=D but think I know ways to get the rest of this to make a really nice clean clear monitor page