go to post Mathew Lambert · Oct 25, 2021 That's for sure, changing the $Timezone is the last approach. However I've been testing with HS.Timezone.Server.Service and I think that I'm getting something useful, and seeing the docs I'm seeing that it has the TZ database embedded
go to post Mathew Lambert · Oct 23, 2021 Of course future can't be predicted but each release can have the up to date DB. Will do it via Java or Py with a connector
go to post Mathew Lambert · Oct 22, 2021 It shows the server offset to UTC. My tasks look like this: Take out trash 08:00 Europe/Madrid Take out trash 08:00 Asia/Tokyo Take out trash 08:00 America/New York These tasks are executed every day, and need to be executed on my server that is in Africa/Cairo timezone, but need to be executed at the correct UTC time. Today (22 October 2021) the UTC conversions for 08:00 of the indicated timezones are as following 06:00 22.Oct 23:00 21.Oct 12:00 22.Oct But on november the 10th it will be 07.00 10.Nov 23:00 9.Nov 13:00 10.Nov That times are the UTC times when I need to execute my task. How can I convert 22 October 2021 08:00 Asia/Tokyo to 21 October 2021 23:00 UTC
go to post Mathew Lambert · Oct 22, 2021 Using any of both method I've got the same problem, how do I know what is the offset for "Europe/Madrid" today, tomorrow, or any given day?
go to post Mathew Lambert · Jan 14, 2021 Until now in caché we where checking $ZERROR, but as InterSystems is descouraging the use of that variable, I don't know how to surely test this command.
go to post Mathew Lambert · Jan 14, 2021 The issue with this option is that on a productive environment, inmediately after purguing the queries, I've got new queries.
go to post Mathew Lambert · Dec 14, 2020 Class dependency tree builder, this should support dynamic dependencies used.
go to post Mathew Lambert · Dec 14, 2020 System configuration. There are so much settings all over the application that it would be great to have a configuratino wizard divided into categories.
go to post Mathew Lambert · Dec 10, 2020 Having a configuration tool in the management portal to help with all the settings.
go to post Mathew Lambert · Oct 19, 2020 Well this kind of old post revives again... I have two mirror members that say "This member is not connected to the arbiter". The three machines are in the same subnet, all IPs configured, pings responding...
go to post Mathew Lambert · Jul 7, 2020 As it seems that there is not the possibility to do this as of now, we will be talking with InterSystems.
go to post Mathew Lambert · Jul 7, 2020 So, to sum up, the best strategy would be to define properties on each of the tables and then also FKs to ensure referential integrity
go to post Mathew Lambert · Jun 16, 2020 Did you take a look into the embedded reporting solution? https://cedocs.intersystems.com/latest/csp/docbook/Doc.View.cls?KEY=GRPT_report_running#GRPT_xslfo_pdf_config There is an embedded built-in FOP
go to post Mathew Lambert · Jun 16, 2020 I'm trying to avoid wrapping %persistent methods because this could lead to problems between releses those methods are final (so I would need to wrap them in a different named method Regarding your points, we don't generate classes via DDL and to force inheritance I would just implement a test and add it to our Persistent classes Best Practices. Thank you
go to post Mathew Lambert · Jun 16, 2020 I know how to obtain the status from the call, but I want to have a method that I can implement in an abstract class, that I inherit in all my persistent classes, and with very few lines of code I can track all CRUD operations.
go to post Mathew Lambert · Jun 16, 2020 There is now a plugin https://openexchange.intersystems.com/package/vscode-multi-connection
go to post Mathew Lambert · Jun 15, 2020 There is no pretty way to do it via management portal. Either use a JDBC tool like squirrel or sql workbench, or use an sql file with do $System.SQL.DDLImport
go to post Mathew Lambert · Jun 15, 2020 Hello Fabio, we have very simple code that goes via zf I'm not able to attach the class to the post, but i add it to gdrive: https://drive.google.com/file/d/1IdEDWRasNOlLfeO1zZiZ9tRDgDpr3S8t/view?u...
go to post Mathew Lambert · Jun 15, 2020 We use the license via a customized page that imports the file, the validation is done by zipping the license file and an expected checksum. The user workflow is that we link the type of request with the type of license to use in our delegated authentication, consuming depending on the entry endpoint.