如何修改PDF报表的SQL查询以返回全部actual_object_id值？

问题根源是查询中的rownum = 1条件——它强制只返回第一条匹配记录。要获取所有对应的actual_object_id，只需移除这个限制条件即可。如果担心存在重复值，可添加distinct关键字来去重。

修改后的SQL（去重版） #

select distinct t.actual_object_id
from JT_TASK_LIGHT_UIV t,
     JT_TASK_SALES_LINE_UIV s,
     SRV_REQUEST_SCOPE srs,
     SERVICE_INVOICE_UIV si,
     SERVICE_INVOICE_LINE_UIV sil
where sil.invoice_id = :invoice_id
  and sil.invoice_item_id = :item_id
  and t.task_seq = s.task_seq
  and s.Srv_Request_Scope_Id = srs.Srv_Request_Scope_Id
  and srs.REQ_Id = si.scope_ref
  and si.service_invoice_id = sil.service_invoice_id

修改后的SQL（无去重版，确认无重复时使用） #

select t.actual_object_id
from JT_TASK_LIGHT_UIV t,
     JT_TASK_SALES_LINE_UIV s,
     SRV_REQUEST_SCOPE srs,
     SERVICE_INVOICE_UIV si,
     SERVICE_INVOICE_LINE_UIV sil
where sil.invoice_id = :invoice_id
  and sil.invoice_item_id = :item_id
  and t.task_seq = s.task_seq
  and s.Srv_Request_Scope_Id = srs.Srv_Request_Scope_Id
  and srs.REQ_Id = si.scope_ref
  and si.service_invoice_id = sil.service_invoice_id

内容的提问来源于stack exchange，提问作者Marcotejada