Article Muhammad Waseem · Jan 11, 2022 2m read Use of %SQL_Diag logging along with all-new LOAD DATA functionality In this article I will explain the usage of %SQL_Diag.Result and %SQL_Diag.Message table along with all-new LOAD DATA functionality. It is recommended to go through LOAD DATA documentation first. After successful operation LOAD DATA insert one record in %SQL_Diag.Result table and details are inserted in %SQL_Diag.Message table Below is the basic command when table is already created and source file does not contain header row. LOAD DATA FROM FILE 'C://TEMP/mydata.txt' INTO MyTable The file name must include a .txt or .csv (comma-separated values) suffix and both source and target have the same sequence of data columns. Loading from File Source: Header #Databases #SQL #Tips & Tricks #InterSystems IRIS Open Exchange app 3 1 0 228
Article Muhammad Waseem · Jan 10, 2022 4m read 12 Medical Datasets along with 43 tables dynamically created by using all-new LOAD DATA SQL functionality Application to import 12 Datasets along with 43 tables dynamically by using LOAD DATA command which loads data from a source into an IRIS SQL table. List of Datasets #Contest #CSS #Databases #InterSystems Package Manager (IPM) #SQL #InterSystems IRIS Open Exchange app 1 2 0 1.1K
Article Muhammad Waseem · Dec 4, 2021 3m read OAuth2 Authentication with GitHub account from IRIS Web Application In this article I will demonstrate basics of OAuth2 authentication with GitHub account with the help of online demo https://dappsecurity.demo.community.intersystems.com/csp/user/index.csp by using SuperUser | SYS #Authentication #GitHub #OAuth2 #InterSystems IRIS Open Exchange app 5 0 2 627
Article Muhammad Waseem · Nov 29, 2021 3m read OAuth2 and Basic Authentication, Authorization AND Auditing by code from Web Application In this article I will explain how to Authenticate, Authorize and Audit by code by using CSP Web Application along with Enabling /Disabling and Authenticate/Unauthenticate any Web Application. Online Demo is available on cloud https://dappsecurity.demo.community.intersystems.com/csp/user/index.csp (SuperUser | SYS) I recommend to watch the video before continue https://www.youtube.com/watch?v=qFRa3njqDcA Application Layout #Authentication #Best Practices #OAuth2 #InterSystems IRIS Open Exchange app 8 5 1 1.1K
Question Muhammad Waseem · Nov 22, 2021 Getting "TypeError: Failed to fetch" while using FHIR accelerator service - API Development Hi, I am getting Failed to fetch error while calling FHIR accelerator service - API Development service Thanks #FHIR #InterSystems IRIS for Health 0 0 0 164
Question Muhammad Waseem · Nov 21, 2021 https://learning.intersystems.com is down Hi, InterSystems learning section is down since yesterday When it will be up and running OR is there any alternate available? Thanks #Learning Portal 0 2 0 203
Article Muhammad Waseem · Nov 17, 2021 2m read Deleting data to Caché by using ODBC connection from Appeon PowerBuilder In my previous articles I demonstrated the steps to connect, retrieve and save data to Caché from Appeon PowerBuilder by using ODBC.In this article I will demonstrated how to Delete data from Caché with Appeon PowerBuilder (https://www.appeon.com/products/powerbuilder) by using ODBC #ODBC #InterSystems IRIS 2 0 0 235
Article Muhammad Waseem · Nov 14, 2021 2m read Saving data to Caché by using ODBC connection from Appeon PowerBuilder In my previous articles I demonstrated the steps to connect and retrieve data from Caché from Appeon PowerBuilder by using ODBC.In this article I will demonstrated how to Save data to Caché with Appeon PowerBuilder (https://www.appeon.com/products/powerbuilder) by using ODBC #Databases #Caché 1 2 0 245
Question Muhammad Waseem · Nov 13, 2021 Encrypt database option is disabled while creating new database Hi, I want to activate encryption and I also generated encryption key but Encrypt database option is disabled. How to enabled this option? Thanks #InterSystems IRIS for Health 0 1 0 134
Article Muhammad Waseem · Nov 7, 2021 1m read Retrieving data from Caché with Appeon PowerBuilder by using ODBC In my previous article I demonstrated the steps to connect to Caché from Appeon PowerBuilder by using ODBC.In this article I will demonstrated how to Retrieve data from Caché with Appeon PowerBuilder (https://www.appeon.com/products/powerbuilder) by using ODBC #ODBC #Caché 1 0 0 380
Question Muhammad Waseem · Oct 31, 2021 Error while starting local IRIS for health instance Hi, I am getting below error while starting local IRIS for health instance below is the error in windows application event log Thanks #InterSystems IRIS for Health 0 3 0 183
Question Muhammad Waseem · Oct 15, 2021 Error while generating package in zpm Hi, I am getting below message while generating package from ZPM ERROR! ObjectScript error: <CLASS DOES NOT EXIST>zGenerateModuleXML+21^%ZPM.PackageManager.1 *%ZPM.PackageManager.Developer.ModuleTemplate Thanks #InterSystems Package Manager (IPM) #Other 0 2 0 245
Article Muhammad Waseem · Oct 15, 2021 2m read How to update result reference range and abnormal flag accordingly using HL7 In this article I will demonstrate the following : Update ReferencesRange(OBX:7) against ObservationIdentifier(OBX:3.1)[TestCode] from database by using custom utility function Update Abnormal Flag(OBX:8) against ObservationIdentifier(OBX:3.1)[TestCode] and ObservationValue(OBX:5)[Result] from database utility function Route Message based on Abnormal Flag(OBX:8) Below is the primary and transformed HL7 2.5 ORU_R01 message: #Business Rules #DTL #SQL #Ensemble #InterSystems IRIS for Health Open Exchange app 1 6 0 736
Question Muhammad Waseem · Oct 11, 2021 How to import CSV file data to a container class from github repository? Hi, I have CSV file in github repository. I want to import CSV file data into container class during running container. Thanks #Docker #GitHub #Ensemble #InterSystems IRIS for Health 0 5 0 245
Question Muhammad Waseem · Oct 10, 2021 Production is not auto starting while using container Hi, Production is not auto starting even by adding <Production Name="myProd.Production" AutoStart="1"/> in installer.cls file: Thanks #Docker #Ensemble 0 4 0 209
Question Muhammad Waseem · Oct 9, 2021 How to check repeating segment value in business rule? Hi, In the business rule I want to send a message to the business operation if any of OBX:8 (Abnormal Flag) is set. I tried foreach but could not found desire results. Below is the sample message: Thanks #Business Rules #Ensemble 0 7 0 472
Question Muhammad Waseem · Oct 8, 2021 Best container image to work with HL7 version 2.3 Hi, Currently I am working on HL7 Ver 2.3. Just want to know what is the best container image for this version? Thanks #Docker #Ensemble 0 1 0 263
Question Muhammad Waseem · Oct 8, 2021 How to copy file to container location ? Hi, I am using container to run IRIS. In my file service I defined following path: How can I copy file to container location? Thanks #Docker #InterSystems IRIS 0 2 0 250
Question Muhammad Waseem · Oct 7, 2021 How can I list down all the Articles of a particular author in community? Hi, How can I list down all the Articles of a particular author in community? Thanks #Other 0 2 0 119
Question Muhammad Waseem · Oct 7, 2021 How to view class details from online labs using studio or VS? Hi, I want to view class details by using online Lab I tried to access with studio, It is connecting successfully buy class list is empty How can I view the class details ? Thanks #Studio #InterSystems IRIS for Health 0 4 0 158