‏إظهار الرسائل ذات التسميات Apex. إظهار كافة الرسائل
‏إظهار الرسائل ذات التسميات Apex. إظهار كافة الرسائل

الأحد، 3 نوفمبر 2019

الثلاثاء، 6 أغسطس 2019

hide column in classic report [Card Template] Using Custom Template and CSS




you can hide column in classic report in stranded template
by 2 ways
by condition
like
Rows returned
select 1 from dual where 1=2or by using
Authorization Scheme to column
but if You try to make the same for some other template like CARD Template
this will not work
so that you can flow this steps
1 : Copy card template
2: edit the new card template and one substituting  #CARD_STATUS#
<li class="t-Cards-item #CARD_MODIFIERS#">
#CARD_INITIALS#

#CARD_TITLE#

#CARD_TEXT#
#CARD_STATUS# ">#CARD_SUBTEXT#
</div>
<span class="t-Card-colorFill u-color #CARD_COLOR#"></span>
</a>
</div>
</li>
--
3: Assign the new template to your report and add case to check any condition
select
'fa-user' CARD_ICON,
ENAME CARD_TITLE,
JOB CARD_TEXT,
MGR LABEL_01,
HIREDATE CARD_SUBTEXT,
SAL COMMENT_TEXT,
CASE
when UPPER(JOB) Like Upper('SALESMAN')
then 'Status_CLASS'
else ''
end CARD_STATUS
from EMP
--
in our case when JOB = SALESMAN
we will set value for our column CARD_STATUS by  'Status_CLASS'
-----
now our template contain class Status_CLASS
only when JOB = SALESMAN
-----
4: add inline css code for our class
.Status_CLASS
{display: none;}
at the end
any raw contain [job =SALESMAN] will add  a new class for our column CARD_SUBTEXT  which will hide content

How to create Multi language Application in Oracle apex 19.1

Part 1



Part 2

Oracle Apex classic report template

How to Create lookup table in oracle Apex

oracle apex Error Handling (Arabic)

Custom Authentication in oracle apex ( Arabic)



custom Authentication  in oracle apex ( Arabic)






Print custom PDF Report Using PL/SQL Dynamic Region in Oracle Apex 19.1

Print custom PDF Report Using PL/SQL Dynamic Region in Oracle Apex 19.1



Print custom PDF Report Using Layout [XSL] Designed By Altova StyleVisio...



Print custom PDF Report Using Layout [XSL] Designed By Altova StyleVisio...



Print custom PDF Report Using Report Query and Custom Report Layout [XSL]

Print custom PDF Report Using Report Query and Custom Report Layout [XSL]


Print custom PDF Report Using Report Query and Generic Report Layout

Print custom PDF Report Using Report Query and Generic Report Layout



How to use Oracle Apex [API] Arabic

How to use Oracle Apex [API] Arabic

الاثنين، 5 أغسطس 2019

Missing Error in apex.submit API

this example for apex.submit API is not true we Miss one ' } ' the correct apex.submit( { request:"DELETE", set:{"P1_DEPTNO":10, "P1_EMPNO":5433} } );

Dynamic Action in Oracle Apex 19.1 Arabic tutorial


New Arabic tutorial Dynamic Action in Oracle Apex 19.1

                                                           Youtube

Bootstrap Tutorial with APEX


Bootstrap Tutorial with APEX

383516_42e9_3

Create PDF Dynamic Report Using PL/SQL

Dynamic Report by pl/SQL

How to create Dynamic Report by pl/SQL and print it using browser
1- create region  (pl dynamic)
and use htp.p package to write html code in pl/sql body
declare
v_dept_name varchar2(100);
v_dept_loc varchar2(100);
begin
select Dname,loc into  v_dept_name ,v_dept_loc from dept where DEPTNO=:p4_dept_no;
htp.p('<table class="table1"> ');
   htp.p(' <caption>printing with pl/sql</caption> ');
    htp.p('<tr>');
        htp.p('<th>');
        htp.p('dept name');
        htp.p('</th>');
        htp.p('<th>');
        htp.p('dept loc');
        htp.p('</th>');
        htp.p('</tr>');
    htp.p('<tr>');
            htp.p('<td>');
            htp.p(v_dept_name);
            htp.p('</td>');
            htp.p('<td>');
            htp.p(v_dept_loc);
            htp.p('</td>');
    htp.p('</tr>');
htp.p('</table>');
htp.p('
      <style>
     .table1 caption
    { margin: auto;
 color:#fff;
 background-color:gray;
    font-weight:bold;
    font-size:16px;}
          .table1
    {  margin: auto;
    width: 50%; }
    .table1 tr td
    {border:1px solid red;
      text-align:center }
         .table1 tr th
    {border:1px solid red;
    background-color:#bec0c4;}   
    </style>
   
 ');
end;
2- remove all navigation from page to show the region only
3- use browser to print report


How to Solve Ords Issue : The request could not be mapped to any database.

 The request could not be mapped to any database.  Check the request URL is correct, and that URL to database mappings have been correctly c...