HOW TO FIX COLUMN OF INTERACTIVE GRID, IF QUERY HAVE 20 COLUMN IM DISPLAYING 10 COLUMN .AND COLUMN 9 AND 10 FIXED ,IF I DISPLAY REAMING COLUMN THEN COLUMN REMAIN FIX . AT LAST , ANY IDEA ?
Discy Latest Questions
Hello Sir, I have the following issue. I have an interactive grid, when clicking on the columns the user is directed to the form. There he can edit the form, e.g. accept or reject it. Depending on this, the user is redirected to another page. I would now like that the next time the person clicks on a column in the interactive grid, this person is redirected to the corresponding page. That is, if he has already edited the form, he should be redirected to the page to which he was redirected when he accepted or rejected the form. I have read your blog on a similar topic https://www.foxinfotech.in/2019/10/create-delete-row-button-for-interactive-report-in-oracle-apex.html and wonder if it would also work for this case or what I would have to change here. I proceeded as described in this tutorial. I use the value of the status from interactive report to redirect to the corresponding page. I use this code snippet from the blog in the interactive report. 5 case when nvl(STATUS,'APPROVED')='APPROVED' then 6 'f?p=&APP_ID.:100:8:&APP_SESSION.::::P8_ID'||ID 7 elsif nvl(STATUS,'REQUESTED')='REQUESTED' then 8 'f?p=&APP_ID.:100:9:&APP_SESSION.::::P9_ID'||ID 9 else 10 '#' 11 end LINK But I always get the error: ORA-00905: missing keyword in line 6. Is something wrong with the URL?