"ORDER BY NOT ALLOWED IN SUBQUERIES OF COMPOUND STATEMENTS" in Django while using UNION function

I'm new to Django and want to use this code:

if "dashboard_filters_parent_checkbox" not in request.POST:
   all_task_id=tasks_no_assign.union(tasks_no_start).union(tasks_start).union(tasks_no_confirmed).union(   tasks_confirmed).values_list('id',flat=True)
   all_task_parent_id=tasks_no_assign.union(tasks_no_start).union(tasks_start).union(tasks_no_confirmed).union(tasks_confirmed).values_list('task_parent__id',flat=True) #.union(sub_tasks_no_confirmed)
   all_task_parent_id = list(set(all_task_id) & set(all_task_parent_id))
   tasks_no_assign=tasks_no_assign.exclude(Q(pk__in=all_task_parent_id)&~Q(pk__in=all_tasks_children_id))
   tasks_no_start=tasks_no_start.exclude(Q(pk__in=all_task_parent_id)&~Q(pk__in=all_tasks_children_id))
   tasks_start=tasks_start.exclude(Q(pk__in=all_task_parent_id)&~Q(pk__in=all_tasks_children_id))
   tasks_no_confirmed=tasks_no_confirmed.exclude(Q(pk__in=all_task_parent_id)&~Q(pk__in=all_tasks_children_id))
   tasks_confirmed=tasks_confirmed.exclude(Q(pk__in=all_task_parent_id)&~Q(pk__in=all_tasks_children_id))

but I get this error:

ORDER BY NOT ALLOWED IN SUBQUERIES OF COMPOUND STATEMENTS

I now this error shown for using Union function but where is problem? how can I do and what is correct way?

thanks in advance <3

Back to Top