[trunk] search widget - parameter sort option

[Ferdinand]

the search widget (search window ?) needs a sort option
* no sort
* NLS alphabetic sort

Example products - search category

currently it is
* neither sorted (long complex lists are not usable)
* not searchable - search as you type

[Ferdinand (office-chricar)]

AFAICS the search only returns data for the category entered at product level, but not for "parent" categories.
No user will unerstand this

Suggested solutions
* support search for parents inlcuding children (desired behaviour)
* do not display parents (this requires, that parents are never assigend as implemented for accounts but I think this should be a general rule)

[Jay Vora (Serpent Consulting Services) (jayvora)]

Search on parent+children can be achieved by setting proper domain(operator on filter).
Thanks.

[Olivier Dony (Odoo) (odo-openerp)]

Ferdinand,

Could you explain in more practical and precise terms what you mean, please - this bug report is either invalid or very hard to understand. (e.g: what are you talking about exactly? search widgets? search views? list views? The title talks about sorting, comment #1 talks about a seemingly unrelated search question..)

Search views do not exists by themselves, they're always coupled with another view, either a list view or a calendar/graph view.
Search views/widgets therefore have no sorting option and do not need any, as this is all handled in the associated view.

As for searching through hierarchical structures, this is also supported through the use of the 'child_of' operator, which can be used by search widgets. If I want the categ_id field to search for all products that are either in the selected category or any subcategory, you can make the search widget apply a specific domain by doing the following:

  <field name="categ_id" filter_domain="[('categ_id', 'child_of', self)]"/>

So this is supported by clients and server, and is available for addons to use. BTW this specific last point for products seems more specifically described by bug 631898, so we can close the current one.

[Ferdinand (office-chricar)]

let my try again
1)
Example warehouse / reporting / moves analysis

search for categories "all" - no result (btw category should be a top level search)

or Warehouse / reporting / moves analysis
search category "stuff" (computer stuff - no results

apparently only leaves are searchable not nodes - which is necessary in complex deep structures

2) sort
Warehouse / reporting / moves analysis
group by category + product

results are not sorted - comprehensive for 3 lines in demo data, but UNUSABLE for 50 groups with some 50-100 products / group

and click the column headers does not sort - sorry to say this is not user friendly at all.

unsorted and not sortable lists are an abolute NoGo.

these results can't even be exported to get them sorted in a spreadsheet..

a good idea - but not very useful in day to day live

3) Warehouse / reporting / moves analysis
the column Total Value is a complete nonesense
https://bugs.launchpad.net/openobject-addons/+bug/648678