title: Django: Filtering query with foreign key not working
body: <p>I want to filter a query with a foreign key, but it doesn't seem to want to recognize it. <code>status</code> can either be <strong><code>'open'</code></strong> or <strong><code>'closed'</code></strong>.</p>
  
  <p><strong>models.py</strong></p>
  
  <pre><code>class Status(models.Model):
      status = models.CharField(primary_key=True, max_length=100)
  
  class Incident(models.Model):
      incident_date_reported = models.DateField('Date Reported', default=timezone.now)
      status = models.ForeignKey(Status, default="open")
  </code></pre>
  
  <p><strong>views.py</strong></p>
  
  <pre><code>def index(request):
  
      template = "index.html"                 
      form = IncidentSearchForm(request.GET)
  
      if request.method == 'GET':
  
          form = IncidentSearchForm()
  
          ############## MY QUERY THAT DOESN'T LIKE THE FOREIGN KEY #############
          incident_list = Incident.objects.filter(status = 'open').order_by('-incident_date_reported')
          #######################################################################
  
         context = {  "form": form,
                      "incident_list": incident_list
                    }
  
          return render(request, template, context)
  </code></pre>