放下Apex表单的源问题

发布于 2025-01-31 17:53:56 字数 446 浏览 3 评论 0原文

我创建了一个表格，以用作表单下拉菜单的来源。目标是只有根据所有者是谁可以为部门代码提供哪些可能的选项。我让报废所有者正确显示，但不幸的是，我无法出现部门代码。没有选项可以弹出。这就是我的代码的样子：

    Select DEPT_CODE, DEPT_CODE as Value From Degrade_Robots
    WHERE SO_NAME = :P7_SCRAP_OWNER

    group by DEPT_CODE

    order by DEPT_CODE

我的表格设置为：

原文

I have a table I created to use as the source for the of dropdowns of a form. The goal is to have only what possible options are available for the Department code based on who the owner is. I got the scrap owner to display correctly but unfortunately I have not been able for the department code to show up. No options are able to pop up. This is what my code looks like:

    Select DEPT_CODE, DEPT_CODE as Value From Degrade_Robots
    WHERE SO_NAME = :P7_SCRAP_OWNER

    group by DEPT_CODE

    order by DEPT_CODE

My table is set up like:

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

淡水深流 2025-02-07 17:53:56

您什么都没有汇总；不要使用的组，但<代码>不同的。

select distinct
       dept_code as display_value,
       dept_code as return_value
from degrade_robots
where so_name = :P7_SCRAP_OWNER
order by dept_code;

由于您在列表中没有看到任何内容，所以我认为这是因为您忘记了提及p7_scrap_owner select List的Lov's Lov parent parent item 属性。

You aren't aggregating anything; don't use group by but distinct.

select distinct
       dept_code as display_value,
       dept_code as return_value
from degrade_robots
where so_name = :P7_SCRAP_OWNER
order by dept_code;

As you don't see anything in the list, I presume that's because you forgot to mention P7_SCRAP_OWNER item in Select List's LoV Parent Item(s) property.