Search

For 15 over years I have been playing with ways to speed up the way I use InterSystems systems and technology via AutoHotkey scripting. As a power keyboard user (I avoid my mouse when possible) I found it very helpful to set up hotkeys to get to my most frequently accessed systems and research utilities as quickly as possible. While I have used this approach for many years, this is the first time that I am introducing my approach and a customer-facing hotkey script to the D.C. and OEx... ISCLauncher is a hotkey program based on AutoHotKey (Windows scripting language) which provides quick access a number of useful InterSystems resources and online systems (Windows OS only). Use it to quickly access the following InterSystems resources: Documentation Search Developer Community Search D.C. A.I. Online Learning WRC Issues iService Issues CCR records ... plus more! To try it out for yourself, use the "Download' button on the ISCLauncher Open Exchange listing, which will pull down a Zip file from which you can extract the contents. Run the ISCLauncher.exe and you will see the following in your Windows SysTray: To pull up the Help screen so you can see all of the things that it can do, once you are running ISCLauncher, press [Ctrl]+[Windows]+[?]: The power of ISCLauncher is that it can turn plain text into a hyperlink. E.g. If you have an ID from a WRC, iService or CCR record in an email, chat or notes, simply highlighting the record ID and using the appropriate hotkey will allow you to just directly to that record. See a demo for a CCR lookup below ([Ctrl]+[Windows]+[c]): To access a record even faster, use ISC Uber-Key ( [Ctrl]+[Windows]+[Space] ) to try to automatically determine the record type and navigate immediately there (credit to @Chad.Severtson for the original ISC Uber-Key code from years ago!). In addition to WRC, iService and CCR records - do quick searches against things like InterSystems Documentation ([Ctrl]+[Windows]+[b] ) or the Developer Community ([Ctrl]+[Windows]+[d]): Make this tool even more powerful by adding your own hotkeys for things that you frequently type or open on your desktop. For some inspiration, here is my personal launcher which I have tuned over the years: Have ideas how to make this more powerful? Add comments below. Also, once this is in GitHub you can feel free to create PRs with your suggestions.

Hi Community, It's time to announce the winners of the InterSystems FHIR and Digital Health Interoperability Contest! Thanks to all our amazing participants who submitted 11 applications 🔥 Now it's time to announce the winners! Experts Nomination 🥇 1st place and $5,000 go to the FHIRInsight app by @José.Pereira, @henry, @Henrique 🥈 2nd place and $2,500 go to the iris-fhir-bridge app by @Muhammad.Waseem 🥉 3rd place and $1,000 go to the health-gforms app by @Yuri.Gomes 🏅 4th place and $500 go to the fhir-craft app by @Laura.BlázquezGarcía 🏅 5th place and $300 go to the CCD Data Profiler app by @Landon.Minor 🌟 $100 go to the IRIS Interop DevTools app by @Chi.Nguyen-Rettig 🌟 $100 go to the hc-export-editor app by @Eric.Fortenberry 🌟 $100 go to the iris-medbot-guide app by @shan.yue 🌟 $100 go to the Langchain4jFhir app by @ErickKamii 🌟 $100 go to the ollama-ai-iris app by @Oliver.Wilms Community Nomination 🥇 1st place and $1,000 go to the iris-medbot-guide app by @shan.yue 🥈 2nd place and $600 go to the FHIRInsight app by @José.Pereira, @henry, @Henrique 🥉 3rd place and $300 go to the FhirReportGeneration app by @XININGMA 🏅 4th place and $200 go to the iris-fhir-bridge app by @Muhammad.Waseem 🏅 5th place and $100 go to the fhir-craft app by @Laura.BlázquezGarcía Our sincerest congratulations to all the winners! Join the fun next time ;)

It’s no secret that the InterSystems Global Masters program is integrated with Developer Community, Open Exchange, and Ideas Portal. Whenever you contribute to any of these platforms, you automatically earn points and badges on Global Masters. We’ve created a short guide to help you discover the best ways to earn points on Global Masters: Please note that points are automatically awarded on the 4th day after you make a contribution on DC, OEX, or the Ideas Portal (activities made outside of the Global Masters platform). HOW TO EARN POINTS ON GLOBAL MASTERS Each published post on Developer Community Published post on DC ES / PT / JP / CN / FR 200400 1st Comment on DC / Each comment* Comment on DC ES / PT / JP / CN / FR 300 / 30 60 1st answer marked as Accepted / Each accepted answer 1 000 / 150 Translate an article / a question 150 / 30 Publish 1 / 5 / 10 / 25 / 50 articles on DC 1 500 / 7 500 / 15 000 / 40 000 / 75 000 Publish 1 / 5 / 10 / 25 / 50 questions on DC 500 / 2 000 / 5 000 / 15 000 / 30 000 Each application on Open ExchangeBonus points for each ZPM applicationPublish 1 / 5 / 10 / 25 applications on Open Exchange 8004001 000 / 10 000 / 25 000 / 75 000 1 / 5 / 10 / 25 / 50 Accepted Answers on DC 1 000 / 4 000 / 8 000 / 20 000 / 40 000 Bonus points for each your DC post gathered 750+ / 2000+ / 5000+ / 15000+ views 200 / 500 / 1000 / 3000 Read an article on DCWatch the videoShare an article / video in Social Networks 101050 Write 1 / 2 / 3 / 4 / 5 Articles with Best Practices tag 1000 / 3000 / 7000 / 10 000 / 15 000 50 / 100 / 250 / 500 / 1000 application's downloads on Open Exchange 2 500 / 5 000 / 7 500 / 12 500 / 25 000 Make a review for InterSystems / InterSystems products 2 000 - 3 000 Invite your colleague to Developer Community 1000 Create a video about your OEX application 3000 *counted only comments that were published after registration on the Global Masters Advocate Hub. Complete challenges, get badges and climb up the levels: Insider > Advocate > Specialist > Expert >Ambassador> Legend.**Please note the level system is not available on a new Global Masters platform starting from April 2024. We are working on bringing it back! The higher level you are, the more interesting prizes available! And... Please check the additional information about Global Masters: What is Global Masters? Start Here Global Masters Badges Descriptions Global Masters Levels Descriptions If you have not joined InterSystems Global Masters Advocacy Hub yet, let's get started right now! Feel free to ask your questions in the comments to this post. Thanks, Anastasia!Very helpful! I believe we also have a series upon the number of accepted answers, like 10,25,50,100 accepted answers. Do we? Thank you for this quick reference table (and for my *looks up amount of points for comments* 30 points!) Hi Evgeny,let me answer - we do not have so far, and I think that would be good to have such series & badges to recognize the authors. Are these automated in any way? Wondering if mine is bugged because I've certainly posted questions and comments before but those badges were never unlocked. Their descriptions below say "first" question/comment and I don't know if mine are being detected:https://community.intersystems.com/post/changes-global-masters-program-new-level-new-badges-new-possibilities Hi David! This should be automatic. We'll investigate. I wrote a post on DC in 2017? Do I have to 'register' it to get points on Global Masters?Kind regards, Stephen Hi David!We have fixed this issue. Thank you for the feedback! Thank you! You're very quick! Hi Stephen, I see you have joined recently the Global Masters, that is so great! -this post is not counted in "Write a post on Developer Community" challenge (100 points), as it has been published before you registered- it is counted in all other type of challenges listed above e.g. "Write 10 posts on DC". This was really helpful Thank you This is an excellent article and is worth bumping the thread :) Great! This is very helpful! This is helpful. Thank you! "Invite your colleague to Developer Community" - is there a formal way to do this via the D.C. interface? I looked around and couldn't seem to find an 'invite a friend' option or anything like that. I have some colleagues whom I think would benefit from getting involved in the D.C. (CC: @Anastasia.Dyubaylo / @Evgeny.Shvarov ) Hi @Benjamin.Spead you can do that via this Global Masters challenge (this challenge is currently in your "Later" tab) Thank you @Olga.Zavrazhnova2637! I knew I had seen it somewhere at some point. I just had a conversation with a new colleague yesterday about the value of the D.C. and Global Masters, so I will send her an invite :) It's a good idea! Do you mean to have the UI on DC to prepare an email invitation to join DC to a friend developer with a standard invitation text? This was more to figure out the proper way to do this in order for tracking for the badge, etc on the G.M. platform. It makes sense that it needs to originate in a challenge (and than you to Olga for pointing that out). I don't think that just having a form on the D.C. to invite a friend necessarily makes sense, as anyone can just shoot a friend an email with the link. If others would like to see this as a new feature I won't object though. Hello,please, can you explain how to translate an article/question? Regards You can see the language of the article in the upper left side of the window, click on it and a list of language will be deployed, select the language to translate the article and a new window will be shown with 2 options, translate and request translate, select the first and you will be able to translate the article. Oh, I see. Unfortunally there is not Italian language available. Puoi dare un suggerimento in Ideas Portal Penso che ci sia abbastanza supporto lì. Perciò ?? @Luca.Ravazzolo ?? Thank you for the table! Thanks, Anastasia! Very helpful! Thanks for the help. Hello! Thank you very much for remembering these points! I was reading and noticed that the option "Share an article / video in Social Networks" is no longer available in publications, I think this referred to the old platform, right? Hi Marcelo! Yes, the option to share was available for any article and video on the old platform. On the new platform, we still have some articles/videos for sharing, but only for selected content. Social sharing “asks” are tagged with the “social share” tag on the platform when available. Thank you!! Thank for the tips thanks for the information it is very useful Very helpful, thanks I was curious, how long should it take for there to be an update to your points after reading an article / posting a reply? Is this something that should happen immediately, or take some time? This is so cool! Can't wait to get active in the Intersystems community and earn some points Hi Henry! The points are awarded on the 4th day after you post a comment or article — this delay is intentional, for moderation purposes. However, if you notice a delay longer than that, please let me know. That could indicate a possible issue with the integration between your profiles on DC and GM that we may need to look into 😊

Hello IRIS community, InterSystems Certification is currently developing a certification exam for InterSystems IRIS SQL professionals, and if you match the exam candidate description given below, we would like you to beta test the exam! The exam will be available for beta testing starting May 19, 2025. Please note: Only candidates with the pre-existing InterSystems IRIS SQL Specialist certification are eligible to take the beta. Interested in the beta but don’t have the SQL Specialist certification? Take the SQL Specialist exam! Eligible candidates will receive an email from the certification team on May 19, 2025 with instructions on scheduling the exam. Beta testing will be completed June 30, 2025. What are my responsibilities as a beta tester? You will schedule and take the exam by June 30th. The exam will be administered in an online proctored environment free of charge (the standard fee of $150 per exam is waived for all beta testers). The InterSystems Certification team will then perform a careful statistical analysis of all beta test data to set a passing score for the exam. The analysis of the beta test results will take 6-8 weeks, and once the passing score is established, you will receive an email notification from InterSystems Certification informing you of the results. If your score on the exam is at or above the passing score, you will have earned the certification! Note: Beta test scores are completely confidential. How is this exam different from the InterSystems IRIS SQL Specialist exam? This new exam - InterSystems IRIS SQL Professional - covers higher-level SQL topics and is recommended for candidates with 4 to 6 years of relevant experience, compared to the 1 to 2 years recommended for the SQL Specialist exam. Interested in participating? Read the Exam Details below. Exam Details Exam title: InterSystems IRIS SQL Professional Candidate description: A developer or solutions architect who Designs IRIS SQL applications Manages IRIS SQL operations Uses IRIS SQL Loads and efficiently queries datasets stored in IRIS SQL Number of questions: 38 Time allotted to take exam: 2 hours Recommended preparation: Review the content below before taking the exam. Online Learning: Using SQL in InterSystems IRIS (learning path, 3h 45m) Recommended practical experience: 4 to 6 years of experience developing and managing IRIS SQL applications is recommended. At least 2 years of experience working with ObjectScript and globals in InterSystems IRIS is recommended. Exam practice questions A set of practice questions is provided here to familiarize candidates with question formats and approaches. Exam format The questions are presented in two formats: multiple choice and multiple response. Access to InterSystems IRIS Documentation will be available during the exam. DISCLAIMER: Please note this exam has a 2-hour time limit. While InterSystems documentation will be available during the exam, candidates will not have time to search the documentation for every question. Thus, completing the recommended preparation before taking the exam, and searching the documentation only when absolutely necessary during the exam, are both strongly encouraged! System requirements for beta testing Working camera & microphone Dual-core CPU At least 2 GB available of RAM memory At least 500 MB of available disk space Minimum internet speed: Download - 500kb/s Upload - 500kb/s Exam topics and content The exam contains questions that cover the areas for the stated role as shown in the exam topics chart immediately below. Topic Subtopic Knowledge, skills, and abilities 1. Designs IRIS SQL applications 1.1 Designs a SQL schema Distinguishes use cases for row vs columnar table layout Distinguishes use cases for different index types 1.2 Designs advanced schemas Recalls anatomy of Globals (subscript and value) Interprets relationship between table structure and Globals Distinguishes the (Globals) level at which mirroring/journaling operates from the SQL layer Distinguishes the differences between date/time data types Interprets the overhead associated with stream data Identifies use cases for text search 1.3 Writes business logic Identifies use cases for UDFs, UDAFs, and SPs 1.4 Develops Object/Relational applications Recalls SQL best practices when defining classes Uses Object access to interact with individual rows Identifies SQL limitations with class inheritance Uses serial and object properties Identifies use cases for collection properties Distinguishes class relationships from Foreign Keys 1.5 Deploys SQL applications Determines what needs to be part of a deployment 2. Uses IRIS SQL 2.1 Manages IRIS query processing Identify benefits of the universal query cache List considerations made by the optimizer Differentiates client and server-side problems Uses Statement Index to find statement metadata Distinguishes between the use of parameters and constants in a query Distinguishes between transaction and isolation levels 2.2 Interprets query plans Identifies the use of indices in a query plan Identifies vectorized (columnar) query plans Uses hints to troubleshoot query planning Identifies opportunities for indices, based on a query plan 2.3 Uses IRIS SQL in applications Distinguishes use cases for Dynamic SQL and Embedded SQL 2.4 Uses IRIS-specific SQL capabilities Uses arrow syntax for implicit joining Determines use cases for explicit use of collation functions 3. Manages IRIS SQL operations 3.1 Manages SQL operations Identifies use cases for purging queries and rebuilding indices Recalls impact of purging queries and rebuilding indices Identifies use cases for un/freezing query plans, including automation Identifies use cases for (bitmap) index compaction Uses the runtime stats in the Statement Index to find statements with optimization opportunities 3.2 Configures InterSystems SQL options Recalls relevant system configuration options (e.g. lock threshold) Differentiates scale-out options, ECP, and sharding 3.3 Manages SQL security Recalls to apply SQL privilege checking when using Embedded SQL 3.4 Uses PTools for advanced performance analysis Identifies use cases for using PTools Interested in participating? Eligible candidates will receive an email from the certification team on May 19th with instructions on how to schedule and take the exam. Hello Celeste! This is really interesting. How are the eligible candidates chosen? Is there a way to apply? Thank you. Hi Pietro! Unlike prior certification exam betas, only folks who hold the InterSystems IRIS SQL Specialist certification are eligible. There is no application process, rather, the certification team will be reaching out directly to eligible individuals on May 19th. Anyone who holds an active SQL Specialist certification will receive an email next Monday with instructions on how to access and take the beta exam. The email will be sent to the address associated with your account on Credly, our digital badging platform. If you do not yet have the SQL Specialist certification, I encourage you to consider taking the InterSystems IRIS SQL Specialist certification exam. Once you pass this exam and obtain the certification, you will receive an email from the certification team regarding the beta. Please let me know if I can clarify anything! Thank you for the clarifications Celeste!

Hello, I'm testing IRIS 2020.4 Preview with preview key. I've access to the management portal but I can't connect with Studio. This is my docker-command : docker run --name my-iris --detach --publish 9091:51773 --publish 9092:52773 --volume C:\Docker\iris_external:/external –-volume C:\Docker\iris_durable:/durable –-env ISC_DATA_DIRECTORY=/durable/irissys containers.intersystems.com/intersystems/iris:2020.4.0.524.0 --key /external/iris.key --password-file /external/password.txt I notice that Caché Direct is disabled by the license. Can someone help me out ? InterSystems have changed SuperServer port in a few latest builds, back to 1972. So, just replacing 51773 with 1972, should work. You can use docker inspect docker inspect containers.intersystems.com/intersystems/iris:2020.4.0.524.0 Will outputs something like this ..... "ExposedPorts": { "1972/tcp": {}, "2188/tcp": {}, "52773/tcp": {}, "53773/tcp": {}, "54773/tcp": {} }, ..... "Labels": { "com.intersystems.adhoc-info": "", "com.intersystems.platform-version": "2020.4.0.524.0", "com.intersystems.ports.default.arbiter": "2188", "com.intersystems.ports.default.license-server": "4002", "com.intersystems.ports.default.superserver": "1972", "com.intersystems.ports.default.webserver": "52773", "com.intersystems.ports.default.xdbc": "53773", "com.intersystems.product-name": "IRIS", "com.intersystems.product-platform": "dockerubuntux64", "com.intersystems.product-timestamp": "Thu Oct 22 2020 13:02:16 EDT", "com.intersystems.product-timestamp.iso8601": "2020-10-22T17:02:16Z", "maintainer": "InterSystems Worldwide Response Center <support@intersystems.com>", "org.opencontainers.image.created": "2020-10-22T19:32:32Z", "org.opencontainers.image.documentation": "https://docs.intersystems.com/", "org.opencontainers.image.title": "intersystems/iris", "org.opencontainers.image.vendor": "InterSystems", "org.opencontainers.image.version": "2020.4.0.524.0-0" } I've just left, only interesting lines in your case. Where you can find, which ports are declared as exposed in the image, and labels, which declares available ports in the image. Access directly to the label $ docker inspect containers.intersystems.com/intersystems/iris:2020.4.0.524.0 \ --format '{{ index .Config.Labels "com.intersystems.ports.default.superserver" }}' 1972 Thanks, I replaced 51773 with 1972 and now it works !

Hi, I'm a java developer,have integration package for springboot?(maven or gradle) This is also the question I want to submit. check https://openexchange.intersystems.com/package/springboot-iris-crud

I liked the transactional analytic DBMS and Advanced Analytics segmentation concept. The 1.0 version IRIS plug-in to VSCode is amazing. The partnership between community and InterSystems was very positive to it. However a low code option would do very well for IRIS in the near future. The Dynamic Gateways/Native API positions IRIS as the most advanced data platform for the main open languages in the market, but it is necessary use the public package managers from these languages, specially maven public repository. The API Manager is a good option but it is not available to the community IRIS version and can be used only with API created with IRIS. It is a critical point to resolve. OPC-UA adapter to IoT and Kakfa adapter to realtime events are great, I loved it. In the future, new adapters to the Salesforce, SAP, Office 365 and other most used platforms could be considered. Cloud support is perfect now, with ICM and IKO to deploy and manage and SAM to monitor. The FHIR accelerator is great option to FHIR projects, it's really very useful. IRIS really is getting faster and faster, impressive to be able to make something that is already very fast faster. The Adaptive Analytics was an impressive launch and very welcome, it has the ability to speed up and simplify the creation of analytical cubes (in a totally visual and intuitive way) and its exposure to excel and other data viewers in a wonderful way. In the future I would like to see InterSystems launching its own viewer, since IRIS Reports is for restricted use and is not available for community versions, making it impossible to popularize in the community. The IntegratedML was my favorite new IRIS feature. Very easy to use, any DBA can be use it. The AutoML is a fantastic technology and will be used a lot. Now, InterSystems needs to deliver a viewer of predictions and classifications to the end user, it could use the same technology as SAM, the Grafana. I agree with you in most cases. The most important announcement for me would be Embedded Python.This will bring to the community the power of python libraries, it's a giant step forward. Yes, the integration with python is very important.

Hey Developers, Are you joining us for the InterSystems Virtual Summit 2021? ⚡️ THE REGISTRATION IS NOW OPEN ⚡️ Innovations in Data - #VSummit21 At the second InterSystems Virtual Summit, learn how to make your organization thrive with healthy data, powerful analytics, and a smart data fabric powered by InterSystems technology. Hear from our experts, world-leading thought leaders, and InterSystems customers from around the globe. 🗓 Tuesday, October 26 - Friday, October 29 👉 Keynotes | Live Experience Labs | Focus Sessions On-demand | Free Registration Summit Schedule Day 1 (Tuesday, Oct.26)Keynote presentations by our InterSystems leadership team, thought leaders, and key customers. Day 2 (Wednesday, Oct. 27)Keynotes about Client Support and "What’s New and Next" presentations by product directors for InterSystems IRIS®, InterSystems IRIS for Health™, HealthShare®, and TrakCare®. Days 3 and 4 (Thursday, Oct. 28, and Friday, Oct. 29)Build your own schedule. Take this opportunity to view all the Focus Sessions on demand. You can also sign up for our Experience Labs. All on demand focus sessions are pre-recorded and will be available on day 2 starting at 2 PM ET. REGISTER FOR FREE TODAY. And see you at Virtual Summit 2021!

I am trying to install IAM in my local and I downloaded IAM-0.34-1-1.tar.gz and extracted. I went to the location where iam_image.tar is available and run below command in the command prompt. C:\ESB\HC\IAM-0.34-1-1.tar\IAM-0.34-1-1\IAM>docker load -i iam_image.tarunsupported os linux Getting unsupported os Linux issue. Kindly let me know if anyone had this issue. Thanks! On windows docker works in two different ways, as windows containers and linux containers. It looks like, you just should switch it to linux from Windows Thanks for reply @Dimtriy, I am new to Docker. I have below info on my machine about docker and looks it is using Windows container. Let me know if anything needs to be changed. C:\>docker versionClient: Docker Engine - Community Version: 19.03.8 API version: 1.40 Go version: go1.12.17 Git commit: afacb8b Built: Wed Mar 11 01:23:10 2020 OS/Arch: windows/amd64 Experimental: false Server: Docker Engine - Community Engine: Version: 19.03.8 API version: 1.40 (minimum version 1.24) Go version: go1.12.17 Git commit: afacb8b Built: Wed Mar 11 01:37:20 2020 OS/Arch: windows/amd64 Experimental: false As I said for server side it show linux for os/arch. You should find the switcher in context menu in tray on docker icon. Thank you, I am able to load the image after I switch to linux container in server-side. After I loaded the image, I am trying to do the next step of configuration. 2) Configure your InterSystems IRIS instance 2a) Enable the /api/IAM web application 2b) Enable the IAM user 2c) Change the password for the IAM user Do we need to change these settings in iris.cpf file? any inputs where we have to configure. I have IRIS 2019.1.1 installed in my machine.

Is there any chance to make available a arm64/aarch64 binary version for Caché ODBC Driver? Just like IRIS ftp://ftp.intersystems.com/pub/iris/odbc//2021/ODBC-2021.1.0.215.0-lnxrharm64.tar.gz As I am using docker, currently is not possible to build locally a new image using existing Caché ODBC Drivers on Mac M1. Do you still expect some echo?Or is the question meanwhile just out of date? @Robert.Cemper1003 I am waiting for that. Do you have any solution ? Caché will not get support for M1, and so, I think no reasons to wait for an ODBC driver for M1 too No, I have no solution.As all development on Caché (except serious bugfix) is frozen I wouldn't expect this to come.You may migrate your Caché to IRIS. Or use some other way (REST ?) for access.

Hi Developers, The new video from Global summit 2019 is already on InterSystems Developers YouTube: ⏯ Intersystems IRIS Kubernetes Operator This video introduces the InterSystems IRIS Kubernetes operator, which enables InterSystems IRIS containers to function as "first-class citizens" of the Kubernetes ecosystem. We recommend that you be familiar with basic Kubernetes concepts: Introduction to Kubernetes Video Takeaway: You will understand and appreciate the value proposition of the InterSystems IRIS Kubernetes operator. Presenters: 🗣 @Luca.Ravazzolo, Product Manager, InterSystems🗣 @Steven.Lubars, InterSystems Software Developer Additional materials to this video you can find in this InterSystems Online Learning Course. Check out the Cloud Deployment Resource Guide. Enjoy watching this video! 👍🏼 HI Guys, Can you please post the link of prevision session that you mentioned in this video. I am still not sure how we will use Kubernetes with IRIS . It be great if you can put some light on that too ? Thanks Hi Neerav Adam, Are you looking for the Introduction to Kubernetes session? Does anyone know how to download this operator? I'm excited to start using it. Hi @Jonathan.Keam, I hope you found the answer back in Jan. If not head over to containers.intersystems.com HTH

BridgeWorks is pleased to announce a VDM, v9.1.0.1. This release includes the following updates: Updates Historical Linking is now based off connection profile name Saved Formatting is now based off connection profile name Tables and Fields column headers no longer hide based on connection type Bug Fixes Cross tab would not load data correctly in Finished Reports Viewer if it was in a report footer Fixed an issue where refreshing logs would not work correctly after viewing a SQL statement Views were not visible for available schemas on the connection wizard New Load Selected Connections Only load connections selected from a list

Hello, I used the operation : EnsLib.EMail.AlertOperation to send mail to handle error. However, I want to get more information about the error (session ID message, the date, the namespace... etc). what is the best way to do it? I tried to add informations in OnAlertRequest method as below but I need to change mail operation from all namespaces... Thanks, I need to get the url of message viewer screen with the session ID .For example : http://localhost:57772/csp/svcptl/EnsPortal.VisualTrace.zen?SESSIONID=40241. It is possible ? You already have a value of SessionId, so concatenate the rest?To get port and host call: set sc=##class(%Studio.General).GetWebServerPort(.port, .server) Some ideas:session ID - you're getting it with pAlertRequest.SessionId, no?date - get it from pAlertRequest.AlertTimenamespace -wouldn't it always be the current namespace? Get it with $namespaceWhat other data do you need?Also, please post your code as text. You can do it in three ways:1 -set ^mtemperro($ZNSPACE,..%PackageName()_"."_..%ClassName(),$horolog) = mensagem_" Erro CACHE: "_$zerror_" - "_$SYSTEM.OBJ.DisplayError()2 - Throw ##class(%Exception.General).%New("Falha ao sinalizar o lançamento do PDA como rastreado.",1,..%ClassName()_".upByRastreado","Informe ao suporte sobre o problema.").Log()3 - Declare in your class an exception variable#dim exception As% Exception.AbstractExceptioncatch exception { do exception.Log()}Then just check the cache administration portal:System Operation-> System Logs-> Application Error Log

Intersystems is all about name spaces. Each Name space can be mapped to one or more databases and vice versa. In my desktop with intersystems, Can i have DEV , TEST environments pointing to different name spaces at same point of time ? if i am right here, then the DEV environment is nothing but the namespace that we work on....Please let know Slight correction: the system mode is per instance and not per namespace. Well spotted, I've updated my comment. Hi Murali,Your perfectly right.You can have multiple namespaces on the same Caché instance for different purposes. These should have a naming convention to identify their purpose. That convention is really down to you. I normally postfix the name with -DEV and -TEST, e.g. FOO-DEV & FOO-TEST.These namespaces will share commonly mapped code from the main library, but unless configured otherwise they are completely independent from each other. You can dev and test in them respectively without fear of polluting one another.TipYou can mark the mode of an instance via the management portal > system > configuration > memory and startup. On that configuration page you will see a drop down for "system mode" with the options...Live SystemTest SystemDevelopment SystemFailover SystemThe options are mostly inert, but what they will do is paint a box on the top of your management portal screens. If you mark it as live then you will get a red box that you can't miss.Sean

Hi,this is a public announcement for the first release of Intersystems Cache Object-Relational Mapper in Python 3. Project's main repository is located at Github (healiseu/IntersystemsCacheORM).About the projectCacheORM module is an enhanced OOP porting of Intersystems Cache-Python binding. There are three classes implemented:CacheClient This is the super class of CachePython module. It wraps two functions from intersys.pythonbind module pythonbind3.connection() and pythonbind3.database().CacheQuery A subclass of CacheClient that wraps methods and adds extra functionality in intersys.pythonbind.databaseand intersys.pythonbind.query classesCacheClass A subclass of CacheClient, that wraps methods and adds extra functionality in intersys.pythonbind.databaseand intersys.pythonbind.object classesThe intersys.pythonbind package is a Python C extension that provides Python application with transparent connectivity to the objects stored in the Caché database.Source CodeThe project's code that is released to the public was originally written and used as a module of TRIADB project.Tests and DemosThere are two folders in this release:testCacheORM contains python jupyter notebook files that demonstrate CacheQuery and CacheClasstestCacheBinding are tests written for Intersystems Cache python bindingOne can simply compare tests with demos to appreciate the work in this project to leverage intersystems cache python binding. For example # Intersystems Cache Python binding for queries import intersys.pythonbind3 # Create a connection user="_SYSTEM"; password="123"; host = "localhost"; port = "1972"; url = host+"["+port+"]:SAMPLES" conn = intersys.pythonbind3.connection() # Connect Now to SAMPLES namespace conn.connect_now(url, user, password, None) # Create a database object samplesDB = intersys.pythonbind3.database(conn) # create a query object cq = intersys.pythonbind3.query(samplesDB) # prepare and execute query sql = "SELECT ID, Name, DOB, SSN FROM Sample.Person" cq.prepare(sql) cq.execute() # Fetch rows for x in range(0,10): print(cq.fetch([None])) Same code in only 4 lines using CacheORM python module from CacheORM import CacheQuery samples_query = CacheQuery(namespace='SAMPLES', username='_SYSTEM', password='SYS', dl=99) samples_query.execute_sql('SELECT ID, Name, DOB, SSN FROM Sample.Person') samples_query.print_records(10) You can view the output from this python Jupyter Notebook at my Microsoft Azure CacheORM library Another example, this time with Cache-Python Objects # Demo of Intersystems Cache Python binding with Samples namespace and Sample.Person class import intersys.pythonbind3 conn = intersys.pythonbind3.connection( ) conn.connect_now('localhost[1972]:SAMPLES', '_SYSTEM', '123', None) samplesDB = intersys.pythonbind3.database(conn) #%% Create a new instance of Sample.Person to be husband husband = samplesDB.create_new("Sample.Person", None) ssn1 = samplesDB.run_class_method("%Library.PopulateUtils","SSN",[]) dob1 = samplesDB.run_class_method("%Library.PopulateUtils","Date",[]) husband.set("Name","Hatzis, Athanassios I") husband.set("SSN",ssn1) husband.set("DOB",dob1) # Save husband husband.run_obj_method("%Save",[]) print ("Saved id: "+str(husband.run_obj_method("%Id",[]))) #%% Create a new instance of Sample.Person to be wife wife = samplesDB.create_new("Sample.Person", None); ssn2 = samplesDB.run_class_method("%Library.PopulateUtils","SSN",[]) dob2 = samplesDB.run_class_method("%Library.PopulateUtils","Date",[]) wife.set("Name","Kalamari, Panajota"); wife.set("SSN",ssn2) wife.set("DOB",dob2) # Save wife wife.set("Spouse",husband); wife.run_obj_method("%Save",[]); print ("Saved id: " + str(wife.run_obj_method("%Id",[]))) #%% Relate them husband.set("Spouse",wife); husband.run_obj_method("%Save",[]); wife.set("Spouse",husband); wife.run_obj_method("%Save",[]); # Open an instance of the Sample.Person object athanID=217 athanPerson = samplesDB.openid("Sample.Person",str(athanID),-1,-1) # Open another instance otherID=3 otherPerson = samplesDB.openid("Sample.Person",str(otherID),-1,-1) # Fetch some properties print ("ID: " + otherPerson.run_obj_method("%Id",[])) print ("Name: " + otherPerson.get("Name")) print ("SSN: " + otherPerson.get("SSN")) print ("DOB: " + str(otherPerson.get("DOB"))) print ("Age: " + str(othePerson.get("Age"))) Same code using CacheORM python module, i.e. object-relational mapping from CacheORM import CacheClass # Create an instance of PopulateUtils to call built-in CACHE class method populateUtils = CacheClass(namespace='%SYS', cachepackage='%Library', cacheclass='PopulateUtils', username='_SYSTEM', password='SYS') # Create CacheClass Instance husband = CacheClass(username='_SYSTEM', password='SYS', dl=99) # Create and populate a new CacheClass Object husband.new() husband.set_value("SSN",populateUtils.class_method("SSN")) husband.set_value("Name", "Hatzis, Athanassios I") husband.set_value("DOB", populateUtils.class_method("Date")) # Save husband husband.save() # Create another CacheClass object wife = CacheClass(username='_SYSTEM', password='SYS') wife.new() wife.set_value("SSN",populateUtils.class_method("SSN")) wife.set_value("Name", "Kalamari, Panajota") wife.set_value("DOB", populateUtils.class_method("Date")) wife.save() # Relate them wife.set_refobj("Spouse", person._cache_id) wife.save() husband.set_refobj("Spouse", female._cache_id) husband.save() # Get Object References person.get("Spouse").get("Name") female.get("Spouse").get("Name") # Open an existing object with id=3 and read cache properties person = CacheClass(username='_SYSTEM', password='SYS', objectID='3') print(f"ID:{person.id}\nSSN: {person.get('SSN')}\nName:{person.get('Name')}\nDateOfBirth:{person.get('DOB')}") You can view the output from this python Jupyter Notebook at my Microsoft Azure CacheORM library Cool staff, Athanassios!Caché queries demo doesn't work though: Thanks Evgeny, you cannot execute my jupyter notebooks on Azure cloud and I think you have to login first in order to view them. In any case my CacheORM module is dependent on intersys.pythonbind module. One has to install this first and verify that it works then start playing with my demos. I wrote guidelines about installation in Github README file.