Koen Lostrie
2020-12-01 23:45:01
Example for the emp table of one way to do this. I'm doing it with a report but you should be able to figure out based on this how do do it with a form too.
- Create a page of type "Report > Interactive Report". Select table "EMP" and create the page.
- Edit the page in page builder. In my case this the page nr is 15.
- Create page item P15_ENAME of type "Hidden"
- Modify the report region: set WHERE clause to
ENAME = :P15_ENAME - Modify the page properties: set authentication to "Page is public". Save.
- Run the page with the url like this <hostname_and_path>/f?p=<your_app_id>:15:::::P15_ENAME:KING (replace the values between <> with your own).
热门帖子
热门github
6
Thank you for your reply I need it not as report because user need to update some fields I did it the same way as you told me , no errors appears but query did not work as well
You're providing very little information about what you want to do exactly. "did not work as well" what does that mean ? It seems you want a form but that was not mentioned in the original post. If you create a page of type form on the emp table with primary key EMPNO then you can access that page just like in bullet point 6 - just replace P15_ENAME with P15_EMPNO and KING with 7839.
sorry if i did not mention that i need a form, not working means query did not retrieve any data
so did you try what I suggested in my last comment ? How did it go ? Best way to get help is to give as much info as possible.
sorry I am New in Apex World , how can i tell the form page to execute query it is always wait for data entry ,I need it to get the data depending on the passed parameter and let me update that record