Oracle 'invalid identifier' and SQL select structure

[Anthony Hawkes]

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')