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.