DEPRECATION WARNING

This documentation is not using the current rendering mechanism and is probably outdated. The extension maintainer should switch to the new system. Details on how to use the rendering mechanism can be found here.

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