英文:
Oracle APEX (Foreign Key) Column Not Showing in Interactive Report
问题
以下是交互报告中我的表格中的列：
所选列，WORD_ID，在我的交互式报告中没有显示出来；它也是表格的外键。（我试图将其设为链接，因为那是我最终想做的，但即使只是纯文本，该列也没有显示出来。）
在实际报告中：
似乎根本没有WORD_ID列。
可能的问题是什么？
英文:
These are the columns in my table for the interactive report:
The selected column, WORD_ID, is the column that is not showing in my interactive report; it is also a foreign key to the table. (I tried to make it a link because that is what I ultimately want to do, but the column wasn't showing up even when it was just plain text.)
In the actual report:
There doesn't appear to be a WORD_ID column at all.
What might be the issue here?
答案1
得分: 1
你在“选择列”屏幕中看到的是用户看到的内容：那些是列标签。在第一个屏幕截图中 - 来自构建器的那个，您可以看到查询/表格中的实际列名称或别名。构建器中的报告有5列显示和2列隐藏。 “选择列”屏幕上也有5列（1列隐藏，4列显示），所以一切看起来都正常。我猜测列“WORD_ID”的标签是“Word”。显示报告中的所有列并验证标签。
英文:
What you see in the "Select Columns" screen is what users see: those are the column labels. In the first screenshot - the one from the builder, you see the actual column names or aliases from the query/table. The report in the builder has 5 columns to show and 2 hidden ones. The "Select Columns" screen also has 5 columns (1 hidden, 4 displayed), so all looks fine. My guess is that the column "WORD_ID" has label "Word". Show all columns in the report and verify the labels.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论