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.