-- Set the no r = Variable what you want.
SELECT *
FROM (SELECT ENAME, SALARY, DENSE_RANK () OVER (ORDER BY SALARY DESC) R
FROM EMP)
WHERE R = :Variable
-- Set the no r = Variable what you want.
SELECT *
FROM (SELECT ENAME, SALARY, DENSE_RANK () OVER (ORDER BY SALARY DESC) R
FROM EMP)
WHERE R = :Variable
Create dynamic action
when
Selection grid interactive grid
grid name
var i, selectedIds = "",
model = this.data.model;
for ( i = 0; i < this.data.selectedRecords.length; i++ ) {
selectedIds += model.getValue( this.data.selectedRecords[i], "GROUP_CODE") ;//+ ","; here group_code is value item change as your required column name
}
$s("P55_GRP_CODE", selectedIds);//here P55_GRP_CODE IS Affected item replace as your required item name
1️⃣ Enable Insert in the Interactive Grid IG → Attributes Edit → Allowed Add Row → Yes 2️⃣ Add a New Column (Icon column) Column...