| | |
|---|
| | | select |
|---|
| | | obj.id, |
|---|
| | | obj.title, |
|---|
| | | obj.objection_type, |
|---|
| | | obj.objection_status, |
|---|
| | | obj.create_dept, |
|---|
| | | obj.catalog_resource_name, |
|---|
| | | obj.submitter, |
|---|
| | | obj.submitter_contact, |
|---|
| | | obj.handle_unit, |
|---|
| | | obj.objection_desc, |
|---|
| | | obj.objection_basis, |
|---|
| | | obj.other_objection_detail, |
|---|
| | | obj.review_opinion, |
|---|
| | | obj.area_code, |
|---|
| | | obj.apply_target_dept_id, |
|---|
| | | obj.create_user, |
|---|
| | | obj.create_dept, |
|---|
| | | obj.create_time, |
|---|
| | | /* 必须显式查询排序字段，否则某些情况下分页插件生成的 COUNT 会报错 */ |
|---|
| | | obj.update_user, |
|---|
| | | obj.update_time, |
|---|
| | | obj.status, |
|---|
| | | obj.is_deleted, |
|---|
| | | string_agg(da.attach_name::text, ',') as attach_names, |
|---|
| | | bd.dept_name as create_dept_name |
|---|
