GitPlanet

Cheap and reliable Node.js hosting starts at $3/month, and $1/month static HTML hosting

Created with love in Canada, visit hostnodejs.com today

Feel like to post an Ad? Learn Details
All Projects → Dani3lSun → apex-plugin-spotlight

Dani3lSun / apex-plugin-spotlight

Licence: MIT license
Oracle APEX Dynamic Action Plugin - APEX Spotlight Search

Programming Languages

javascript
184084 projects - #8 most used programming language
PLSQL
303 projects
CSS
56736 projects

Labels

oracleapexoracle-apexoracle-apex-pluginsorclapex

Projects that are alternatives of or similar to apex-plugin-spotlight

docker-apex-stack
Utility scripts for creating an Oracle Application Express stack as a Docker container.
Stars: ✭ 67 (+235%)
Mutual labels:  oracle, apex, orclapex
apex-plugin-ig simple checkbox
Oracle APEX Item Plugin - IG Simple Checkbox
Stars: ✭ 21 (+5%)
Mutual labels:  oracle, oracle-apex, orclapex
plsql-qr-code
Oracle PL/SQL Package and APEX plugin for QR Code Generation
Stars: ✭ 34 (+70%)
Mutual labels:  oracle, apex
jk64-plugin-reportmap
Report Google Map APEX Plugin
Stars: ✭ 37 (+85%)
Mutual labels:  oracle, oracle-apex
apex-plugin-clockpicker
Oracle APEX Item Plugin - ClockPicker
Stars: ✭ 14 (-30%)
Mutual labels:  oracle, orclapex
apex-plugin-templates
Templates for Oracle APEX Plug-ins
Stars: ✭ 27 (+35%)
Mutual labels:  oracle, orclapex
ApeX
Using Social Engineering To Obtain WiFi Passwords
Stars: ✭ 87 (+335%)
Mutual labels:  apex
linkifier
Database reverse engineering
Stars: ✭ 32 (+60%)
Mutual labels:  oracle
timeline-component-lwc
This component enables timeline view for Salesforce Record history.
Stars: ✭ 18 (-10%)
Mutual labels:  apex
sqle
SQLE is a SQL audit platform | SQLE 是一个支持多场景，原生支持 MySQL 审核且数据库类型可扩展的 SQL 审核工具
Stars: ✭ 731 (+3555%)
Mutual labels:  oracle
R.apex
Functional utility library for Apex
Stars: ✭ 80 (+300%)
Mutual labels:  apex
sha256 plsql
SHA256 PL/SQL Implementation for Oracle 10g,11g.
Stars: ✭ 52 (+160%)
Mutual labels:  oracle
simple-oracledb
Extend capabilities of oracledb with simplified API for quicker development.
Stars: ✭ 34 (+70%)
Mutual labels:  oracle
fapro
Fake Protocol Server
Stars: ✭ 1,338 (+6590%)
Mutual labels:  oracle
sql-agent
HTTP interface for executing ad-hoc SQL queries.
Stars: ✭ 87 (+335%)
Mutual labels:  oracle
content-and-experience-toolkit
The Oracle Content Management Toolkit and SDKs help you develop custom applications that consume content that is managed in the OCM repository. These applications can be developed in the Content Management Cloud or using 3rd party tools.
Stars: ✭ 41 (+105%)
Mutual labels:  oracle
dreaminvest-lwc
Sample application for Lightning Web Components on Salesforce Platform. Part of the sample gallery. Financial services use case. Get inspired and learn best practices.
Stars: ✭ 41 (+105%)
Mutual labels:  apex
EnhancedLightningGrid
Component that allows you to sort and filter data within the Lightning Experience. Use as a replacement for a Related List, or create a new grid that shows results from a custom query.
Stars: ✭ 110 (+450%)
Mutual labels:  apex
ApexCallouts
A lightweight Apex library for making HTTP callouts. Works with remote site settings and named credentials.
Stars: ✭ 32 (+60%)
Mutual labels:  apex
examples
Example code supporting articles
Stars: ✭ 44 (+120%)
Mutual labels:  oracle
View All Similar Projects ➔

Oracle APEX Dynamic Action Plugin - APEX Spotlight Search

APEX Community APEX Plugin APEX Built with Love

APEX Spotlight Search is a powerful search feature (like on MacOS) to search. It provides quick navigation and unified search experience across an APEX application.

Preview

Install

  • Import plugin file "dynamic_action_plugin_de_danielh_apexspotlight.sql" from dist directory into your application
  • Optional: Deploy the JS/CSS files from src/files directory on your web server and change the "Plugin File Prefix" to web servers folder path.
  • Optional: Compile the plugin PL/SQL package in your APEX parsing schema and change the plugin render/ajax function to include the package object name. The package files are located in src/db directory.

Plugin Settings

The plugin settings are highly customizable and you can change:

Application settings

  • Search Placeholder Text - Text that is displayed in the spotlight search input field as an placeholder
  • More Characters Text - Text that is displayed when not enough characters are entered to activate search feature
  • No Match Found Text - Text that is displayed when no search result was found
  • 1 Match Found Text - Text that is displayed when 1 search result was found
  • Multiple Matches Found Text - Text that is displayed when multiple search results were found
  • In-Page Search Text - Text that is displayed in the spotlight search list for in-page search feature
  • Search History Delete Text - Text that is displayed in the spotlight search history list to delete local search history. Only valid when you enabled search history feature

Component settings

  • Enable Keyboard Shortcuts - Enables you to add custom keyboard shortcuts to open spotlight search
  • Keyboard Shortcuts - You can specify multiple keyboard shortcuts, just separate the different shortcuts by a comma
  • Data Source SQL - SQL Query which returns the data which can be searched through spotlight search
    • Column 1: - Name / Title
    • Column 2: - Description
    • Column 3: - Link / URL
    • Column 4: - Icon
      • Column 5: - Icon Background Color (optional)
  • Page Items to Submit - Enter page or application items to be set into session state when the SQL query is executed via an AJAX request
  • Show Processing - Specify whether a waiting / processing indicator is displayed or not. This will replace the default search icon with an spinner as long as data is fetched from database
  • Enable Local Data Cache - Enable data cache to save the complete server response (from Data Source AJAX call) in session storage of browser. This helps to reduce calls from browser to server side
  • Enable In-Page Search - Enable in-page search to highlight found results on the current page depending on the search keyword
  • Enable Prefill Selected Text - Enable prefill selected text to automatically set the spotlight search input to your selected / marked text when it opens
  • Max. Search Display Results - The maximum allowed search results displayed at once
  • Width - Width of the Spotlight search dialog. Enter either numbers for pixel values or percentage values
  • Theme - Choose the Spotlight Search theme which best matches your current UI
  • Search Placeholder Text - Text that is displayed in the spotlight search input field as an placeholder, Overrides application wide plugin setting
  • Search Placeholder Icon - Icon that is displayed in the spotlight search input field as an placeholder
  • Enable Search History - Enable search history to show a popover (on mouse hover of main search icon next to spotlight input field) which contains the last 20 search terms of the user. It uses browsers local storage to store the entered search terms
  • Escape Special Characters - To prevent Cross-Site Scripting (XSS) attacks, always set this attribute to Yes. If you need to render HTML tags stored in the page item or in the entries of a list of values, you can set this flag to No

Plugin Events

  • On Open - DA event that fires when the Spotlight Search dialog opens
  • On Close - DA event that fires when the Spotlight Search dialog closes
  • Executed In-Page Search - DA event that fires when an in-page search is executed - this.data holds the search keyword
  • Get Server Data Error - DA event that fires when the AJAX functions which returns the data (based on your SQL Query) has an error - this.data holds the error message
  • Get Server Data Success - DA event that fires when the AJAX functions which returns the data (based on your SQL Query) is successful - this.data holds the JSON object returned by the server

How to use

  • New DA on an certain event, e.g Page Load or Click
  • New Action: APEX Spotlight Search
  • Choose best fitting settings

Sample SQL Query for data source

SELECT aap.page_title AS title
      ,'Go to page > ' || aap.page_title AS description
      ,apex_page.get_url(p_page => aap.page_id) AS link
      ,'fa-arrow-right' AS icon
  FROM apex_application_pages aap
 WHERE aap.application_id = :app_id
   AND aap.page_mode = 'Normal'
   AND aap.page_requires_authentication = 'Yes'
   AND aap.page_id != 0
 ORDER BY aap.page_id

SELECT aap.page_title AS title
      ,'Go to page > ' || aap.page_title AS description
      ,apex_page.get_url(p_page => aap.page_id) AS link
      ,'fa-arrow-right' AS icon
			,'#479d9d' AS icon_color
  FROM apex_application_pages aap
 WHERE aap.application_id = :app_id
   AND aap.page_mode = 'Normal'
   AND aap.page_requires_authentication = 'Yes'
   AND aap.page_id != 0
 ORDER BY aap.page_id

SELECT aale.entry_text AS title
      ,CASE
         WHEN aale.parent_entry_text IS NULL THEN
          'Application > ' || aale.entry_text
         ELSE
          'Application > ' || aale.parent_entry_text || ' > ' ||
          aale.entry_text
       END AS description
      ,apex_util.prepare_url(p_url => apex_plugin_util.replace_substitutions(p_value => aale.entry_target)) AS link
      ,nvl(aale.entry_image
          ,'fa-file-o') AS icon
  FROM apex_application_list_entries aale
 WHERE aale.application_id = :app_id
   AND aale.list_name = 'Desktop Navigation Menu'

Use the search keyword in your link target or URL using substitution string "~SEARCH_VALUE~"

Note: If an URL contains the substitution string "~SEARCH_VALUE~" the resulting list entry is always shown

SELECT aap.page_title AS title
      ,'Set item with search keyword' AS description
      ,apex_page.get_url(p_page   => aap.page_id
                        ,p_items  => 'P1_ITEM'
                        ,p_values => '~SEARCH_VALUE~') AS link
      ,'fa-home' AS icon
  FROM apex_application_pages aap
 WHERE aap.application_id = :app_id
   AND aap.page_id = 1

SELECT 'Set a item' AS title
      ,'Set item with search keyword on client side' AS description
      ,'javascript:$s(''P1_ITEM'',''~SEARCH_VALUE~'');' AS link
      ,'fa-home' AS icon
  FROM dual

-- navigation menu list
SELECT aale.entry_text AS title
      ,CASE
         WHEN aale.parent_entry_text IS NULL THEN
          'Application > ' || aale.entry_text
         ELSE
          'Application > ' || aale.parent_entry_text || ' > ' ||
          aale.entry_text
       END AS description
      ,apex_util.prepare_url(p_url => apex_plugin_util.replace_substitutions(p_value => aale.entry_target)) AS link
      ,nvl(aale.entry_image
          ,'fa-file-o') AS icon
  FROM apex_application_list_entries aale
 WHERE aale.application_id = :app_id
   AND aale.list_name = 'Desktop Navigation Menu'
UNION ALL
-- static entry --> app wide search
SELECT 'Search Application' AS title
      ,'Search for customers, products, orders or tags...' AS description
      ,apex_page.get_url(p_page        => 30
                        ,p_clear_cache => 30
                        ,p_items       => 'P30_SEARCH'
                        ,p_values      => '~SEARCH_VALUE~') AS link
      ,'fa-search' AS icon
  FROM dual

Demo Application

https://apex.oracle.com/pls/apex/f?p=APEXPLUGIN

Changelog

1.6.1 - Fixed search history issue to recognize stored searches even after new APEX session

1.6.0 - Added search history feature to show a popover (on mouse hover of main search icon) which contains the last 20 search terms a user entered

1.5.2 - Improved handling of multiple usage of plugin on the same page

1.5.1 - Local data store (browsers session storage) now includes dynamic action id to better handle multiple usage of plugin

1.5.0 - Added search placeholder text as component setting, added search placeholder icon setting, added icon background color column in SQL query / fixed security issue & added escaping option / updated libs

1.4.1 - Fixed bug there prefill selected text only worked once / also execute search and list results when AJAX call is still running when typing

1.4.0 - Now you can use spotlight search on DA events + keyboard shortcut in a single DA

1.3.6 - If "Show Processing" option is on, also display a waiting spinner when redirecting to APEX pages

1.3.5 - Added option to show a waiting indicator for processing AJAX call

1.3.4 - Reorganized JavaScript structure (instead of public namespace, extend apex.da with private functions)

1.3.3 - Better escaping of some problematic characters in substitution string (~SEARCH_VALUE~)

1.3.2 - Added new option to automatically prefill spotlight search input with selected, marked text / general code cleanup

1.3.1 - Fixed validation of SQL query when column has a wrong data type / improved error handling of AJAX calls

1.3.0 - Added Spotlight Search themes (Standard, Orange, Red, Dark) / static list entries with description / PL/SQL code cleanup

1.2.3 - Allow up to 9 shortcuts (ctrl + 1, ctrl + 2, ...) for static list entries / prevent default browser shortcuts and always prefer spotlight search / allow shortcuts even if focus is e.g. on an input field

1.2.2 - Fixed IE issue for non working string methods > polyfill for string.startsWith & string.includes

1.2.1 - URLs containing substitution string (~SEARCH_VALUE~) are now shown as static list entries which are always present

1.2.0 - Added possibility to include a substitution string (~SEARCH_VALUE~) in the target link or URL, which gets replaced with the actual search keyword

1.1.0 - Added possibility to cache server response in browsers session storage (reduce number of AJAX calls)

1.0.0 - Initial Release

License

MIT

Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].