Shared Interactive Report with filters in Oracle APEX

Create a Interactive Report with below query.

SELECT EMPNO,
       ENAME,
       JOB,
       MGR,
       HIREDATE,
       SAL,
       COMM,
       DEPTNO
  FROM EMP;

Modify alias name of Primary Report to PRIMARY.

1. Primary Report

https://apex.oracle.com/pls/apex/f?p=120487:2:16532414902526:IR_PRIMARY::::

2. Resets, and clears primary report settings : 

https://apex.oracle.com/pls/apex/f?p=120487:2:16532414902526:IR_PRIMARY::RIR,CIR::

3. Resets, and clears primary report settings. It additionally creates a ENAME = 'KING' filter on the primary report:

https://apex.oracle.com/pls/apex/f?p=120487:2:16532414902526:IR_PRIMARY::RIR,CIR:IR_EMPNO:7521
https://apex.oracle.com/pls/apex/f?p=120487:2:16532414902526:IR_PRIMARY::RIR,CIR:IR_ENAME:KING
https://apex.oracle.com/pls/apex/f?p=120487:2:16532414902526:IR_PRIMARY::RIR,CIR:IR_JOB:SALESMAN
https://apex.oracle.com/pls/apex/f?p=120487:2:16532414902526:IR_PRIMARY::RIR,CIR:IR_SAL:5000
https://apex.oracle.com/pls/apex/f?p=120487:2:16532414902526:IR_PRIMARY::RIR,CIR:IR_DEPTNO:30

Valid operators include:

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 a leading and trailing backslash, \)
IN = In (escape the comma separated values with a leading and trailing backslash, \)
ROWFILTER = Row Text Contains (this searches all columns displayed in the report with type STRING or NUMBER)

https://apex.oracle.com/pls/apex/f?p=120487:2:104896389797835:::RIR,CIR:IRIN_ENAME:\SMITH,KING\