{% extends 'base.html' %} {% block title %}Execute simple JOIN queries{% endblock %} {% block content %}
Photo.objects.filter(user__first_name=form.cleaned_data['first_name'], user__last_name=form.cleaned_data['last_name'])
Photo.objects.filter(popularity=2, user__first_name=form.cleaned_data['first_name'], user__last_name=form.cleaned_data['last_name'])
Photo.objects.filter(popularity=2, published__month=form.cleaned_data['month'], user__first_name___iexact=form.cleaned_data['first_name'], user__last_name___iexact=form.cleaned_data['last_name'])
Create new photo your own photo to test non-standard queries.
Corresponding post: Get SQL features on NoSQL with django-dbindexer.
{% endblock %}