Feature request #10532

Postgis provider: the way in which other styles saved in layer_styles are presented should be more usable

Added by Gabriele Monfardini about 6 years ago. Updated almost 3 years ago.

Status:Open
Priority:Normal
Assignee:-
Category:Unknown
Pull Request or Patch supplied:No Resolution:
Easy fix?:No Copied to github as #:18941

Description

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:

  1. dialog exposes also table_catalog, table_schema, table_name and update_time
  2. results are sorted by table_catalog, table_schema, table_name and update_time (desc)
  3. 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.

History

#1 Updated by Giovanni Manghi over 3 years ago

  • Easy fix? set to No

#2 Updated by Jürgen Fischer almost 3 years ago

  • Category set to Unknown

Also available in: Atom PDF