The Perl Toolchain Summit needs more sponsors. If your company depends on Perl, please support this very important event.

NAME

OpenERP::OOM::Tutorial::Searching

DESCRIPTION

Complex Search Terms

OpenERP allows logic operators like most database wrappers, just a little stranger. It uses postfix style operators to allow you to or things together. You can also use '&' as an operator.

    my $products = $schema->class('Product');
    $products->search('|',  '|', 
                    [ 'default_code', 'ilike', '%' . $query . '%' ],
                    [ 'description', 'ilike', '%' . $query . '%' ],
                    [ 'name', 'ilike', '%' . $query . '%' ]);

For more details see the OpenERP Developer book.