❇️ 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.
Apex Collection: how to have actual column names instead of C001, C002...
AhmedHaroon
hi @Vinish, my feedback... its working fine in your sample/example app. thanks again. with best regards.
hi Vinish, my feedback... its working fine in your sample/example app.
thanks again.
with best regards.
See lessApex Collection: how to have actual column names instead of C001, C002...
AhmedHaroon
thanks a bunch @Vinish, will check the code and also app you have created. best regards.
thanks a bunch Vinish, will check the code and also app you have created.
best regards.
See lessApex Collection: how to have actual column names instead of C001, C002...
AhmedHaroon
dear @Vinish sorry if i failed to describe correctly, during my search for this requirement i found the following @Carsten Czarski blog topic blogs.oracle.com/apex/post/… , here he showed us how to get actual column names but did not illustrate how to use these column names instead of C001, C002 etcRead more
dear Vinish
sorry if i failed to describe correctly, during my search for this requirement i found the following @Carsten Czarski blog topic blogs.oracle.com/apex/post/… , here he showed us how to get actual column names but did not illustrate how to use these column names instead of C001, C002 etc. this is what can be used dynamically no matter which query i run. i failed to find a solution yet.
regards
See lessAapex: PL/SQL Dynamic Content - Pagination or Page Break
AhmedHaroon
to have a page break, where you need in PL/SQL Dynamic Content add below code: htp.p('<table class="pagebreaks"> </table>'); and on page inline CSS add @media print { /* Print each group on a new page. */ .pagebreaks { page-break-after: always; } } hope juniors like me get benefit.
to have a page break, where you need in PL/SQL Dynamic Content add below code:
htp.p('<table class="pagebreaks"> </table>');
and on page inline CSS add
@media print {
/* Print each group on a new page. */
.pagebreaks {
page-break-after: always;
}
}
hope juniors like me get benefit.
See lessApex: how to exclude a selected PopUp LOV row from its Query and refresh it dynamically
AhmedHaroon
any hope to achieve this? i want it like screenshot below, how i can have this? here in the LOV there are greyed entries which are selected and for next row of grid, its now disabled to select. OR any way around it should not appear in LOV / Select List at least. regards
any hope to achieve this? i want it like screenshot below, how i can have this? here in the LOV there are greyed entries which are selected and for next row of grid, its now disabled to select. OR any way around it should not appear in LOV / Select List at least.
See lessregards
Calendar page with single date... should display details in region below
AhmedHaroon
ok, its Solved now. i was using this.data.startDate which was not working now changed, may be some juniors want to know like me: in Dynamic Action on Calendar Region, on Event = Date Selected [Calendar] and true Action is Set Value, Set Type = JavaScript Expression and JavaScript Expression is: apexRead more
ok, its Solved now. i was using this.data.startDate which was not working now changed,
may be some juniors want to know like me: in Dynamic Action on Calendar Region, on Event = Date Selected [Calendar] and true Action is Set Value, Set Type = JavaScript Expression and JavaScript Expression is: apex.date.format(this.data.dates.newStartDate, 'MM/DD/YYYY') and Affected Elements => Selection Type = Item(s) and Item(s) = P2_THEDATE
in my card region query, added in where clause:
and b.booking_date = NVL(to_date(:P2_THEDATE, 'MM/DD/YYYY'), b.booking_date)
Happy Apex'ing.
See lessregards
Subquery in SQL ?, Types of Subquery , Implementation with example?
AhmedHaroon
a brief intro to subquery: A subquery is a SELECT statement nested inside another statement such as SELECT, INSERT, UPDATE, or DELETE. Typically, you can use a subquery anywhere that you use an expression. example 01 - using 'IN' (this query will return multiple department's data): select empno, enaRead more
a brief intro to subquery:
A subquery is a SELECT statement nested inside another statement such as SELECT, INSERT, UPDATE, or DELETE. Typically, you can use a subquery anywhere that you use an expression.
example 01 - using 'IN' (this query will return multiple department's data):
select empno, ename, sal from emp where deptno IN (Select deptno from dept)
example 02 - using '=' (this query will return data only for higher/greatest department no.):
select empno, ename, sal from emp where deptno = (Select MAX(deptno) from dept)
can you google the things to find various answers? there are more other ways for using a subquery.
See lessHow i can make page item Display Only while can still be updated through Dynamic Action
AhmedHaroon
hi @Vinish, its done by using built in action Disable in dynamic action on page load. currently it seems working fine. thank you for your valuable time you are giving us.
hi Vinish, its done by using built in action Disable in dynamic action on page load. currently it seems working fine.
See lessthank you for your valuable time you are giving us.
Tab Container: how to navigate to Next Tab through button
AhmedHaroon
thanks a bunch @Vinish for solution inclusive of guidance. 2 thumbs up. kind regards
thanks a bunch Vinish for solution inclusive of guidance. 2 thumbs up.
See lesskind regards
how to populate data manually in editable IG
AhmedHaroon
@Vinish i found your earlier post (solution) for the same which i will try. https://orclqa.com/question/how-to-fill-data-into-interactive-grid-based-on-page-item-value/ regards note: need help for How To populate data in an IG with JS from another table to avoid enter data directly into table firstRead more
Vinish
i found your earlier post (solution) for the same which i will try.
https://orclqa.com/question/how-to-fill-data-into-interactive-grid-based-on-page-item-value/
regards
note: need help for How To populate data in an IG with JS from another table to avoid enter data directly into table first as mentiond in above link.
See less