如何在Oracle APEX的报表的每一行中添加编辑按钮? [英] How do you add an edit button to each row in a report in Oracle APEX?
问题描述
我正在使用Oracle APEX，并且在页面中有一个报告区域，该区域显示来自SQL查询的列.我想在此报告的第一列中添加编辑按钮，以便用户可以单击它并编辑/查看其中一个结果.如何添加此编辑按钮?谢谢.
I'm using Oracle APEX and I have a report region in a page that displays columns from a SQL query. I want to add edit buttons to the first column of this report so that the user can click on it and edit/review one of the results. How do I add this edit button? Thanks.
推荐答案
-
像这样在报表的SELECT语句中添加一列:
Add a column to the SELECT statement of the report like this:
SELECT '' edit_link, -- This is the new column
...
转到报告属性"标签.
Go to the Report Attributes tab.
将新列EDIT_LINK移到列列表的顶部(如果您想成为第一列).
Move the new column EDIT_LINK to the top of the list of columns (if you want it to be first).
单击EDIT_LINK别名左侧的铅笔和纸图标以打开列属性"页面.
Click on the pencil and paper icon to the left of the EDIT_LINK alias to open the Column Attributes page.
转到列属性"页面的列链接"部分.
Go to the Column Link section of the Column Attributes page.
选择一个显示为[Icon 1]，[Icon 2]，...的图标(或者，您可以使用自己的一个，但是更高级).
Pick one of the icons shown as [Icon 1], [Icon 2], ... (alternatively you can use one of your own but that is more advanced).
填写其余的链接"字段，以指定按下链接时要转到应用程序的哪一页以及要传递的值.提供了值列表以帮助解决此问题.例如，您可以指定:
Fill out the remaining Link fields to specify which page of your application you want to go to when the link is pressed and what values you will be passing in. Lists of values are supplied to help with this. For example, you might specify:
- 页数:42
- 第1项名称:P42_EMPNO
-
第1项值:#EMPNO#
- Page: 42
- Item 1 Name: P42_EMPNO
Item 1 Value: #EMPNO#
(这将导航到第42页，将页面项P42_EMPNO设置为当前报告行中的EMPNO值.)
(This would navigate to page 42, setting page item P42_EMPNO to the value of EMPNO in the current report row.)
按应用更改"按钮.
现在运行页面，您将在每一行都有一个编辑链接.
Now run the page and you will have an edit link for each row.
这篇关于如何在Oracle APEX的报表的每一行中添加编辑按钮?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
