背景

从其他页跳转的 具有交互式报表的页面，想查询交互式报表的某列 包含某个值,并且每次都要刷掉前一次的查询条件

操作

IR

_<report_alias> 例如: IR

_dept20

IR

_ 例如: IR[EMP]C_ENAME:KING

C = Contains ¹ EQ = Equals (this is the default)
GTE = Greater than or equal to
GT = Greater Than
LIKE = SQL Like operator
LT = Less than
LTE = Less than or equal to
N = Null
NC = Not Contains
NEQ = Not Equals
NLIKE = Not Like
NN = Not Null
NIN = Not In (escape the comma separated values with backslash, )
IN = In (escape the comma separated values with backslash, )
ROWFILTER = Row Text Contains (this searches all columns displayed in the report with type STRING or NUMBER)

可以利用清楚缓存,文档见下

1
2
3
4
5

- `RIR` - Resets an interactive report. This is equivalent to the end user choosing the Reset option from the interactive report Actions menu on the target page. The report is returned to the default report settings specified by the developer or saved by the user.
    
- `CIR` - Clears interactive report. This clears all of the report settings such as control break, aggregate, flashback, chart, number of rows to display, filter, highlight, computation, group by, and pivot.
    
- `RP` - Resets interactive report pagination.

问题

这是一个脚注 。