-- SELECT expression added to both the list and echo queries of existing pickers.
-- z is the existing main-document resource alias. No user input is interpolated.
(SELECT COALESCE(jsonb_agg(jsonb_build_object(
  'kanwu_zixiang_id', kd.f_id,
  'kanwu_shenqing_id', ka.f_id,
  'wenjian_id', ka.wenjian_id,
  'banben_id', ka.banben_id,
  'wenjian_bianhao', ka.wenjian_bianhao,
  'wenjian_mingcheng', ka.wenjian_mingcheng,
  'banbenhao', ka.banbenhao,
  'kanwu_weizhi', kd.kanwu_weizhi,
  'kanwu_neirong', kd.kanwu_neirong,
  'xiugai_jianyi', kd.xiugai_jianyi,
  'kanwu_yuanyin', kd.kanwu_yuanyin,
  'fujian', COALESCE(NULLIF(kd.fujian, '')::jsonb, '[]'::jsonb),
  'shifou_yichuli', COALESCE(NULLIF(kd.shifou_yichuli, ''), 'no')
) ORDER BY ka.shenqing_riqi, ka.f_id, kd.f_id), '[]'::jsonb)::text
 FROM dms_wenjian_kanwu_shenqing ka
 JOIN dms_wenjian_kanwu_shenqing_zixiang kd
   ON kd.f_foreign_id = ka.f_id AND kd.f_tenant_id = ka.f_tenant_id
 WHERE ka.f_tenant_id = z.f_tenant_id
   AND ka.f_flow_state = 2
   AND ka.f_delete_mark IS NULL AND kd.f_delete_mark IS NULL
   AND ka.wenjian_id = z.f_id
) AS kanwu_mingxi