APEX-PLUGIN.COM

..the apex plugin directory

an initiative of

Add your APEX4.0 Plugin info

Describe your Plugin’s features. You can upload the Plugin’s code and documentation, or, alternatively, submit the URLs to your Website, GitHup Repository or Blog.

You are here:
Follow us on Twitter
Item Plugin Flexfields

Flexfields

4
Categories: Item Plugin
Author: Josep

Changing field types dinamically

Some applications leave administrators the capability of extending its application by adding some fields to existing tables. In that case, administrator can expand application functionality by storing some data to application without the need of technical assistance.

Demo: https://apex.oracle.com/pls/apex/f?p=JOSEPCOVES:FLEXFIELD

Tutorial: http://www.relational.es/blog/en/apex-relational-flexfield-plugin-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 value

from FLEXFIELD_DEF

where flexfield_name = 'MyField01' 

Special Requirements
- An existing data base table with N flexfield fields of varchar2(4000) to fill

- Optional: flexfield metadata table (FLEXFIELD_DEF, see example below)

- This plugin on some page

Keywords
flexfields, item type, apex

Oracle APEX Plugin
Company: RELATIONAL
Date added: 17.11.2015
Views: 2825
Votes: 2
Reviews: 0
Min. APEX Version:
4.0
Share on Facebook
Digg! Share on Digg
Save This Page
Link to:
Download
download apex plugin
If something is not correct please report it here: Report Listing
Do you have a question about this Plugin? Want to write a Review or Comment?
Login first.
Reviews / Questions / Comments are e-mailed to the author of the Plug-in.
Powered by Sigsiu.NET RSS Feeds

Disclaimer: The APEX Plugins on this site are not supported by Oracle Support Services.

If you have a question about a Plugin or need support: Login and select the plugin detail page. At the bottom you can enter your Question / Review / Remark.
Your message will be sent to the author of the plugin.