Skip to Main Content
Ted Struik - Oracle
Search For
Home
Home
Ted Struik - Oracle
Search
Site Map
Statistics
Page Errors
Apex
Apex
General
Autocomplete
Conditions
Errors
Items used in PL/SQL
Validations
Dynamic Actions
Logs
Version
App-wide Items
Error Handling
Apex Views
Apex Upgrade 4.2 to 5.1
Database Dependencies
Show Source Code
URLs
Authorization
Modal Dialogs
Apex Office Print (AOP)
Apex-Sert
Warn on Unsaved Changes
Form Regions
Reports
Checkboxes
Download
Errors
Nowrap Columns
Substitution Strings
Use IR results in pl/sql
Clickable Row
Row Highlight
Translate Filters etc.
Bar Charts
Column Usage
Reset Pagination
Hide IR Actions menu items
Get Classic Report query
Interactive Grid
ORA-20987
ERR-1002
Copying Text
IG Info
Multiple Row Select
Read Only Options
Search
Sort and Search
Images & Fonts
Standard Icons & Fonts
WebDav
Font Awesome
Icons/image popup LOV
Lists
Hierarchy
LOVs
Definition Bug
Set 1-item LOV to Disabled
With Clause Errors
Modal LOV Plugin
HTML / CSS / JavaScript
Vertical Align
Legend CSS
Geolocation
Apex.confirm
Pie Charts
Codemirror
Theme Roller
Catching Key Strokes
Browser Cache
Locale
RequireJS
Collapsible Regions
Find JavaScript
Import / Export
Dynamic Translations
Translated Pages
APEXExport (java)
apex_export (pl/sql)
Component Settings
Charts
Translate Charts
[Reports] Bar Charts
Shuttles
Shuttle Sorting
Disable Shuttle Items
Menus
Accordion-Like
Scroll bug
Authorization
Session State
About Session State
Rollback & Commit
Performance of v()
Apex Clone Session
Request
Session State in Views
Collections
ORA-20101 & ORA-20104
ORA-00001
Max Row Count
(PL)SQL
(PL)SQL
External Tables
SQL Plus
Conditions
Long
ORDImage
Date & Timestamp
CGI environment
Sys_context
Rounding percentages
Apex_string.split in SQL
Dbms_metadata
Instr
Regular Expressions
Rollback to Savepoint
Use table aliases
(Pipelined) Bulk Collect
JSON
Source Code Search (PL/SQL)
Source Code Search (SQL)
Format Models
Pipelined Table Functions
Hint no_unnest
Listagg
DBA
DBA
Backup & Restore
Users
Export & Import
DBMS Jobs
Tablespaces
Table Size
Flush cache
Access Control List (ACL)
Locks
Java
Constraints
Object Dependencies
Package Dependencies 1
Package Dependencies 2
Grants
SQL History
Startup Errors
ORDS
Miscellaneous
Miscellaneous
Holidays
E-mail
NLExtract
Windows
VPN
VMware
Links
Google
Visualization Orgchart
Hide Search Results
Reverse Proxy
To-do List
Cytoscape
Graphics
Upscaling
Amazon Prices
Domoticz
DDoS
Hobbies
Hobbies
Motorcycles
'95 Kawasaki ZZR 600
'94 Kawasaki ZZR 1100
'91 Honda CBR 600 F2
'95 Kawasaki ZZR 1100
'99 Honda CBR 1100 XX
'00 Honda CBR 1100 XX
'02 Kawasaki ZX-12R (NL)
'05 Ducati 999 (NL)
'08 Honda Fireblade
'07 Suzuki Bandit 1250A
'18 Suzuki GSX-S 1000 F
MotoGP
Garfield
Lyrics
Skydive
Woodworking
Pantorouter
16 inch Bandsaw
Introduction
Frame
Wheels
Wheel mounts
Blade guides
Trunions and table
Enclosure
Alignment and more
Box Joint Jig
Foldable Sawhorses
Strip Sander XL
Photography
Sony RX10 IV
Yes Minister
WinAmp
Find JavaScript
Go
Actions
Workspace
Application Id
Page Id
Object Type
Object Name
Javascript
TEDSTRUIK
25384
-
apex_application_temp_list
javascript_code_onload (menu bar)
var e = apex.jQuery("##PARENT_STATIC_ID#_menubar", apex.gPageContext$); if (e.hasClass("js-addActions")) { apex.actions.addFromMarkup( e ); } e.menu({ behaveLikeTabs: e.hasClass("js-tabLike"), menubarShowSubMenuIcon: e.hasClass("js-showSubMenuIcons") || null, iconType: 'fa', menubar: true, menubarOverflow: true, callout: e.hasClass("js-menu-callout") });
TEDSTRUIK
25384
-
apex_application_temp_list
javascript_code_onload (menu popup)
var e = apex.jQuery("##PARENT_STATIC_ID#_menu", apex.gPageContext$); if (e.hasClass("js-addActions")) { apex.actions.addFromMarkup( e ); } e.menu({ iconType: 'fa', callout: e.hasClass("js-menu-callout")});
TEDSTRUIK
25384
-
apex_application_temp_list
javascript_code_onload (side navigation menu)
apex.jQuery('body').addClass('t-PageBody--leftNav');
TEDSTRUIK
25384
-
apex_application_temp_list
javascript_code_onload (top navigation menu)
var e = apex.jQuery("#t_MenuNav", apex.gPageContext$); if (e.hasClass("js-addActions")) { apex.actions.addFromMarkup( e ); } e.menu({ behaveLikeTabs: e.hasClass("js-tabLike"), menubarShowSubMenuIcon: e.hasClass("js-showSubMenuIcons") || null, menubar: true, menubarOverflow: true, callout: e.hasClass("js-menu-callout") });
TEDSTRUIK
25384
-
apex_application_temp_list
javascript_code_onload (wizard progress)
apex.theme.initWizardProgressBar();
1 - 5 of 189
Column Actions
Search
Info
Searching for javaScript in Apex applications is not difficult; there are multiple ways to do that - for example:
Use the Search function of the Apex Builder. The best option but not complete and not easy to use/export.
Search through an application export. Not very easy to read.
Use the report under Utilities - Embedded Code in the Apex Builder. Nice but also incomplete.
So, to find all JavaScript in the entire application, I created a view.
I'm quite sure it is not complete either, but extending this view would be quite easy.
The Apex views contain all the information we need here; we just have to find it.
So I combined the views/columns I knew about, with all the views/columns that have JS or JAVASCRIPT in their column names and/or comments.
This results in quite a large list - see the query of the view below - of both actual JavaScript code and references to files that contain JavaScript.
This is the query I used to create the SQL statements for the Apex views, for use in my own view:
select '-- ' || tc.table_name || ' - ' || tc.column_name || chr(13) || chr(10) || 'select t.workspace, t.application_id' || ', ' || ( case when exists(select 1 from all_tab_cols tc2 where tc2.table_name = tc.table_name and tc2.column_name = 'PAGE_ID') then 't.page_id' else 'to_number(null) as page_id' end ) || ', ''' || lower(tc.table_name)|| ''' as object_type' -- || ', ''' || lower(tc.column_name) || ( case when tc.table_name like 'APEX_APPLICATION_TEMP_%' then ' ('' || lower(t.template_name) || '')' else null end ) || ''' as object_name' -- || ', ' || ( case when tc.data_type = 'CLOB' then 't.' || tc.column_name else 'to_clob(t.' || lower(tc.column_name) || ')' end ) || ' as javascript' || ' from iv_app' || ' join ' || lower(tc.table_name) || ' t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id)' || ' where length(' || lower(tc.column_name) || ') > 1' || ( case when tc.table_name like 'APEX_APPLICATION_TEMP_%' then ' and t.theme_number = iv_app.theme_number' else null end ) || chr(13) || chr(10) || 'union all' || chr(13) || chr(10) as s from all_tab_cols tc join apex_dictionary ady on ady.apex_view_name = tc.table_name and ady.column_name = tc.column_name where ( tc.column_name like '%JS\_%' escape '\' --' or tc.column_name like '%JAVASCRIPT%' or lower(ady.comments) like '%javascript%' ) and tc.data_length >= 4000 order by 1
This approach would also work for finding CSS I suppose - same idea, just using different views.
Code
Page
Identification
Page ID
1176
Name
Apex - HTML / CSS / JavaScript - Find JavaScript
Page Alias
APEX-HTML-CSS-JAVASCRIPT-FIND-JAVASCRIPT
Region
Identification
Sequence
10
Title
Find JavaScript
Type
Interactive Report
Source
Source Type
DYNAMIC_QUERY
Table Name
TED_P1176_V
View
View
Name
ted_p1176_v
DDL
with iv_app as ( -- Applications select app.workspace , app.application_id , app.application_name , app.theme_number from apex_applications app where app.application_id = nvl(nv('APP_ID'), 25384) ) -- Dynamic Actions (Javascript Code) select dan.workspace , dan.application_id , dan.page_id , 'Dynamic Action (Javascript Code)' as object_type , dan.dynamic_action_name || ' (' || daa.dynamic_action_event_result || ')' as object_name , to_clob(daa.attribute_01) as javascript from iv_app join apex_application_page_da dan on (dan.workspace = iv_app.workspace and dan.application_id = iv_app.application_id) join apex_application_page_da_acts daa on daa.dynamic_action_id = dan.dynamic_action_id where daa.action_code = 'NATIVE_JAVASCRIPT_CODE' union all -- Dynamic Actions (Set Value) select dan.workspace , dan.application_id , dan.page_id , 'Dynamic Action (Set Value)' as object_type , dan.dynamic_action_name || ' (' || daa.dynamic_action_event_result || ')' as object_name , to_clob(daa.attribute_05) as javascript from iv_app join apex_application_page_da dan on (dan.workspace = iv_app.workspace and dan.application_id = iv_app.application_id) join apex_application_page_da_acts daa on daa.dynamic_action_id = dan.dynamic_action_id where daa.action_code = 'NATIVE_SET_VALUE' and daa.attribute_01 = 'JAVASCRIPT_EXPRESSION' union all -- APEX_APPLICATIONS - JAVASCRIPT_FILE_URLS select t.workspace, t.application_id, to_number(null) as page_id, 'apex_applications' as object_type, 'javascript_file_urls' as object_name, to_clob(t.javascript_file_urls) as javascript from iv_app join apex_applications t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(javascript_file_urls) > 1 union all -- APEX_APPLICATIONS - PWA_SERVICE_WORKER_HOOKS select t.workspace, t.application_id, to_number(null) as page_id, 'apex_applications' as object_type, 'pwa_service_worker_hooks' as object_name, t.PWA_SERVICE_WORKER_HOOKS as javascript from iv_app join apex_applications t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(pwa_service_worker_hooks) > 1 union all -- APEX_APPLICATION_NAV_BAR - ONCLICK_JAVASCRIPT select t.workspace, t.application_id, to_number(null) as page_id, 'apex_application_nav_bar' as object_type, 'onclick_javascript' as object_name, to_clob(t.onclick_javascript) as javascript from iv_app join apex_application_nav_bar t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(onclick_javascript) > 1 union all -- APEX_APPLICATION_PAGES - JAVASCRIPT_CODE select t.workspace, t.application_id, t.page_id, 'apex_application_pages' as object_type, 'javascript_code' as object_name, t.JAVASCRIPT_CODE as javascript from iv_app join apex_application_pages t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(javascript_code) > 1 union all -- APEX_APPLICATION_PAGES - JAVASCRIPT_CODE_ONLOAD select t.workspace, t.application_id, t.page_id, 'apex_application_pages' as object_type, 'javascript_code_onload' as object_name, t.JAVASCRIPT_CODE_ONLOAD as javascript from iv_app join apex_application_pages t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(javascript_code_onload) > 1 union all -- APEX_APPLICATION_PAGES - JAVASCRIPT_FILE_URLS select t.workspace, t.application_id, t.page_id, 'apex_application_pages' as object_type, 'javascript_file_urls' as object_name, to_clob(t.javascript_file_urls) as javascript from iv_app join apex_application_pages t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(javascript_file_urls) > 1 union all -- APEX_APPLICATION_PAGES - PAGE_HTML_ONLOAD select t.workspace, t.application_id, t.page_id, 'apex_application_pages' as object_type, 'page_html_onload' as object_name, to_clob(t.page_html_onload) as javascript from iv_app join apex_application_pages t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(page_html_onload) > 1 union all -- APEX_APPLICATION_PAGE_CHARTS - JAVASCRIPT_CODE select t.workspace, t.application_id, t.page_id, 'apex_application_page_charts' as object_type, 'javascript_code' as object_name, to_clob(t.javascript_code) as javascript from iv_app join apex_application_page_charts t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(javascript_code) > 1 union all -- APEX_APPLICATION_PAGE_DA_ACTS - INIT_JAVASCRIPT_CODE select t.workspace, t.application_id, t.page_id, 'apex_application_page_da_acts' as object_type, 'init_javascript_code' as object_name, to_clob(t.init_javascript_code) as javascript from iv_app join apex_application_page_da_acts t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(init_javascript_code) > 1 union all -- APEX_APPLICATION_PAGE_ITEMS - INIT_JAVASCRIPT_CODE select t.workspace, t.application_id, t.page_id, 'apex_application_page_items' as object_type, 'init_javascript_code' as object_name, to_clob(t.init_javascript_code) as javascript from iv_app join apex_application_page_items t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(init_javascript_code) > 1 union all -- APEX_APPLICATION_PAGE_REGIONS - INIT_JAVASCRIPT_CODE select t.workspace, t.application_id, t.page_id, 'apex_application_page_regions' as object_type, 'init_javascript_code' as object_name, to_clob(t.init_javascript_code) as javascript from iv_app join apex_application_page_regions t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(init_javascript_code) > 1 union all -- APEX_APPLICATION_TEMP_LIST - JAVASCRIPT_CODE_ONLOAD select t.workspace, t.application_id, to_number(null) as page_id, 'apex_application_temp_list' as object_type, 'javascript_code_onload (' || lower(t.template_name) || ')' as object_name, to_clob(t.javascript_code_onload) as javascript from iv_app join apex_application_temp_list t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(javascript_code_onload) > 1 and t.theme_number = iv_app.theme_number union all -- APEX_APPLICATION_TEMP_LIST - JAVASCRIPT_FILE_URLS select t.workspace, t.application_id, to_number(null) as page_id, 'apex_application_temp_list' as object_type, 'javascript_file_urls (' || lower(t.template_name) || ')' as object_name, to_clob(t.javascript_file_urls) as javascript from iv_app join apex_application_temp_list t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(javascript_file_urls) > 1 and t.theme_number = iv_app.theme_number union all -- APEX_APPLICATION_TEMP_PAGE - DIALOG_JS_CANCEL_CODE select t.workspace, t.application_id, to_number(null) as page_id, 'apex_application_temp_page' as object_type, 'dialog_js_cancel_code (' || lower(t.template_name) || ')' as object_name, to_clob(t.dialog_js_cancel_code) as javascript from iv_app join apex_application_temp_page t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(dialog_js_cancel_code) > 1 and t.theme_number = iv_app.theme_number union all -- APEX_APPLICATION_TEMP_PAGE - DIALOG_JS_CLOSE_CODE select t.workspace, t.application_id, to_number(null) as page_id, 'apex_application_temp_page' as object_type, 'dialog_js_close_code (' || lower(t.template_name) || ')' as object_name, to_clob(t.dialog_js_close_code) as javascript from iv_app join apex_application_temp_page t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(dialog_js_close_code) > 1 and t.theme_number = iv_app.theme_number union all -- APEX_APPLICATION_TEMP_PAGE - DIALOG_JS_INIT_CODE select t.workspace, t.application_id, to_number(null) as page_id, 'apex_application_temp_page' as object_type, 'dialog_js_init_code (' || lower(t.template_name) || ')' as object_name, to_clob(t.dialog_js_init_code) as javascript from iv_app join apex_application_temp_page t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(dialog_js_init_code) > 1 and t.theme_number = iv_app.theme_number union all -- APEX_APPLICATION_TEMP_PAGE - GRID_JAVASCRIPT_DEBUG_CODE select t.workspace, t.application_id, to_number(null) as page_id, 'apex_application_temp_page' as object_type, 'grid_javascript_debug_code (' || lower(t.template_name) || ')' as object_name, to_clob(t.grid_javascript_debug_code) as javascript from iv_app join apex_application_temp_page t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(grid_javascript_debug_code) > 1 and t.theme_number = iv_app.theme_number union all -- APEX_APPLICATION_TEMP_PAGE - JAVASCRIPT_CODE select t.workspace, t.application_id, to_number(null) as page_id, 'apex_application_temp_page' as object_type, 'javascript_code (' || lower(t.template_name) || ')' as object_name, t.JAVASCRIPT_CODE as javascript from iv_app join apex_application_temp_page t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(javascript_code) > 1 and t.theme_number = iv_app.theme_number union all -- APEX_APPLICATION_TEMP_PAGE - JAVASCRIPT_CODE_ONLOAD select t.workspace, t.application_id, to_number(null) as page_id, 'apex_application_temp_page' as object_type, 'javascript_code_onload (' || lower(t.template_name) || ')' as object_name, t.JAVASCRIPT_CODE_ONLOAD as javascript from iv_app join apex_application_temp_page t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(javascript_code_onload) > 1 and t.theme_number = iv_app.theme_number union all -- APEX_APPLICATION_TEMP_PAGE - JAVASCRIPT_FILE_URLS select t.workspace, t.application_id, to_number(null) as page_id, 'apex_application_temp_page' as object_type, 'javascript_file_urls (' || lower(t.template_name) || ')' as object_name, to_clob(t.javascript_file_urls) as javascript from iv_app join apex_application_temp_page t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(javascript_file_urls) > 1 and t.theme_number = iv_app.theme_number union all -- APEX_APPLICATION_TEMP_REGION - JAVASCRIPT_CODE_ONLOAD select t.workspace, t.application_id, to_number(null) as page_id, 'apex_application_temp_region' as object_type, 'javascript_code_onload (' || lower(t.template_name) || ')' as object_name, to_clob(t.javascript_code_onload) as javascript from iv_app join apex_application_temp_region t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(javascript_code_onload) > 1 and t.theme_number = iv_app.theme_number union all -- APEX_APPLICATION_TEMP_REGION - JAVASCRIPT_FILE_URLS select t.workspace, t.application_id, to_number(null) as page_id, 'apex_application_temp_region' as object_type, 'javascript_file_urls (' || lower(t.template_name) || ')' as object_name, to_clob(t.javascript_file_urls) as javascript from iv_app join apex_application_temp_region t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(javascript_file_urls) > 1 and t.theme_number = iv_app.theme_number union all -- APEX_APPLICATION_TEMP_REPORT - JAVASCRIPT_CODE_ONLOAD select t.workspace, t.application_id, to_number(null) as page_id, 'apex_application_temp_report' as object_type, 'javascript_code_onload (' || lower(t.template_name) || ')' as object_name, to_clob(t.javascript_code_onload) as javascript from iv_app join apex_application_temp_report t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(javascript_code_onload) > 1 and t.theme_number = iv_app.theme_number union all -- APEX_APPLICATION_TEMP_REPORT - JAVASCRIPT_FILE_URLS select t.workspace, t.application_id, to_number(null) as page_id, 'apex_application_temp_report' as object_type, 'javascript_file_urls (' || lower(t.template_name) || ')' as object_name, to_clob(t.javascript_file_urls) as javascript from iv_app join apex_application_temp_report t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(javascript_file_urls) > 1 and t.theme_number = iv_app.theme_number union all -- APEX_APPLICATION_THEMES - JAVASCRIPT_FILE_URLS select t.workspace, t.application_id, to_number(null) as page_id, 'apex_application_themes' as object_type, 'javascript_file_urls' as object_name, to_clob(t.javascript_file_urls) as javascript from iv_app join apex_application_themes t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(javascript_file_urls) > 1 union all -- APEX_APPL_PAGE_IGS - JAVASCRIPT_CODE select t.workspace, t.application_id, t.page_id, 'apex_appl_page_igs' as object_type, 'javascript_code' as object_name, to_clob(t.javascript_code) as javascript from iv_app join apex_appl_page_igs t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(javascript_code) > 1 union all -- APEX_APPL_PAGE_IG_COLUMNS - INIT_JAVASCRIPT_CODE select t.workspace, t.application_id, t.page_id, 'apex_appl_page_ig_columns' as object_type, 'init_javascript_code' as object_name, to_clob(t.init_javascript_code) as javascript from iv_app join apex_appl_page_ig_columns t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(init_javascript_code) > 1 union all -- APEX_APPL_PAGE_IG_COLUMNS - JAVASCRIPT_CODE select t.workspace, t.application_id, t.page_id, 'apex_appl_page_ig_columns' as object_type, 'javascript_code' as object_name, to_clob(t.javascript_code) as javascript from iv_app join apex_appl_page_ig_columns t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(javascript_code) > 1 union all -- APEX_APPL_PLUGINS - JAVASCRIPT_FILE_URLS select t.workspace, t.application_id, to_number(null) as page_id, 'apex_appl_plugins' as object_type, 'javascript_file_urls' as object_name, to_clob(t.javascript_file_urls) as javascript from iv_app join apex_appl_plugins t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(javascript_file_urls) > 1 union all -- APEX_APPL_USER_INTERFACES - JAVASCRIPT_FILE_URLS select t.workspace, t.application_id, to_number(null) as page_id, 'apex_appl_user_interfaces' as object_type, 'javascript_file_urls' as object_name, to_clob(t.javascript_file_urls) as javascript from iv_app join apex_appl_user_interfaces t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(javascript_file_urls) > 1