Generate an option bar from an option_list, which has the structure:

    {
        {variable "Title" defaultvalue
            {
                {value "Label" {key sql-clause}}
                ...
            }
        }
        ...
    }
    

    set dimensional_list {
        {visited "Last Visit" 1w {
            {never "Never" {where "last_visit is null"}}
            {1m "Last Month" {where "last_visit + 30 > sysdate"}}
            {1w "Last Week" {where "last_visit + 7 > sysdate"}}
            {1d "Today" {where "last_visit > trunc(sysdate)"}}
        }}
        ..(more of the same)..
    }
    

Switches:

-style

(optional)

name of the adp file (without extension)

Parameters:

option_list - the structure with the option data provided
url (optional) - url target for select (if blank we set it to ad_conn url).
options_set (optional) - if not provided defaults to [ns_getform], for hilite of selected options.
optionstype (defaults to "url") - only url is used now, was thinking about extending so we get radio buttons and a form since with a slow select updating one thing at a time would be stupid.

Returns:

HTML rendering

Partial Call Graph (max 5 caller/called nodes):

Testcases:

ad_dimensional

Given what clause we are asking for and the joiner this returns the sql fragment

Parameters:

option_list - the structure with the option data provided
what (defaults to "where") - look for such keys in the option_list
joiner (defaults to "and") - join string for combining multiple clauses
options_set (optional) - ns_set for reading variables

Returns:

SQL clause

See Also:

• ad_dimensional

Partial Call Graph (max 5 caller/called nodes):

Testcases:

ad_dimensional