Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Olivier Auverlot: "At my work (a universitary computer research laboratory), I'm alone to create all applications and databases. I don't know how I could do all the work without it. It's really a very productive software. I can focus on the database schemas and create quickly the user applications with a minimal amount of code to maintain".
John Gondek: "Your software is amazing. I consider myself a novice at PHP and JS and with your software I have a web page that is truly fantastic. Thank you so much ".

More

Add your opinion

PostgreSQL PHP Generator online Help

Prev Return to chapter overview Next

OnGetSelectionFilters

This event allows you to specify a set of pre-defined options for record selection.

 

Signature:

function OnGetSelectionFilters(FixedKeysArray $columns, &$result)

 

Parameters:

$columns

An associative array of columns available for filtering.

$result

An associative array of selection options (caption => filter)

 

Example

 

This example adds "Americas", "Asia+Africa", and "Europe" selection options. Clicking an option selects the corresponding countries.

 

$result = array(

    'Americas' => new FilterCondition(

        $columns['continent'],

        FilterConditionOperator::ENDS_WITH,

        array('America')

    ),

    'Asia+Africa' => new FilterGroup(FilterGroupOperator::OPERATOR_OR,

        array(

            new FilterCondition($columns['continent'], 

                       FilterConditionOperator::EQUALS, array('Asia')),

            new FilterCondition($columns['continent'],

                       FilterConditionOperator::EQUALS, array('Africa'))

        )

    ),

    'Europe' => new FilterCondition(

        $columns['continent'],

        FilterConditionOperator::EQUALS,

        array('Europe')

    ),

);



Prev Return to chapter overview Next