Article Daniel Aguilar · Mar 18 3m read Stored Procedures the Swiss army knife of SQL One of the reasons why I love Cache and Iris is that not only you can do anything you can imagine, also you can do it in a lot of different ways!!. Imagine that you have an integration running with IRIS connected by ODBC you probably only run SQL queries but you can also create stored procedures and inside write the code to do everything you can imagine. I'm going to give you some examples but the limit is your imagination!! #SQL #Tutorial #Caché #InterSystems IRIS 10 1 1 136
Article Daniel Aguilar · Feb 12 6m read How to add Api-Key validation in REST requests Hi! recently I have to apply api-key validation to a web app with a lot of endpoints and I'm going to tell you how I did it in a centralized way. I'm going to explain you how we can apply in a generic way (or not) api-key validation to all the endpoints of our web app. #API #REST API #Security #Caché #InterSystems IRIS 1 0 1 54
Article Daniel Aguilar · Feb 5 2m read COS Url Shortener Hi Community! I want to share with you mi first Open Exchange application. It's a tool to made our developments easier. It's a micro service in a IRIS docker that help us in our new features giving us a way to add short links in our SMS, Email campaigns and for links of the different stores for our apps. It's very easy to use it. Simply clone this repo: https://github.com/daniel-aguilar-garcia/cos-url-shortener.git #Contest #REST API #Tools #Caché #InterSystems IRIS #InterSystems IRIS for Health #Open Exchange Open Exchange app 1 0 0 61
Article Daniel Aguilar · Oct 12, 2022 2m read New Feature %ZEN.proxyObject send numeric as String Hi Developers!!, I know what you are thinking... a new feature for ZEN.proxyObject...? NOW..??? In Spain we say that better late than never ;-) Have you ever need to send a numeric attribue of a Json in String format? Did you go crazy casting class objects with fixed typed properties? Lucky you!! With this new feature I propose a way to continue working with our loved dynamic object %ZEN.proxyObject, being able to choose whether or not we want to send numeric attributes in String format. #JSON #Caché 2 1 0 205
Question Daniel Aguilar · Mar 30, 2022 $ZTIMESTAMP in local time How do you get a $ZTIMESTAMP in local time?. I have found this solution and it works: Set LocalTimestamp=$ZDATETIMEH($ZTIMESTAMP,-3) Do you use any better way? #ObjectScript #Caché 0 5 0 192
Question Daniel Aguilar · Jul 13, 2021 Initialise object list How do you initialise a list of objects of a particular type? I have tried the following code and I get an undefined when I try to insert. I can do this and it works but I don't know if it is correct. Is there any way to do something like this? Set a= New list of Accciones() Thank you. #ObjectScript #Caché 0 3 0 158
Question Daniel Aguilar · Jul 13, 2021 Method return List of type Good afternoon I am making a method of a class that I want to return a list of objects of another class that I have defined, example: ClassMethod myMethod() As list of MyPackage.MyClass{} But it gives me a syntax error, I try this and it works: ClassMethod myMethod() As %ListOfObjects{} But I would like to keep the typing. Is there a way? #ObjectScript #Caché 0 5 0 212
Question Daniel Aguilar · Nov 4, 2020 Avoid $c(0) in globals Good Morning, I have this question for a long time. When I make an insert by SQL from an external application in the fields of type %String, if they are empty, it writes the character $c(0) in the global. Is there a way so that if an Insert is received in a field of type% String with null value instead of the $ c (0) it leaves it empty?: #.NET #Globals #SQL #Caché 0 7 0 630