Apex_Profiler

Apex_Profiler

Description

APEX profile Plugin is designed to display User profile

References

Big thanks to Muqbil Khan for sharing this amazing idea.

Sample Query

SELECT
  'Ashish' FIRST_NAME,
  'Sahay' LAST_NAME,  'https://1.bp.blogspot.com/-V1JkM-D5VY4/XmCZuNHGytI/AAAAAAAAdec/RsZXgr11hHM8TXuWiLyns_4L9DJ4LPD2QCK4BGAYYCw/s113/0%253Fe%253D1586390400%2526v%253Dbeta%2526t%253DrDhapAPOdu3qco8WpAs1kTxVPf0533bNvx92guVCyVw' IMAGE_SRC,
  "https://avatars0.githubusercontent.com/u/13847003?s=60&v=4" USER_LOGO,
  '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;

JSON Configuration

{
	"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

#Query Attributes

Attribute Name	Description	Example
FIRST_NAME	Display First Name in Profile	Ashish
LAST_NAME	Display Last Name in Profile	Sahay
IMAGE_SRC	User  Profile image URL	https://1.bp.blogspot.com/-V1JkM-https://www.w3schools.com/howto/img_avatar.png
USER_LOGO	User  Logo URL	https://avatars0.githubusercontent.com/u/13847003?s=60&v=4
EDIT_LINK_SRC	Profile Edit link	https://www.ashishsahay.com/search/label/APEX
EDIT_LINK_LABEL	Edit Profile Label	View My Blogs/ Edit Profile
EMAIL	User email address	ashishk392@gmail.com
ORG_NAME	Organization/ Company name	INCEDO INC.
ORG_LABEL	Organization/Company Label	Company / Organization/ Country
DESIGNATION	User designation	Oracle APEX Developer
LEFT_BUTTON_LABEL	Left Button Label	Github
RIGHT_BUTTON_LABEL	Right Button Label	Blogs/ Sign Out
LEFT_BUTTON_LINK	Left Button Link	https://www.ashishsahay.com
RIGHT_BUTTON_LINK	Right Button Link	https://www.ashishsahay.com
RIGHT_BUTTON_HOT	Right Button Hot or Not	true/ false
LEFT_BTN_ICON_POS	Left Button Icon position	left/ right
RIGHT_BTN_ICON_POS	Right Button Icon position	left/ right
LEFT_BTN_ICON	Left Button Icon	fa fa-github
RIGHT_BTN_ICON	Right Button Icon	fa fa-google

Button Visibility

• Hide Left Button (Yes / No)
• Hide Right Button (Yes / No)

TO DO

• Comaptible with all versions of APEX
• Escape special Characters

Explanation

Blog

Demo

Change Log

• 2020 March 06 : Initial Version 1.0.1
• 2020 March 08 : Compatible with 5.1 and above versions 1.1
• 2020 November 29:
  • Compatible with 5.0 and above versions
  • Buttons can be removed
  • User avatar logo is visble if passed in query (Try fit size as per menu item)

😄