❇️ 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.
Update selected data in intercative grid with sancation button?
afzal
step-1 create your own "save" button like-- 'change rate' step-2 create a hidden dummy item like-- P10_REFNO , VALUE PROTECTED SHOULD BE OFF step-3 create dynamic action name--> get selected refno event- selection change[interactive grid] action- javascript code code-- var i, REF_NOS = "", modelRead more
Grand total caption at bottom for the Apex Interactive report
afzal
refer to this blog--> http://www.grassroots-oracle.com/2013/10/customise-totals-row-in-apex-classic.html
how to attach pdf file in outlook
afzal
Thanks for the reply Vinish sir
Interactive Report freeze column
afzal
keep this css code at inline section of the page .a-IRR-table tr th:nth-child(1), .a-IRR-table tr td:nth-child(1) { position: sticky; left: 0px !important; }
Interactive Report alignment Issue to be fixed
afzal
at the report region keep this html code at "Header and Footer section" Header Text <div style="text-overflow:ellipsis;overflow:auto;white-space:nowrap"> Footer Text </div>
Display Interactive Report for different roles sql query
afzal
select id,column as title from form f,manager m,users u where f.mid=m.mid and u.id=m.id and where lower(u.username)=lower(:session_user_name) union all select id,column as title from form f,manager m,users u where f.mid=m.manid and u.id=m.id and where lower(u.username)=lower(:session_user_name)
How to display custom message when click on save button in toolbar interactive grid oracle apex
afzal
you can also use the success message section of built in interactive gride process
How to hide button in form which is created for Print
afzal
If you are using javascript code to print step -1 assign the static id for that button which you want to hide in print screen like- 'test' step-2 $("#test").hide(); window.print(); $("#test").show();
Create Row Button to update table and set value of page item
afzal
I think , you should use 'id' instead of 'mid' at this below code only. JavaScript Expression: $(this.triggeringElement).parent().data('mid') correct-- JavaScript Expression: $(this.triggeringElement).parent().data('id');
How to return 0 with max function?
afzal
WITH TBL AS(select count(tasks) my_tasks, max((select count(created_by) my_projects from projects where created_by = :USER_ID)) as my_rec FROM tasks WHERE asignee = :USER_ID UNION ALL SELECT count(tasks) my_tasks,0 AS my_projects FROM tasks WHERE asignee = :USER_ID ) SELECT my_tasks, SUM(my_projectsRead more