Application Express 中的报表有多个链接列吗?
是否可以在交互式报告中创建额外的链接列?我的意思是,我有一个用户表,但我想要两个链接列,其中一个将打开一个允许我编辑的页面,另一个链接将仅打开详细信息。
我该如何设置?
Is it possible to create additional Link Columns in an interactive report? I mean, I have a table of users, but I want to have two link columns, one of which would open a page that lets me edit, and another link to just open the details.
How can I set this up?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
创建交互式报表时,您可以在指定查询的 sql 时提供第一个链接,这是指向 IR 的单行视图的链接。
标准,您从 IR 上的这一列开始,您可以在“报告属性”>“报告属性”中找到此链接列的详细信息。链接栏。请注意,只有在这里您才能选择“链接到单行视图”选项。
如果您想要额外的链接列,则必须编辑您的查询(编辑报告)。例如:
这样,我为报告生成 2 个额外列,其值始终为 null(但是,这不是必需的!您也可以选择“ename link_column1”作为额外列 - 方便用作链接文本) 。
要将这些列转换为链接列(或实际上任何其他列!),您必须转到列编辑页面:通过报告属性,然后单击列旁边的编辑链接,或者在树视图中右键单击列并选择编辑。
在编辑页面上,向下滚动到“列链接”部分。在这里您可以再次设置到另一个页面的链接。
完成后,您可以验证报告属性中的链接列。
最后,不要忘记将列添加到交互式报告中!由于您很可能随后添加这些列,因此您需要进入操作菜单,选择选择列,然后添加额外的列。如果您希望将其作为默认视图,请不要忘记另存为主要视图。
When you create an Interactive Report, you can provide the first link when you specify the sql for the query, this is the link to the single row view of the IR.
Standard, you start with this one column on the IR, and you can find the details of this link column in the Report Attributes > Link Column. Note that only here you can select the option 'Link to Single Row View'.
If you want extra link columns, you will have to edit your query (edit report). For example:
This way, i generate 2 extra columns for the report, whose value is always null (however, this is not a requirement! You could just aswell select 'ename link_column1' as an extra column - handy to use as link text).
To turn these columns into link columns (or any other column actually!), you have to go to the column edit page: either via the report attributes, and clicking the edit link next to the column, or in the tree view by rightclicking on the column and choosing edit.
On the edit page, scroll down to the Column Link section. Here you can set up the link to another page once more.
Once done, you can verify the link columns in your reports attributes.
Finally, don't forget to add the columns to your interactive report! Since you most likely add these afterward, you need to go the actions menu, choose select columns, and add the extra columns. Don't forget to save as primary if you mean this to be your default view.