projekt kivitendo

Evaluates C<$params{sort_by}> and C<$params{sort_dir}> and returns an

SQL string suitable for sorting. The package this package is mixed

into has to provide a method L</_sort_spec> that returns a hash whose

columns may be sorted, which column to sort by by default and how to

handle C<NULL> values.

               customer_name           => 'lower(customer.name)',

             },

then the default column name will be used.

The value can be either a scalar or an array reference. If it's the

will be sorted. If undefined then the decision is left to the

database.

classes. The value is either C<FIRST> or C<LAST>.

If it is a hash reference then its keys are column names (not SQL

names). The values are either C<FIRST> or C<LAST>. If a column name is

up and used if it is found.

Example: