Hi sir jii,i have the scenario where when i click add row button in IG report all the existing rows should be cleared and only one row need to created by default .
Can u please suggest.
❇️ OrclQA.Com is a question and answer forum for programmers.
❇️ Here anyone can ask questions and anyone can answer to help others.
❇️ It hardly takes a minute to sign up and it is 100% FREE.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
OrclQA.Com is a question and answer forum for programmers.
Here anyone can ask questions and anyone can answer to help others.
It hardly takes a minute to sign up and it is 100% FREE.
Petar Simic
You can create a trigger that will delete data before you insert new row.
Petar Simic
In case you want to delete data immediately after the user clicks add row then you can try with:
Create Dynamic Action on click
Selection Type: JavaScript Expression
JavaScript Expression: $('*[data-action="selection-add-row"]');
Then create true action: Type: Execute Server-side Code:
add delete statement in PL/SQL Code attribute.
And add refresh action.
shashi
Hi thanks for your reply but i dont want to delete the data form table permanently just need to clear the rows when i click Add row button and generate only one row .
Petar Simic
Aha, I didn't understand you. Do you want to hide rows, when the user clicks on add row button?
shashi
yes ur right need to hide the rows when the user clicks and create one updatable row.