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.
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; }
keep this css code at inline section of the page
.a-IRR-table tr th:nth-child(1),
See less.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>
at the report region keep this html code at "Header and Footer section"
Header Text
See less<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)
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
See lessfrom 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
you can also use the success message section of built in interactive gride process
See lessHow 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();
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
See less$("#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');
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');
See lessHow 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
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
See lessFROM tasks WHERE asignee = :USER_ID
)
SELECT my_tasks, SUM(my_projects) AS my_projects
FROM TBL
GROUP BY my_tasks
Apex error message displays only for fraction of seconds
afzal
apex.message.clearErrors(); apex.message.showErrors([{ type: "error", location: "inline", pageItem: pItem, message: pData, unsafe: false }, { type: "error", location: "inline", message: "An error has occurred.", unsafe: false } ]); // TO HIDE CLIENT SIDE ERROR MESSAGE setTimeout(function() { $('#APERead more
apex.message.clearErrors();
apex.message.showErrors([{
type: "error",
location: "inline",
pageItem: pItem,
message: pData,
unsafe: false
},
{
type: "error",
location: "inline",
message: "An error has occurred.",
unsafe: false
}
]);
// TO HIDE CLIENT SIDE ERROR MESSAGE
See lesssetTimeout(function() {
$('#APEX_ERROR_MESSAGE').fadeOut('fast');
}, 2000);
Department wise Sum salary, XML cannot be used here.
afzal
FOR DYNAMIC PIVOT QUERY-- SEE THIS ARTICAL--https://technology.amis.nl/oracle/dynamic-sql-pivoting-stealing-antons-thunder/
FOR DYNAMIC PIVOT QUERY--
SEE THIS ARTICAL--https://technology.amis.nl/oracle/dynamic-sql-pivoting-stealing-antons-thunder/
See lessTwo ajax callback process with single button problem
afzal
sorry , there is something wrong in above code, ignore that , use this one-- use nested ajaxcallbackprocess in single js code like-- apex.server.process( 'insert_master', { pageItems:'#P16_DATE,#P16_TYPE,#P16_MID', x01: $v('P16_DATE'), x02: $v('P16_TYPE'), x03: $v('P16_MID') }, // Parameter to be paRead more
sorry , there is something wrong in above code, ignore that , use this one--
use nested ajaxcallbackprocess in single js code like--
apex.server.process( 'insert_master',
{ pageItems:'#P16_DATE,#P16_TYPE,#P16_MID',
x01: $v('P16_DATE'),
x02: $v('P16_TYPE'),
x03: $v('P16_MID')
}, // Parameter to be passed to the server
{
success: function (pData) { // Success
console.log(pData);
//$s('P16_MID',pData.mid);
$s('P16_NUMBER',pData.vno);
///----------detail table code -----------------
var model = apex.region("detail").widget().interactiveGrid("getViews", "grid").model;
var cont = 0;
col_c001 = model.getFieldKey("MID");
col_c002 = model.getFieldKey("ACC_CODE");
col_c003 = model.getFieldKey("NARRATION");
col_c004 = model.getFieldKey("DEBIT");
col_c005 = model.getFieldKey("CREDIT");
col_c006 = model.getFieldKey("SRNO");
model.forEach(function (igrow) {
apex.item("P16_ACC_CODE").setValue(igrow[col_c002].v);
apex.item("P16_NARRATION").setValue(igrow[col_c003]);
apex.item("P16_DEBIT").setValue(igrow[col_c004]);
apex.item("P16_CREDIT").setValue(igrow[col_c005]);
apex.item("P16_SRNO").setValue(cont+1);
cont = cont+1;
apex.server.process( 'insert_detail',
{ pageItems:'#P16_MID,#P16_ACC_CODE,#P16_NARRATION,#P16_DEBIT,#P16_CREDIT,#P16_SRNO',
x01: $v('P16_MID'),
x02: $v('P16_ACC_CODE'),
x03: $v('P16_NARRATION'),
x04: $v('P16_DEBIT'),
x05: $v('P16_CREDIT'),
x06: $v('P16_SRNO')
}, // Parameter to be passed to the server
{
success: function (pData) { // Success
console.log($v('x01'));
console.log($v('x02'));
/*apex.item('P16_MID').setValue(pData.mid);
apex.item('P16_NUMBER').setValue(pData.vno);*/
},
error: function(e){
console.log("Error: ", e);
},
dataType: "json" // Response type
});
});
See less//--end nested ajaxcallback process
},
error: function(e){
console.log("Error: ", e);
},
dataType: "json" // Response type
}
);