Hi I have a requirement for eg.
i have multi tab block one tab for dept and another is for EMP for eg.
when tab changed then the emp block will populate with data.
i set emp block property where clause is to execute where deptno=:parameter.deptno.
emp block shows multiple records in grid form for that deptno.
but i want to mask the null values with None
how to do in which trigger i can write.
i dont want to update the columns so i am using the non db items
and set synchronize property to db item name.
please advise thanks very much
right now the data is as below
deptno Empno ename startdate
10 101 test 2021-10-20
10 102 null null
10 103 null null
but i am looking the data to be
deptno Empno ename startdate
10 101 test 2021-10-20
10 102 None None
10 103 None None
thanks