来自APEX页面项的查询值

Question

我正在查询两个表，以便根据第一页上选定的行以表格形式在第二页上显示值(第二页上的数据是可编辑的，与第一页上的列相关)。我在第二页上创建了一个隐藏项来保存第一页中的唯一标识符。但是，在查询结束时，我很难让值在"where“子句中工作。如何在Oracle APEX中查询页项值？

select g.GROUP_ID as GROUP_ID,
c.COMPONENT as COMPONENT,
c.DESCRIPTION as DESCRIPTION,
c.MANUFACTURER as MANUFACTURER,
c.MODEL as MODEL,
c.VALIDATED as VALIDATED,
'' as updated_group_id,
g.OBJECT_TYPE as OBJECT_TYPE,
g.Q_LEVEL as QUALITY_CLASS,
g.ASME as ASME 
from tbl_group g
left join tbl_component c on c.group_id = g.group_id
where g.group_id = p2_x

P2_X是我隐藏的页面项，group_id是从第一页传递的唯一标识符，它们都是从同一个表中提取的。

Answer 1

只需添加一个冒号：

where g.group_id = :p2_x