[web2py] need help with query

Somehow my replies all got deleted. I want one item per group(the newest) and then filter by id_status and count how many groups have that certain id_status. This should be possible i think. I had a nice example in one of those deleted post, but i don't know how i can get that back. -- Resou

[web2py] need help with query

Hi, I have the following table: db.define_table("track_trace", Field("id_reparaties", "reference reparaties", requires=[IS_IN_DB(db, 'reparaties.id')]), Field("id_status", "reference status"), Field("opmerking", "string", default=""),

[web2py] Need help with query

I have a list, x, with allowed values for field table.x. Is there a succinct way to do something like this? db(db.table.x in x).select()