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 this place is just for you 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.
Redirect Page by function call in before-header process
Ana
I am not quite sure whether this is what fits the best here since my url depends on the state which I retrieve from the table. But in the post, the target page is already set manually...
I am not quite sure whether this is what fits the best here since my url depends on the state which I retrieve from the table. But in the post, the target page is already set manually...
See lessRedirect Page by function call in before-header process
Ana
Yes this is what I want, regarding the state from the table I want to redirect to another page in the same application.
Yes this is what I want, regarding the state from the table I want to redirect to another page in the same application.
Getting error ORA-00904 when creating interactive report
Ana
Hello yes I have also seen that but in the query I use f.SPID
Hello yes I have also seen that but in the query I use f.SPID
See lessGetting error ORA-00904 when creating interactive report
Ana
Sure, I can explain it. This is the SQL query on which the interactive report is based: select f.FPID, f.TITLE,f.DATE,f.STATE FROM FORM f left outer join MANAGER m on m.MID=f.MID left outer join USERS u on u.UUID=m.UUID where lower(u.username)=lower(:session_user_name); With this query, the report iRead more
Sure, I can explain it.
This is the SQL query on which the interactive report is based:
With this query, the report is displayed normally.
See lessHowever, when I try to retrieve another column from the Form table for the report, I get the error described above.
Create Row Button to update table and set value of page item
Ana
Hello:) thank you for this answer I will try it!:)
Hello:) thank you for this answer I will try it!:)
See lessCreate Row Button to update table and set value of page item
Ana
select (u.LASTNAME||','||u.FIRSTNAME) as Name, u.EMAIL, u.ID,m.MID 'Update' upd from users u right outer join manager on m.MID=u.MID where utl_match.jaro_winkler_similarity(:P8_LASTNAME,u.LASTNAME)>80; the sql query is actually structured like this
Create Row Button to update table and set value of page item
Ana
Yes I am submitting the item P8_MID, sorry did not mention it
Yes I am submitting the item P8_MID, sorry did not mention it
See lessHow can values be passed in the URL
Ana
Hello Vinish, this is how I set the P8_ID. I created a pre-rendering process with the following PL/SQL Code: declare l_id number; begin select f.id into l_id from formtable f left outer join users u on u.UUID=f.UUID where lower(u.username)=lower(:session_user_name); apex_util.set_session_state('P8_IRead more
Hello Vinish,
this is how I set the P8_ID.
I created a pre-rendering process with the following PL/SQL Code:
I checked it by viewing the session in the debug tool bar.
And the value is set.
By using this function:
I get the error:
ERR-1002 Unable to find item ID for item "5" in application "100".
The number 5 is the ID of the form.
See lessCreate column in interactive report to redirect to corresponding page
Ana
Ok it works I just have to change the second it to: case when......(first case) when....(second case) Thank you so much for this blog post!
Ok it works I just have to change the second it to:
case when......(first case)
when....(second case)
Thank you so much for this blog post!
See lessCreate column in interactive report to redirect to corresponding page
Ana
Hello Vinish thank you for your fast answer!:) The redirection takes place when I only have one case, when I insert a second one I unfortunately get the error I already described.
Hello Vinish thank you for your fast answer!:)
The redirection takes place when I only have one case, when I insert a second one I unfortunately get the error I already described.