交互式网格列显示全部内容，但只读

本文介绍了交互式网格列显示全部内容，但只读的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

环境:Oracle APEX v5.1.2/Oracle 12c

Environment: Oracle APEX v5.1.2 / Oracle 12c

我有一个交互式网格报表，在该报表中，我有一个仅显示列的字段，但实际上返回的错误消息描述可能很长.由于我想将IG报告保持为每行一条记录，是否有一种方法可以显示此字段的全部内容，而又不允许更改数据库中的基础列值?

I have an interactive grid report by where I have one field that is a display only column but it actually returns an error message description that could be quite long. Since I would like to keep my IG report to one record per row, is there a means of being able to display the full contents of this field without allowing changes to the underlying column value in the database?

通过某种方式提供的工具提示或能够深入到该字段中以查看所有信息(只读)的

Some means of a tool tip or being able to drill into the field to view all info but read only.

推荐答案

在select语句中使用该列两次，

Use that column 2 times in the select statemente,

• 1，其中substr显示在行中
• 2完成后，您将在悬停时显示它(这是一个隐藏的列)

对于Interactive Grid，请转到列>标识>类型> HTML表达式.

For Interactive Grid, go to column > Identification > Type > HTML Expression.

然后在设置">"HTML表达式"下添加:<span title="&COLUMN2.">&COLUMN1.</span>

Then under Settings> HTML Expression add: <span title="&COLUMN2.">&COLUMN1.</span>

当您将鼠标悬停在字段上时，它将显示所有内容.

It will show everything when you hover the field.