Customize the list view

If you like, you can customize which objects should be visible in the list view. For hand-crafted lists, the plugin provides a field “Static SQL filter” which you can use to limit the list view if you know some SQL.

Some examples:

filter

filter

SQL

SQL

filter

only objects that are for renting

SQL

object_type = 0

filter

only objects that are for sale

SQL

object_type = 1

filter

only objects near Berlin (if you use German ZIP codes)

SQL

zip LIKE "10%"

filter

with at least 5 rooms

SQL

number_of_rooms >= 5

filter

with a living area of less than 50 m²

SQL

(living_area != 0 AND living_area < 50)

filter

only objects that are already rented

SQL

rented = 1