But when you add filter to check which pages are against of admin and you give access custom menu page access to admin so only custom menu button shows but his sub menu not shows?
Hi, thank you for shared this video with us! It is so helpful. The query used in the List Query page SELECT level, name label, 'f?p=&APP_ID.:'||TAG||':'||:APP_SESSION||':::::' target, 'NO' as is_current, icon as image from CUSTOM_MENU WHERE ID IN ( select A.MENU FROM USER_ACCESS A WHERE USERNAME=:APP_USER) start with PID IS NULL CONNECT BY PRIOR ID=PID order siblings by ID ;
hi sir thank you for your video and I have a question why you add admin user three times ? how to bring the menu and its submenu when give the user main menu how to bring sub menu to this user also ?
Assalam o Aalikum!. Sir Thanks Alot. But 1 Question? Sir i allow to user only form but whene i press create button then page redirect on report. i do not want to go user report side. what can i do for fix it?
Hi sir your work is unique. Can u give a tip how to create approval hierarchy? If an employee submit a request then based on request type (leave or Loan) it should be redirected to either HR or Finance department
But when you add filter to check which pages are against of admin and you give access custom menu page access to admin so only custom menu button shows but his sub menu not shows?
Hi, thank you for shared this video with us! It is so helpful.
The query used in the List Query page
SELECT level,
name label,
'f?p=&APP_ID.:'||TAG||':'||:APP_SESSION||':::::' target,
'NO' as is_current,
icon as image
from CUSTOM_MENU
WHERE ID IN ( select A.MENU FROM USER_ACCESS A WHERE USERNAME=:APP_USER)
start with PID IS NULL
CONNECT BY PRIOR ID=PID
order siblings by ID
;
hi sir thank you for your video and I have a question why you add admin user three times ? how to bring the menu and its submenu when give the user main menu how to bring sub menu to this user also ?
আরেকটি সুন্দর ভিডিওর জন্য আপনাকে ধন্যবাদ।
একটি প্রশ্ন ,Apex এ কি Trigger use করা যায়? হলে এর উপর একটি ভিডিও হলে ভালো হয়।
হ্যা যায়। চেষ্টা করব ট্রিগার তৈরী ও ব্যবহার এর ভিডিও করার জন্য
Assalam o Aalikum!.
Sir Thanks Alot.
But 1 Question?
Sir i allow to user only form but whene i press create button then page redirect on report.
i do not want to go user report side.
what can i do for fix it?
Hi sir your work is unique. Can u give a tip how to create approval hierarchy? If an employee submit a request then based on request type (leave or Loan) it should be redirected to either HR or Finance department
Another business use case is that based on amount in purchase request, system reroute it on appropriate approver
when i am adding where clause list is disappering write a blog in these topic
:APP_USER variable is not working in 19.2 version. what can I do now?
&APP_USER.
Can you share this app . I will be more helpful for us.
Awesome. Thanks for share!
Thanks
one suggestion
please include the source code in the description so it will easy to use it
Ok
please provide source code
Thanks for the video. Can you make video reset user password on oracle apex, Please
Ok