Scrollspy

Scrollspy is a jQuery plugin that tracks certain elements and which element the user's screen is currently centered on. Our main demo of this is our table of contents on every documentation page to the right. Clicking on these links will also scroll the page to that element.

Notes

Region Position
List Template
Template Option

Any region with the Scrollspy template option within APEX will automatically activate the scrollspy menu on your page with a list on page 0.


SELECT 	null
		,apr.region_name
        ,'#' || nvl(apr.static_id, 'R' || apr.region_id) r
FROM 	apex_application_page_regions apr 
JOIN 	apex_appl_template_options ato
	ON 	ato.region_template_id	= apr.template_id
WHERE 	apr.application_id 		= :APP_ID
AND 	apr.page_id 			= :APP_PAGE_ID
AND		ato.name 				= 'SCROLLSPY'
AND	apr.region_template_options like '%:' || ato.css_classes || ':%'
ORDER BY apr.display_sequence