Where Clause

[joshblevins]

I am trying to put a where clause on a dbjoin element. I only want to display data from a specific user group this is the clause I am using

where 'usergroup' = 10

I have users with this group number but no data is returned in the drop down using the above clause.

I got this from this wiki http://fabrikar.com/wiki/index.php/Database_join