好啊当我重新打开
ticket here
Django开发者(Simon Charette)给了一个指针,结果是我的
get_queryset
是罪魁祸首。
错误的查询是
ResourceMgmt.objects.filter(is_active='Y')\
.filter(schedule_next_run_time__lt=future)\ # future is calculated date
.filter(schedule_end_time__gt=now + datetime.timedelta(minutes=1))\
.extra(where=["schedule_next_run_time > sysdate - (schedule_frequency/1440)",
"owner_id IN ( \
select id from cpe_user \
where is_active='Y' \
connect by prior id = parent_id start with id = % s)"], 154)
固定查询为
ResourceMgmt.objects.filter(is_active='Y')\
.filter(schedule_next_run_time__lt=future)\ # future is calculated date
.filter(schedule_end_time__gt=now + datetime.timedelta(minutes=1))\
.extra(where=["schedule_next_run_time > sysdate - (schedule_frequency/1440)",
"cpe_resource_mgmt.owner_id IN ( \ ### look at this line.
select id from cpe_user \
where is_active='Y' \
connect by prior id = parent_id start with id = % s)"], 154)
正如Oracle error所说,
column ambiguously defined
,它实际上意味着
owner_id
在里面
extra
条款