I suspect that you need some extra () in there to correctly group your
AND and OR.
Maybe try the below version
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)
add the following to your code to see what SQL is actually being sent
to your database which should help you find the problem:
print db['_lastsql']
~Brian
On Dec 8, 1:28 pm, Richard Vézina <[email protected]> wrote:
> 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
