Question Evgeny Shvarov · Nov 9, 2021 How Can One Logout From REST API Hi folks! Consider you are logged in to a REST API in InterSystems IRIS with user A. What is the way to log out in a browser? E.g. to login with another user B? #REST API #InterSystems IRIS 0 4 0 241
Question Evgeny Shvarov · Aug 8, 2021 How can I get the name of the data database in the current namespace? Hi folks! Is there a way (function) to know the name of the database for data of the current namespace? I take the case where we have one database for data and another database for code in a namespace. Thanks! #Databases #Namespace #ObjectScript #InterSystems IRIS 0 4 0 480
Question Evgeny Shvarov · Jul 27, 2021 How to Turn Off Journalling Programmatically I need to turn off Journalling for a particular database programmatically. How can I make it happen? #Journaling #InterSystems IRIS 2 12 0 583
Question Evgeny Shvarov · Jun 10, 2021 Is it possible to grant sql access to schema? Hi folks! Here is how I grant SQL access of user to a particular class/table: GRANT SELECT, UPDATE ON Packacge_X.Table_Y TO UserZ How can I grant SQL access of a certain user to a whole schema? #Security #SQL #InterSystems IRIS 1 3 0 312
Question Evgeny Shvarov · Jun 8, 2021 Is there a way to export globals in XML via Management Portal? Hi colleagues! Is there a way to export globals in XML if I have the access to Management Portal or any other web app? Currently, it gives the option to export into gof format only. #Data Import and Export #Globals #Management Portal #InterSystems IRIS 0 5 0 330
Question Evgeny Shvarov · Apr 10, 2021 Do we have one-to-one relationships in IRIS? Hi All! Examining the page here I see we have one-to-many and parent-child relationships supported in the InterSystems Objects model. Do we support one-to-one too? #Object Data Model #InterSystems IRIS 0 5 0 244
Question Evgeny Shvarov · Mar 15, 2021 How can I add a button on a widget that will do an arbitrary code on a server? E.g. I want to add a button on a widget that will rebuild the cube when clicked. How can I make it happen? #Analytics #Dashboards #Visualization #InterSystems IRIS BI (DeepSee) 0 5 0 265
Question Evgeny Shvarov · Feb 8, 2021 What is the macro or internal function call for lib path for the IRIS installation? Hi folks! Each IRIS installation has a /lib folder which is intended for 3rd-party libraries being used in the solution. For IRIS installation the typical path is: /usr/irissys/lib/ In ZPM the shortcut is ${libdir}. What is the macro or internal function to obtain it programmatically? #Deployment #InterSystems Package Manager (IPM) #InterSystems IRIS 0 5 0 183
Question Evgeny Shvarov · Dec 8, 2020 REST API which accepts SQL and returns JSON Hi folks! Do we have an embedded REST API in IRIS which accepts arbitrary SQL and returns data in JSON? Or if anyone did something like this? The idea is to have something like MDX2JSON but SQL2JSON. Thanks! #JSON #SQL #InterSystems IRIS 3 11 0 461
Question Evgeny Shvarov · Dec 4, 2020 Macro to know all the parameters transferred to the method Hi folks! Often while debugging you want to know the values of all the parameters. Using VSCode Debugger is not an option. What do you use to know what parameters came to the method? My hope if you have a "magic" macro that will store all the variables with their names into a global? And share your approaches, please? #Debugging #ObjectScript #InterSystems IRIS 2 6 0 291
Question Evgeny Shvarov · Jun 28, 2020 Multiline code in terminal Hi, folks! Do you know the option/mode when I can feed multiline code into a terminal? E.g. for i=1:1:100 { /// do one line ///do something else} #ObjectScript #Terminal #InterSystems IRIS 1 14 0 705
Question Evgeny Shvarov · May 19, 2020 How can I check that the value is String or Integer or Date? I have the variable with literal. Can I understand with ObjectScript that the literal is: %String, or %Integer, or %Date, or %Double, or %Numeric? What I'm looking for could be: set variable="To be or not to be" USER>w ##class(utils).GetType(variable) %String set variable=42 USER>w ##class(utils).GetType(variable) %Integer #ObjectScript #InterSystems IRIS 2 9 0 2K
Question Evgeny Shvarov · May 19, 2020 Can I substitute table in FROM with a hosted variable? Haven't found this in the documentation. I want: &sql(SELECT name INTO :var FROM :table) Is it possible? #ObjectScript #SQL #InterSystems IRIS 0 7 0 282
Question Evgeny Shvarov · May 17, 2020 How to quickly obtain the number of records in a persistent class? Hi! Is there a method in a persistent class that can return the current number of records/persistent objects in it? #ObjectScript #SQL #InterSystems IRIS 2 15 1 717
Question Evgeny Shvarov · May 17, 2020 How to open IRIS terminal with docker in a particular NAMESPACE Hi folks! When I start IRIS in docker every time I do the following: $ docker-compose up -d --build $ docker-compose exec iris iris session iris USER>zn "NAMESPACEINEED" Is it possible to have an open terminal command connect to a particular namespace? #Docker #Namespace #Terminal #InterSystems IRIS 1 2 0 336
Question Evgeny Shvarov · Mar 20, 2020 How to add a role to a web applicaiton programmatically? Hi developers! I have an existing CSP app and I want to add a role to it. How can I make it programmatically? #CSP #Deployment #ObjectScript #System Administration #InterSystems IRIS 1 4 0 363
Question Evgeny Shvarov · Dec 26, 2019 How to Make One Docker Container See The Web Service of Another One? Hi Developers! I stuck with one interesting problem. For example, let's use this template repo. If you build this container A using docker-compose and then run the container it exposes REST-API which is available on: localhost:52773/person/all The question is how to make this REST-API accessible from another docker container B running on the same machine? E.g. with IRIS 2019.4 Community from this repo? The problem is that for the second container localhost it's something which belongs to container B. I think I need to set up a network between containers somehow. E.g. using docker-compose. But is there any simpler way? #Containerization #Docker #REST API #InterSystems IRIS 0 2 0 268
Question Evgeny Shvarov · Sep 6, 2019 How to have 2 versions of dockerfile for one repository? Hi Developers!Suppose I have a project where I want to build an IRIS container with two different dockerfiles depending on goals. How can I make it?The issue is that docker-compose is looking for the file with name 'dockerfile'Are there any #IF constrations in a dockerfile syntax? Commenting works but sometimes it's more than one line. #Beginner #Containerization #Docker #InterSystems IRIS 1 2 0 259
Question Evgeny Shvarov · Aug 27, 2019 How to Export ObjectScript From IRIS Server With VSCode? Hi Developers!A question to those who use VSCode to code InterSystems ObjectScript.Suppose you have the ObjectScript code on IRIS server and you want to export it into the desired folder.And you have VSCode connected to the server.What is the way to tell VSCode that I want to export classes into some particular folder in /package/class.cls way?E.g. into: /project_folder/src/cls/Package/class.cls and project_folder is opened in VSCode as the folder of the project. #Change Management #ObjectScript #VSCode #InterSystems IRIS 1 8 0 879
Question Evgeny Shvarov · Aug 3, 2019 Keyboard shortcuts for VSCode terminal and IRIS Hi developers!Every day coding with IRIS and docker I call the following 3 commands in VSCode terminal. Always the same for any projects: docker-compose build ; to build the container docker-compose up -d ; to run the IRIS in container docker-compose exec iris iris session iris ; to open the IRIS terminal Is there any way to map the key sequence which will type me the rest? e.g. #Development Environment #Docker #Terminal #VSCode #InterSystems IRIS 0 2 0 468