❇️ OrclQA.Com is a question and answer forum for programmers.
❇️ Here anyone can ask questions and anyone can answer to help others.
❇️ It hardly takes a minute to sign up 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.
OrclQA.Com is a question and answer forum for programmers.
Here anyone can ask questions and anyone can answer to help others.
It hardly takes a minute to sign up and it is 100% FREE.
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...
Redirect 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.
Getting error ORA-00904 when creating interactive report
Ana
Hello yes I have also seen that but in the query I use f.SPID
Getting 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
Create Row Button to update table and set value of page item
Ana
Hello:) thank you for this answer I will try it!:)
Create 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
How 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
Create 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!
Create 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.