Hello, At the DB level this request return results...
SELECT id FROM table1 WHERE verified IS NULL and data_grade = 'grade1' and valid IS NOT FALSE or verified IS FALSE and data_grade = 'grade1' and valid IS NOT FALSE In web2py with equivalent : db((db['table1'].verified == None) & (db['table1'].data_grade == 'grade1') & (db['table1'].valid != False) | (db['table1'].verified == False) & (db['table1'].data_grade == 'grade1') & (db['table1'].valid != False)).select(db['table1'].id) Get nothing!! Do I have a syntaxe error or what? Thanks Richard
