I'm having trouble with django 1.6 running queries on a table I need to pull data from
When I run the following from shell CRMData.objects.filter(Incident_Date='2014-01-14') I get: DatabaseError: ORA-00904: "ODBC_EXTRACT_DAILY"."INCIDENT_DATE": invalid identifier I've run queries in sqlplus and the following works select * from odbc_extract_daily where incident_date='2014-01-14'; But the following doesn't select * from odbc_extract_daily where odbc_extract_daily.incident_date= '2014-01-14'; And returns the same DatabaseError: ORA-00904: "ODBC_EXTRACT_DAILY"."INCIDENT_DATE": invalid identifier I've had a look at core.py but can't for the life of me figure out how to change this behaviour - it's partially fatigue but it's making me pull my hair out!!! Please halp!! DatabaseError: ORA-00904: "ODBC_EXTRACT_DAILY"."INCIDENT_DATE": invalid identifier DatabaseError: ORA-00904: "ODBC_EXTRACT_DAILY"."INCIDENT_DATE": invalid identifier CRMData.objects.filter(Incident_Date='2014-01-14')CRMData.objects.filter(Incident_Date='2014-01-14') CRMData.objects.filter(Incident_Date='2014-01-14') CRMData.objects.filter(Incident_Date='2014-01-14') CRMData.objects.filter(Incident_Date='2014-01-14') -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com. To post to this group, send email to django-users@googlegroups.com. Visit this group at http://groups.google.com/group/django-users. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/aef7df54-89a4-49f0-aee8-3ff994677d9f%40googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.