APEX user profiler

March 7, 2020Posted inAPEX, PLUGINS

APEX user profile utility

Preview

This plugin is inspired by the APEX workspace user profile option.

Steps

  • Download Plugin
  • Install to your application
  • Create Dynamic action on load
  • Add true action
  • Setup profile panel JSON
  • Create triggering Element: Trigger Element ID- eg. open-apex-profile
  • Define SQL Source
  • Escape Special Characters: To do : Leave it for now
  • Create Entry in the Navigation bar to trigger APEX profile panel
    • Target Type: URL
    • URL Target : #
    • User Defined Attributes: 2. List Item CSS Classes – open-apex-profile (Trigger Element)

JSON Configuration

Copy Code
{
 "isActiveColor": "#F44336",
 "isInctiveColor": "#F4bc36",
 "panelHeight": "216px",
 "panelWIdth": "401px",
 "marginRight": "0px",
 "marginTop": "48px"
}

  • isActiveColor: Navigation bar Entry background color when APEX profiler is open
  • isInctiveColor: Navigation bar Entry background color when APEX profiler is closed
  • panelHeight: APEX Profiler panel height
  • panelWIdth: APEX Profiler panel width
  • marginRight: APEX profiler distance from Right
  • marginTop : APEX profiler distance from TOP

Sample Query:

Copy Code
SELECT
   'Ashish' FIRST_NAME,
   'Sahay' LAST_NAME,
   'https://blogs.ontoorsolutions.com/images/authors/ashish-sahay.jpg' IMAGE_SRC,
   'https://www.ashishsahay.com/search/label/APEX' EDIT_LINK_SRC,
   'ashishk392@gmail.com' EMAIL,
   'INCEDO INC.' ORG_NAME,
   'Company' ORG_LABEL,
   'Oracle Apex Developer' DESIGNATION,
   'Github' LEFT_BUTTON_LABEL,
   'Blogs' RIGHT_BUTTON_LABEL,
   'https://github.com/ashishtheapexian' LEFT_BUTTON_LINK,
   'https://www.ashishsahay.com' RIGHT_BUTTON_LINK,
   'true' LEFT_BUTTON_HOT,
   'true' RIGHT_BUTTON_HOT,
   'left' LEFT_BTN_ICON_POS,
   'right' RIGHT_BTN_ICON_POS,
   'fa fa-github' LEFT_BTN_ICON,
   'fa fa-google' RIGHT_BTN_ICON,
   'See My Blogs' EDIT_LINK_LABEL
FROM
   DUAL;

Attributes

Attribute NameDescriptionExample
FIRST_NAMEDisplay First Name in ProfileAshish
LAST_NAMEDisplay Last Name in ProfileSahay
IMAGE_SRCUser Profile image URLhttps://1.bp.blogspot.com/-V1JkM-https://www.w3schools.com/howto/img_avatar.png
EDIT_LINK_SRCProfile Edit linkhttps://www.ashishsahay.com/search/label/APEX
EDIT_LINK_LABELEdit Profile LabelView My Blogs/ Edit Profile
EMAILUser email addressxyxxz—abc@gmail.com
ORG_NAMEOrganization/ Company nameINCEDO INC.
ORG_LABELOrganization/Company LabelCompany / Organization/ Country
DESIGNATIONUser designationOracle Apex Developer
LEFT_BUTTON_LABELLeft Button LabelGithub
RIGHT_BUTTON_LABELRight Button LabelBlogs/ Sign Out
LEFT_BUTTON_LINKLeft Button Linkhttps://www.ashishsahay.com
RIGHT_BUTTON_LINKRight Button Linkhttps://www.ashishsahay.com
RIGHT_BUTTON_HOTRight Button Hot or Nottrue/ false
LEFT_BTN_ICON_POSLeft Button Icon positionleft/ right
RIGHT_BTN_ICON_POSRight Button Icon positionleft/ right
LEFT_BTN_ICONLeft Button Iconfa fa-github
RIGHT_BTN_ICONRight Button Iconfa fa-google

Screenshots:

 

 

 

 

 

 

 2. List Item CSS Classes

Final Preview

Preview

To DO

  •  Escape Special Characters

Source:

Download source from GitHub.
Report a bug
Demo

References: https://oracle-apex5.blogspot.com/2017/10/apex-builder-profil-menu.html

https://oracle-apex5.blogspot.com/2017/10/apex-builder-profil-menu.html

Tags: