go to post Oliver Thompson · Jul 1 Deferred only relates to the unlock command, see here for some more details. Basically, the unlock does not happen immediately, it will be done at the end of the transaction. ideally, this is what you want, and as long as your transactions are quite quick, it won't be an issue. https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls...
go to post Oliver Thompson · Jun 20 One other thing to note is that you should not put any long running processes in %ZSTART as they will hold up the Start process. If you have to, then consider JOBbing it off to a separate process, so it can run in the background and allow the rest of the startup steps to run in parallel.
go to post Oliver Thompson · Jun 19 You can customise the refresh at the Backup Stage, you can define the list of Databases that will be Backed up before running the Backup. See here for more details:https://docs.intersystems.com/iris20241/csp/docbook/DocBook.UI.Page.cls?... But please make sure you test this in a development environment before touching your live system.
go to post Oliver Thompson · Jun 17 Have you tried F11? You may have to change the settings in vscode to recognise F11 as a Debug Command, rather than the "Fullscreen" command. Apologies, I don't have vscode installed, so can't check myself. See here for more information:https://stackoverflow.com/questions/29955146/unable-to-debug-with-f11-wi...
go to post Oliver Thompson · Jun 13 Thanks for the clarification. The answers from @Manel Trèmols and @Ramil TK should both work for you. You might have to do some additional formatting depending on what datePart you getting the difference in. For example if you get the difference in Minutes ("n"), then you will have to convert that into Days, Hours, Minutes etc, so it will depend on what you are expecting in the data and how big those differences might be.
go to post Oliver Thompson · Jun 11 Can you clarify what you are trying to do please? Are you trying to calculate the difference between the 2 dates/times? If that is the case have a look at the DATEDIFF(..) SQL functions.https://docs.intersystems.com/iris20241/csp/docbook/Doc.View.cls?KEY=RSQ...