Question Mathew Lambert · Oct 22, 2021 Trouble working with different timezones Quite a complex scenario we are trying to solve but should be able to understand. We're developing a task executer that runs on a server with a certain timezone. The tasks run every day at a defined time, but in different timezones. We're saving in database at what time we want to execute the task, and in what timezone (don't go to the save in UTC pitfall, as with DST it will be at different times) What I want to do if when opening a task from the database, convert 02:00 Europe/Madrid, either to UTC or to local (server) time. #InterSystems IRIS #InterSystems IRIS for Health 0 11 0 646
Question Mathew Lambert · Jan 12, 2021 Testing if SQL PurgeForTable went wrong Does anybody know if there is an easy way to know if the execution of the command $System.SQL.PurgeForTable went well/wrong? The documentation describes that a string is returned, but in fact there is a nice Quit "" in the code. Maybe inside PurgeForTable^%apiSQL there is any process variable set when it goes well/wrong? Thank you very much! #SQL #Caché #InterSystems IRIS 0 5 0 198
Question Mathew Lambert · Jul 20, 2020 Is PBKDF2 with HMAC-SHA at 512 bits encryption, in line with NIST / FIPS recommendations? We are using the mentioned password function and we need to know if is in line with the NIST recommendations regarding strength, https://nvlpubs.nist.gov/nistpubs/FIPS/NIST.FIPS.180-4.pdf #InterSystems IRIS 0 1 0 1.2K
Question Mathew Lambert · Jun 23, 2020 Best way to implement a one-to-one relationship I know that 1-1 relationships are not officialy supported by intersystems cache/iris so I want to know the best way to store data with this kind of data model. Currently I have two classes that where implemented some time ago: Table A with a relationship type one on table B Table B with a relationship type one on table A To compile I have a double compile with qualifyer U. What is the best way to implement a data model with 1-1 relationships? Thank you #Databases #Relational Tables #Caché #InterSystems IRIS 0 6 0 574
Question Mathew Lambert · Jun 16, 2020 CRUD result callback for persistent classes I would like to know if there is a way of having a callback or something similar, on persistent classes that is always called after the execution of the operation (failed or successfull). %OnOpen is executed prior to the action, and there is no post callback %OnAfterDelete and %OnAfterSave are executed after a successfull operation #Databases #InterSystems IRIS 0 8 0 259
Question Mathew Lambert · Apr 28, 2020 Ensuring that no plans are frozen after version upgrade I've been reading the documentation guide for 2018.1 over frozen query plans several times in the last days (link) and there is an answer I can't seem to find directly. My on-premise upgrade way is: #Databases #Caché 0 1 0 201
Question Mathew Lambert · Feb 12, 2020 Get all collation number and names I've recently encountered a HS Caché that won't start informing that Collation 30 is not available, but I have not found an easy way of knowing what collation is 30. I've found that the following command returns the ones from the current locale, but not from all locales: Set Rset = ##class(%ResultSet).%New("%Library.Collate:CollationList") d Rset.Execute() While (Rset.Next()) {zw Rset.Number_": "_Rset.Name} Thank you #Localization #Caché #HealthShare #InterSystems IRIS 0 2 1 305
Question Mathew Lambert · Jun 6, 2018 Send PATCH http call I need to send a PATCH call from the server to a given url.Until now I was using %Net.HttpRequest to issue calls for get/post/put but today I had to make a PATCH and I can't find a way to do it. #Caché 0 1 0 665
Question Mathew Lambert · May 23, 2018 ##class( autocomplete for classnames In Studio whenever you write ##class( and then you start writing it will autocomplete the classname.I can't find how to do that in atelier. #Development Environment 0 8 0 458
Question Mathew Lambert · May 3, 2018 Execute method on failover member (mirror) I need to know what options exist to execute methods on the failover members of a mirror system from the primary. #HealthShare 0 4 0 380