Article Muhammad Waseem · Jan 24 4m read 5 useful SQL functions to take your SQL skills to the next level Hi Community, In this article, I listed 5 useful SQL functions with explanations and query examples 👇🏻These 5 functions are COALESCE RANK DENSE_RANK ROW_NUMBER Function to Get Running Totals So Let us start with COALESCE function #Beginner #SQL #Tips & Tricks #Caché 8 4 0 117
Article Muhammad Waseem · Sep 20, 2022 8m read Getting to know Python Flask Web Framework Hi Community,In this article, I will introduce Python Flask Web Framework. Together we will create a minimal web application to connect to IRIS and get data from it.Below you can find the steps we will need to follow: Step 1 : Introduction to Python Flask Web Framework Step 2 : Installation of Flask module Step 3 : Creation of web application using Flask Step 4 : Use of HTML Templates Step 5 : Installation of IRIS Python Native module Step 6 : Establishment of a connection with IRIS Step 7 : Transferring data from IRIS to Flask and displaying it So Let's start with step 1 Step1-Introduction to Python Flask Web Framework Flask is a small and lightweight Python web framework that provides useful tools and features that make creating web applications in Python easier. It gives developers flexibility and is a more accessible framework for new developers since it allows to build a web application quickly using only a single Python file. Flask is also extensible and doesn’t requires a particular directory structure or complicated boilerplate code before getting started. For more details please view Flask Documentations #Globals #HTML #Python #Caché #InterSystems IRIS for Health 2 2 0 245
Article Muhammad Waseem · Sep 13, 2022 5m read Sustainable energy data by calling API from the major Independent System Operators (ISOs) in the United States with the help of PEX and Embedded Python Hi Community,In this article I will demonstrate the functionality of my app iris-energy-isodata . Application is accessing energy data (production, demand and supply) from the major Independent System Operators (ISOs) in the United States to ensure sustainable consumption and production patterns (SDG's 12) #Contest #Embedded Python #Interoperability #Ensemble #InterSystems IRIS for Health Open Exchange app 3 2 0 129
Article Muhammad Waseem · Jul 10, 2022 10m read IRIS Climate Change application that shows how temperature is increasing worldwide as a proof of global warming Hi Community, This post is a introduction of my open exchange iris-climate-change application. iris-climate-change web application Imports The Food and Agriculture Organization (FAO) Climate Change dataset by using LOAD DATA (SQL) functionality and analyze and visualize data with the help of Python Flask Web Framework, Pandas Python data analysis Library, Plotly Open Source Graphing Library for Python and Plotly JavaScript Open Source Graphing Library. #Contest #Embedded Python #Python #Visualization #InterSystems IRIS Open Exchange app 14 0 0 173
Article Muhammad Waseem · Jul 2, 2022 6m read Display Management Portal Dashboard by using Python Flask web and Bootstrap Frameworks with the help of embedded python Hi Community, In this article I will explain how to display management portal dashboard by using Python Flask web and Boostrap framework with the help of embedded python #Best Practices #Embedded Python #Management Portal #SQL #InterSystems IRIS for Health Open Exchange app 18 1 2 499
Article Muhammad Waseem · Jun 4, 2022 3m read Creating Patient and Patient Observations by using iris-fhir-client application Hi Community, This article will demonstrate how to create Patient and Patient Observation Resources by using iris-fhir-client application. I recommend to read my first article about this app and watch Youtube Video before continue so let's start #Embedded Python #FHIR #InterSystems IRIS for Health Open Exchange app 3 0 0 236
Article Muhammad Waseem · May 30, 2022 3m read FHIR Client to connect any open FHIR Server by using embedded python Hi Community, This post is a introduction of my open exchange iris-fhir-client application. iris-fhir-client can connect to any open FHIR Server by using embedded python with the help of fhirpy Library.Get Resource information by terminal and by using CSP web application. #Contest #CSP #Dashboards #Embedded Python #FHIR #InterSystems Package Manager (IPM) #ObjectScript #REST API #InterSystems IRIS for Health #Open Exchange Open Exchange app 5 2 0 366
Question Muhammad Waseem · May 16, 2022 InterSystems FHIR Server (FHIRaaS) API Error Hi All, Since yesterday I am getting below error while calling InterSystems FHIR Server (FHIRaaS) API Looking ForwardThanks #FHIR #Other 0 0 0 97
Question Muhammad Waseem · May 14, 2022 FHIRaas smart-configuration error : "This endpoint does not have SMART on FHIR capabilities defined" Hi, Currently I am working to develop smart on FHIR app with FHIRaas with the help of fhirclient.js and facing one issue that .well-known/smart-configuration is raising following error "This endpoint does not have SMART on FHIR capabilities defined" Below snapshot is for reference: Looking forward to resolve the above issue or workaround Thanks #FHIR #Other 0 3 0 174
Article Muhammad Waseem · Apr 5, 2022 7m read Using Globals as a graph database to store and retrieve graph structure data Hi Community, #Contest #CSS #Databases #Data Model #Python #Caché #InterSystems IRIS for Health #Open Exchange #VSCode Open Exchange app 2 2 1 286