I have a query where the possibility for belongs can be a set of values or it can be empty.
In case the set is empty I want the query to act as 1=1 and not 1=0, so all values would be selected.
selected = list(selected_values_str.split(","))
selected_int = tuple([int(i) for i in selected])
rows = db((db.counters.c_date >= datum_od) &
(db.counters.c_user_inserted.belongs(selected_int)) &
(db.counters.c_date <= datum_do) &
(db.machines.m_status != 100)).select(#db.counters.c_machine_id,
db.counters.c_total,
db.counters.c_black,
db.counters.c_color,
db.counters.c_level1,
db.counters.c_level2,
db.counters.c_level3,
db.counters.c_a3_color,
db.counters.c_date,
db.counters.c_datetime,
db.counters.c_datetime_dataread,
db.counters.c_scans,
db.counters.c_note,
db.machines.m_code,
db.auth_user.first_name,
db.auth_user.last_name,
db.auth_user.email,
).as_list()