[GIS] Turn off filter in QGIS Attribute Table

qgisqgis-3

My attribute table (as in the attached screenshot) shows that there is only 1 element and the rest of the 26 items is filtered out.
How can I turn off this filter?

Best Answer

There is the Query Filter which is defined directly on the layer. It is a global filter. It filters the data at the moment it enters QGIS and therefore applies to everything, including the attribute table.

https://docs.qgis.org/3.4/en/docs/user_manual/working_with_vector/query_builder.html

Related Solutions

[GIS] Filter expressions on attribute table

From what I understand, what you are looking for is:

"PROVNAME" IN ('CEBU', 'others', 'others')

This will work, but it might not be the best solution if you are trying to select a large number of areas.

Converting attribute table expression to filter expression using QGIS

As shown in my other solution, you can filter directly, without using SQL queries.

If, however, you still want to filter with SQL, proceed as follows:

Create a new field (virtual field if you want it to update dynamically) with Fild calculator and one of the expressions you provided. Call the field condition and use Boolean (true/false) as field type.
Filter with an SQL query like condition = true

Best Answer

Related Solutions

[GIS] Filter expressions on attribute table

Converting attribute table expression to filter expression using QGIS

Related Question