Hi Sir,
I have created a lov with Approve All,Reject All.
If i select approve all then all the status field should be approved vice versa dynamically
Share
Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
Create a dynamic action on the status LOV for the change event to execute PL/SQL code.
Then add the following PL/SQL code in it:
if :px_status_lov = 'APPROVE ALL' then Update table1 set status = 'APPROVED' Where yourconditionColumn = :px_column; Delete from table1 where yourconditionColumn = :px_column; elsif :px_status_lov = 'REJECT ALL' then Update table1 set status = 'REJECTED' Where yourconditionColumn = :px_column; End if;Then create one more True action to refresh the report region below.
Sir its not changing
What is the return value of the LOV list P3_STATUSALL? I have given the example of APPROVE ALL in capital letters. You need to specify the only value you have defined for the return value.
In items to submit, why P3_STATUSM? You should specify only P3_STATUSALL and P3_PID.
Return Value of P3_STATUSALL is Approve All & Reject All
when i click on approve all then P3_STATUSM value should be approved (and P3_STATUSM is also a lov containing Approved and Rejected
Its not firing where i m doing mistake plz let me know
If the return value of P3_STATUSALL is Approve All then you should change the if condition accordingly. Below is the code:
if :px_status_lov = 'Approve All' then Update table1 set status = 'APPROVED' Where yourconditionColumn = :px_column; Delete from table1 where yourconditionColumn = :px_column; apex_util.set_session_state('P3_STATUSM', 'Approved'); elsif :px_status_lov = 'Reject All' then Update table1 set status = 'REJECTED' Where yourconditionColumn = :px_column; apex_util.set_session_state('P3_STATUSM', 'Rejected'); end if;Items to submit: P3_STATUSALL,P3_PID
Items to return: P3_STATUSM
Same as previous not firing
What event did you choose for the DA for P3_STATUSALL?
Is the report region is being refreshed after selecting the value from P3_STATUSALL?
Yes Refresh->Region
Is it refreshing the report?
yes it is and am not getting P3_Statusm Valued as Approved in front end but in db it is getting stored
It means the dynamic action on the list change event is firing. Because it refreshes the page.
So you have to check the values returned by the STATUSM and STATUSALL lists. Also, check and update and delete statement if you specified the correct condition.
if :p3_statusall = ‘Approve All’ then
Update times
set statusm = case when statusm is null then ‘APPROVED’ else statusm end;
set statust = case when statust is null then ‘APPROVED’ else statust end;
Where pid = :p3_pid;
apex_util.set_session_state(‘P3_STATUSM’, ‘Approved’);
elsif :p3_statusall = ‘Reject All’ then
Update times
set statusm = case when statusm is null then ‘REJECTED’ else statusm end;
set statust = case when statust is null then ‘REJECTED’ else statust end;
Where pid = :p3_pid;
apex_util.set_session_state(‘P3_STATUSM’, ‘Rejected’);
end if;
i have multiple fileds to be set approve i.e., 5 days a week(statusm,statust,statusw …) will this plsql work
When i am trying to do multiple row update i am getting folowing error
Delete the True action to Refresh the region. Instead, create another True action to execute JavaScript code and add the following code in it:
Thanx so much sir for your kind support