[QGIS-Developer] Docs/Instructions for Filter/Query Builder

[Delaz J]

Hi,

Le 23/10/2021 à 14:02, Richard Duivenvoorde a écrit :
> Hi,
>
> I've just been asked by some average QGIS user (unknown to SQL queries) how to create a simple filter like cityname='foo' for a vector layer.
>
> That was almost impossible for that person, unaware of SQL...
> We could not find any part of documentation for the SQL Query Builder dialog, and we also couldn't find the old (more user oriented) 'query builder' anymore (which does have documentation).

I'm not aware of any removal of this kind of info in the docs in the 
recent years.

 From the layer properties, Source tab, Query builder dialog (or 
ctrl+F), I can still access 
https://docs.qgis.org/testing/en/docs/user_manual/working_with_vector/vector_properties.html#query-builder. 
Is that one you were looking for? (OK, not really SQL but if the user 
accepts to first load the layer, this should address most of the cases).

There's also the SQL filter from DBManager 
(https://docs.qgis.org/testing/en/docs/user_manual/plugins/core_plugins/plugins_db_manager.html#working-with-the-sql-window) 
whose features, from my understanding, are meant to be brought to the 
Browser new SQL builder. Just not yet finished...

Regards,

Harrissou

>
> So my question is: while for SQL guru's and very advanced users the SQL Query Builder probably is a valuable feature, I think for average users the new builder is, well pretty hard/impossible ...
> Off course we do not have one target-user, but in general I think QGIS get's more and more functions, but also get's more and more complex to use.
>
> Would be great if we could still help the non-tech/average user. In this specific case maybe with a 'simple'-part of the dialog (which only accepts the where clause and where there is a 'test'-button like in the old dialog?
> OR at least you would end up with some documentation about the filter if you click the Help button on that dialog?
>
> I do understand that it is cool to have the SQL Query builder, but I fear that we are loosing some part of our user base if we ask them to be aware of SQL constructs, just to filter out some Features based on a field....
>
> Opinions?
>
> Regards,
>
> Richard Duivenvoorde
> _______________________________________________
> QGIS-Developer mailing list
> QGIS-Developer at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer