Posts

Build beautiful and interactive API documentation for ORDS

Image
In this blog post, I will show you how to quickly build beautiful and interactive API documentation for your Oracle APEX REST data sources using  swagger hub . Using APEX v23.1. I downloaded the  titanic data set  and loaded them into tables in my APEX instance, created some authorized restful services and published them using swagger hub. You can create a free account on swagger hub.   Check out my titanic swagger hub here ; Press Authorize. Username REST, password Glasgow123! I won't go through creating RESTful services and just show you the four I created that sit on top of the titanic data set; The GET is a very simple SQL query;      select * from TITANIC_DATA_SET_NEW A handy tip is to add comments, as there will appear on swagger hub, making your API self documenting; Once you have created your modules, press the Generate Swagger Doc button; This will generate an open API for you.  Copy the API and paste it into swagger hub This will generate the documentation; As mentioned b

Oracle APEX pretty checkbox item plugin

Image
Following on from the animated on off button this is now an item plugin.  Pretty up your checkboxes..... You have 16 checkbox types to choose from where you can control the size and colour of the checkbox in item settings; demo Create a page item with type Pretty check box Choose type of checkbox Set checkbox attributes. How it works The item plug in code uses this code to plug the rendered checkbox into APEX. /////////////////////////////////////////////////////////////////////////////////////////// // glasgow_simple_checkbox // // Provides a plug- in specific implementation for a checkbox item. The item on the page // should be a checkbox, i.e. <input type = "checkbox" and name should be your item name // i.e. name = 'P12_NAME' // // Params // // itemName - the item name , i.e. name = 'P12_NAME' // checkboxValues - the check and unchecked values , i.e. Y/N /////////////////////////////////////////////////////////////////////////////////////////// f

Oracle APEX animate yes-no button

Image
This post will show you how to add an animated on-off yes-no button to your APEX application and link it to a page item. Demo Create a new page text item, in my case P8_NEW. We are going to use this to store the selected value when the user presses the button Then create a static region with the following HTML code. When the button gets clicked we set P8_NEW using JavaScript. <div class= "mid" >   <label class= "rocker" >     <input type = "checkbox" id= "myCheck" >     <span class= "switch-left"  onclick= "apex.item( 'P8_NEW' ).setValue('Yes')" >Yes</span>     <span class= "switch-right" onclick= "apex.item( 'P8_NEW' ).setValue('No')" > No </span>   </label> </div> You can change the button text here to On/Off or whatever you need. Add the following code to page inline CSS to style the button. html {   box -sizing: bor

APEX Office Print

Image
This post is how we used APEX Office Print (AOP) in the University of Glasgow in Scotland to print APEX forms and loved it 😃 The app The application is a Performance Development Review (PDR) APEX application for staff at the University of Glasgow.  There are 7,000 staff and several different forms depending on the staff role.  A professor will get a different form to a Janitor for example. CSS Print Our first attempt at printing was using a print style sheet.  This worked to a certain extent but we had major issues printing Interactive Grids and you dont have a great deal of control over what gets printed especially as we had several different APEX forms. Apex Office Print to the rescue We purchased AOP on-prem  bronze  and its paid for itself in the year we have been using it as we have went from dozens of print queries where we were constantly updating our print CSS to zero queries (yes zero!!!).  The resulting word documents the users now download are also much more professional lo

Add a chatbot to your APEX app using DialogFlow

Image
This post will show you how you can add a free chatbot to your APEX app using the always free  Oracle Autonomous database and Google’s natural language processing (NLP)   Dialogflow ES . This Oracle APEX  NSS web site  allows users to ask the chatbot for the percentage of students who o verall, were satisfied with the quality of the courses at the University of Glasgow.  It allows users to query over 1,200 courses.   Give it a try  by clicking NSS→Russell Group NSS Course Search Here is some info about how DialogFlow works on another project I built. How I built it. Loaded data into autonomous database I loaded the National Student Survey CSV data into autonomous database using database actions data load; Created a REST API for the data Using the REST action above I created a REST API for the data, it takes a course and aim and retrieves it from the Database Try it out; https://kjwvivmv0n5reuj-apexkqor.adb.uk-london-1.oraclecloudapps.com/ords/admin/nss/q27/Mathematics/BSc This return

Add calculated tooltips to your Interactive Grid

Image
In this post, I will show you how to add a tooltip that calculates column values displayed as tooltips on your Interactive grid or report.  It's a nice value add, giving your users some context to the values in the grid. Demo The tooltip displays the following calculated values from the selected value's column; Create the Interactive Region with static ID  IR_STATIC_ID  using the following SQL source; select  'Product 1'  as PRODUCT,  100  as VALUE_1,  200  as VALUE_2,  '121'  as VALUE_3,  'text'  as  VALUE_4  from  DUAL UNION select  'Product 2'  as PRODUCT,  103  as VALUE_1,  140  as VALUE_2,  '99'  as VALUE_3,  'text'  as  VALUE_4  from  DUAL UNION select  'Product 3'  as PRODUCT,  1  as VALUE_1,  2  as VALUE_2,  '1,200'  as VALUE_3,  'text'  as  VALUE_4  from  DUAL UNION select  'Product 4'  as PRODUCT,  10  as VALUE_1,  7  as VALUE_2,  '124'  as VALUE_3,  'text'  as  VALUE_4  fr

Test & Monitor you APEX app. Part 3 : Monitor your DB with JMeter and Jenkins

Image
This is the third of a series of posts where I will show you how you can use free open source software  Jenkins  and  JMeter    to monitor your APEX database. Part 1 - Monitor your APEX app using Jenkins Part 2 - Monitor your APEX app using Google Analytics In the next post, I will show you how you can run scheduled Selenium tests on your APEX app, the tests will log into your app and run Selenium tests which will be hosted on a free GitHub account using GitHub actions so no installation of any software necessary. You will have your APEX application scheduled selenium tests (getting email alerts if any issues with your APEX application) up in running in minutes by cloning a ready-made GitHub APEX selenium repo. Prerequisite :  Install JMeter  on the same server as Jenkins.  Like Jenkins, JMeter is simple to set up and there are lots of online guides, so I won't go into it here. First we are going to set up the DB monitoring job on JMeter then schedule it from Jenkins. Run JMeter in

Popular posts from this blog

Oracle APEX Interactive Grid colour cells based on a condition using JavaScript and CSS

Oracle APEX style an Interactive Grid cell conditionally based on the value of another cell using JavaScript and CSS

Oracle APEX pretty checkbox item plugin