I wrote a union function in the middle of union wrote a json object is one of the parameter, but throwing error : could not identify an equality operator for type json. Here is my code. select(SELECT array_to_json(array_agg(row_to_json(resdt))) FROM (select vt.task_id,vp.project_name,vp.status as project_status, vt.project_id,vt.task_description,vt.planned_start_date,vt.planned_end_date, (select array_to_json(array_agg(row_to_json(b))) FROM (select vl.* from public."VOfficeApp_task" vat inner join public."VOfficeApp_task_labels" vtl on vat.task_id = vtl.task_id inner join public."VOfficeApp_labels" vl on vl.label_id = vtl.label_id where vl.status = true and vat.task_id = vt.task_id )b)as label_name, (select array_to_json(array_agg(row_to_json(b))) FROM (select tr.task_resource_id,tr.task_id,tr.project_resource_id , tr.assigned_date,tr.assigned_by,pr.employee_id as id, concat(u.first_name,u.last_name) as employeename from public."VOfficeApp_task" vtr inner join public."VOfficeApp_project_resources" pr on pr.project_id = vtr.project_id inner join public."VOfficeApp_task_resource" tr on tr.project_resource_id = pr.project_resource_id and tr.task_id = vt.task_id inner join public."VOfficeApp_user" u on u.id =pr.employee_id where tr.released_date is null and vtr.task_id =vt.task_id and vtr.status != 'Delete')b)as user_name, (select count(task_id)from public."VOfficeApp_task" ptra where ptra.task_id = vt.task_id and status = 'Assigned')Active_count, from public."VOfficeApp_task" vt inner join public."VOfficeApp_projects" vp on vt.project_id = vp.project_id inner join public."VOfficeApp_task_resource" vtr on vt.task_id = vtr.task_id inner join public."VOfficeApp_project_resources" vpr on vtr.project_resource_id = vpr.project_resource_id left join public."VOfficeApp_conversation" cvv on cvv.projtaskid = vt.task_id where vp.company_id = companyid and vp.created_by = createdby and vt.status != 'Delete' --order by vt.task_id desc union select vt.task_id,vp.project_name,vp.status as project_status, vt.project_id,vt.task_description,vt.planned_start_date,vt.planned_end_date, (select array_to_json(array_agg(row_to_json(b))) FROM (select vl.* from public."VOfficeApp_task" vat inner join public."VOfficeApp_task_labels" vtl on vat.task_id = vtl.task_id inner join public."VOfficeApp_labels" vl on vl.label_id = vtl.label_id where vl.status = true and vat.task_id = vt.task_id )b)as label_name, (select array_to_json(array_agg(row_to_json(b))) FROM (select tr.task_resource_id,tr.task_id,tr.project_resource_id , tr.assigned_date,tr.assigned_by,pr.employee_id as id, concat(u.first_name,u.last_name) as employeename from public."VOfficeApp_task" vtr inner join public."VOfficeApp_project_resources" pr on pr.project_id = vtr.project_id inner join public."VOfficeApp_task_resource" tr on tr.project_resource_id = pr.project_resource_id and tr.task_id = vt.task_id inner join public."VOfficeApp_user" u on u.id =pr.employee_id where tr.released_date is null and vtr.task_id =vt.task_id and vtr.status != 'Delete')b)as user_name, from public."VOfficeApp_task" vt inner join public."VOfficeApp_projects" vp on vt.project_id = vp.project_id inner join public."VOfficeApp_task_resource" vtr on vt.task_id = vtr.task_id inner join public."VOfficeApp_project_resources" vpr on vtr.project_resource_id = vpr.project_resource_id --inner join public."VOfficeApp_user" u on u.id =vpr.employee_id where vp.company_id = companyid and vpr.employee_id = createdby and vt.status != 'Delete' --order by vt.task_id desc )resdt)as My_tasks;
Speedy emails, satisfied customers
Are delayed transactional emails costing you user satisfaction? Postmark delivers your emails almost instantly, keeping your customers happy and connected.
For further actions, you may consider blocking this person and/or reporting abuse
Top comments (0)