Hey, Dev!
Are you looking for a forum full of active developers to help you?
So if you want to:
➡️ Get answers for your development issues
➡️ Help others
➡️ Write an article
➡️ Get rewarded for your active participation
Then you are going to love this place.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Showing information on IR Region
Swarup
thnx for you support how to get data from db in place of hello eg:Total Hours: (it is calculating dynamically )
thnx for you support how to get data from db in place of hello
eg:Total Hours: (it is calculating dynamically )
See lessInserting App user into the data table in Oracle apex
Swarup
Sir if manager login to approve the tasks for different member then in the app_user will get manager name but i want to get the name of the person who have entered the data Eg: If RAM has entered the data then the manager can view that the ram has entered it in the user field. if Shyam has entered tRead more
Sir if manager login to approve the tasks for different member then in the app_user will get manager name but i want to get the name of the person who have entered the data
Eg:
If RAM has entered the data then the manager can view that the ram has entered it in the user field.
if Shyam has entered the data then the manager can view that the Shyam has entered it in the user field.
See lessShowing information on IR Region
Swarup
Can it be possible to design this
Can it be possible to design this
See lessInserting App user into the data table in Oracle apex
Swarup
Thnx sir it works
Thnx sir it works
See lessApprove all dynamically in oracle apex
Swarup
Thanx so much sir for your kind support
Thanx so much sir for your kind support
See lessApprove all dynamically in oracle apex
Swarup
When i am trying to do multiple row update i am getting folowing error
When i am trying to do multiple row update i am getting folowing error

See lessApprove all dynamically in oracle apex
Swarup
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 = 'ReRead more
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
See lessApprove all dynamically in oracle apex
Swarup
yes it is and am not getting P3_Statusm Valued as Approved in front end but in db it is getting stored
yes it is and am not getting P3_Statusm Valued as Approved in front end but in db it is getting stored
See lessApprove all dynamically in oracle apex
Swarup
Yes Refresh->Region
Yes Refresh->Region
See lessApprove all dynamically in oracle apex
Swarup
Same as previous not firing apex_util.set_session_state('P3_STATUSM', 'Approved'); this is not working but the status field is changing
Same as previous not firing