Tutorials References Exercises Videos Menu
Create Website Get Certified Upgrade

Field Lookups - gt (greater than)


Example

Get all records where id is larger than 3:

mydata = Member.objects.filter(id__gt=3).values()
Run Example »

Definition and Usage

The gt lookup is used to get records that are larger than a specified value.

For a greater than or equal to search, use the gte lookup.


SQL Equivalent

The SQL equivalent to the example above will be:

WHERE id > 3;

Syntax

All Field lookup keywords must be specified with the fieldname, followed by two(!) underscore characters __ and the keyword:

fieldname__gt=value