Feature request #10532
Postgis provider: the way in which other styles saved in layer_styles are presented should be more usable
|Pull Request or Patch supplied:||No||Resolution:|
|Easy fix?:||No||Copied to github as #:||18941|
When a user try to load styles from public.layer_styles that are not referred to the vector at hand (the query selectOthersQuery in function listStyles in file ~qgis/src/providers/postgres/qgspostgresprovider.cpp) the results are sorted by update_time desc.
From the perspective of the user, the order of the results seems randomic.
When there are many results, finding the desired style is difficult even knowing its name, the name of the table and so on.
Since stylization often depends on the attributes of the vector, it would be useful to know also table name and table schema.
I propose to modify the dialog and the query as follows:
- dialog exposes also table_catalog, table_schema, table_name and update_time
- results are sorted by table_catalog, table_schema, table_name and update_time (desc)
- results are sortable clicking table column headers
The best would be to provide also a text box to filter the results applying partial text match on all column data.