![]() ![]() The query should return two columns: d and r (for display-value and return-value) and contain a where clause that refers to the parent elements value. (ie: - please make a choice - ) query: Enter the query responsible for populating the child element. The plugin can only handle singular primary keys, use rowid if needed child element: This is the child, you need to enter the NAME attribute of the item, find it by using your browsers' inspector nothing selected text: Enter the text that must be displayed when nothing is chosen. Find it by searching for the name attribute for the (hidden) element that holds the rows' key. It is needed to be able to select the child's value. Create a tabular form Set the relevant items to be a select list the parent or master is a regular select list, use SQL, Shared Component, or any other means to populate your select list the child column should have a query that only returns a message ie: select '- please choose -' as d, null as r from dual or it should not return anything select null as d, null as r from dual where 1=0 Now you add the plugin (it is a dynamic action plugin) triggering element: This is the master, you need to enter the NAME attribute of the item, find it by using your browsers' inspector row key: This is the element that holds the primary key of your tabular form. The plugin supports multiple instances on one page as seen here (f?p= APP_ID.:235: APP_SESSION.::NO:::). Inspired by a really old blog (::::::) by Denes Kubicek, I decided to turn his solution into a usable plugin. If No is selected then the animation will continue whether the mouse hovers over the carousel or not. InstallationJust import theitem_type_plugin_com_jafr_bootstrap_carousel.sqlfile into your APEX application and add the plugin to any region.SettingsFirst Image Link:The link of the first image is placed in this text field.Second Image Link:The link of the second image is placed in this text field.Third Image Link:The link of the third image is placed in this text field.Data Interval:Number of seconds delay between slide transitionsAvailable options include:1 Second2 Seconds3 Seconds5 Seconds10 Seconds15 Seconds30 SecondsPause On Hover:If Yes is selected then the animation will pause on mouse hover and resume upon mouse leave. Keyboard functionality is also supported and changing the slides can be controlled via the left and right arrow keys.This carousel is based on disribution 3.3.6 of bootstrap and includes the necessary. ![]() Oracle APEX Bootstrap Carousel PluginThis plugin will add a bootstrap carousel with three images (from external sources or from your web server content or files in your Static Application Files) that automatically sets its width accordingly. Demo: Tutorial: SQL source options:Select FLEX_NAME, -(varchar2) Flexfield name FLEX_DESC, -(varchar2) Flexfield description -> Shown at help FLEX_TYPE, -(varchar2) STRING, LOV, LOVSQL, TEXTAREA -> Type of flexfield FLEX_LOV, -(varchar2) Name of APEX LOV for LOV type flexfields FLEX_NULLABLE, -(char(1)) S, N -> Specifies if allows null values FLEX_SIZE, -(Integer) Size of the HTML element FLEX_MAX_LENGTH, -(Integer) Max length of its content (only for STRING and TEXTAREA types) FLEX_HEIGHT, -(Integer) Height of HTML element (only for TEXTAREA) FLEX_HTML_ATTR, -(varchar2) Additional HTML element attributes FLEX_LOV_SQL -(varchar2) In case TYPE= LOVSQL this column specifies LOV SQL returning pairs display value and return valuefrom FLEXFIELD_DEF where flexfield_name = 'MyField01' In that case, administrator can expand application functionality by storing some data to application without the need of technical assistance. Some applications leave administrators the capability of extending its application by adding some fields to existing tables. LICENSE = This Plugin is free and licensed under the MIT license: * If you need headers rotated at 90 degree please let me know in the comment section. Also the plug-in can only make vertical headers rotated at 270 degree. 80 Supported Apex Versions and options = Apex 4.2 - Full Support Apex 5.0 - Basic Support Apex Version IR Option Plug-in Compatibility - Apex 4.2 Control Break Supported Apex 5.0 Control Break Not Supported Apex 5.0 Pivot Not Supported Apex 5.0 Fixed Headers Not Supported Stay tuned for more information or support. ![]() Supported Browsers = The plug-in is tested in the following browsers: Internet explorer 8, 9, 11 Firefox 41.0.1 Opera 10.63 Opera 33.0 Google Chrome. This is free cross browser and easy in adjustment extension to Interactive Report. ![]() Current Release = 0.8 beta INSTRUCTION = The plug-in allows you to position IR headers vertically. ![]()
0 Comments
Leave a Reply. |