mysql - selectRaw column not working on where condition with another column

Question

This my query :

$taskdetails = Tasks::join('company', 'company.id', '=', 'tasks.company_id')
    ->join('regulatory_grouping', 'regulatory_grouping.id', '=', 'tasks.regulatory_group_id')
    ->orderBy('tasks.created_at', 'DESC')
    ->select('company.client_name', 'company.deadline_priority', 'regulatory_grouping.name', 'tasks.*')
    ->selectRaw('DATE(tasks.due_date) as due_date')
    ->SelectRaw('DATE_ADD(?, INTERVAL company.deadline_priority DAY) as deadline_priority', [date('Y-m-d')])
    ->whereColumn('tasks.due_date', '>', 'company.deadline_priority')
    ->where('tasks.created_by_id', Auth()->user()->id)
    ->get();

Simply I am getting all results. The where condition whereColumn('tasks.due_date','>', 'company.deadline_priority') not filter the results

I tried below query too. But unknown column 'deadline'

$taskdetails = Tasks::join('company', 'company.id', '=', 'tasks.company_id')
    ->join('regulatory_grouping', 'regulatory_grouping.id', '=', 'tasks.regulatory_group_id')
    ->orderBy('tasks.created_at', 'DESC')
    ->select('company.client_name', 'company.deadline_priority', 'regulatory_grouping.name', 'tasks.*')
    ->selectRaw('DATE_ADD(?, INTERVAL company.deadline_priority DAY) as deadline', [date('Y-m-d')])
    ->whereRaw('due_date > deadline')
    ->where('tasks.created_by_id', Auth()->user()->id)
    ->get();

question from:https://stackoverflow.com/questions/66059123/selectraw-column-not-working-on-where-condition-with-another-column

Answer 1

Waitting for answers