Design Example
 
  1
4
   
7
How to change a MetaTemplate? 
  Consider a table named Film_Production. Film_Production has a field called "approvedflag" which actually stores the value whether the reported activity has been approved of or rejected. In the table given below all the fields which are of NOT NULL CHAR(1) are the approved flag fields. In the HTML version, the retrieved data is shown as Freemarker tags in the ${...} format.
   
  Table Structure
 
ID
NOT NULL NUMBER(10)

RCOPRODUCTION_AGREEMENT

  NUMBER(4)
ACOPRODUCTION_AGREEMENT   NUMBER(4)
COPRODUCTION_AGREEMENT NOT NULL CHAR(1)
RNO_SUBSIDISED_FILM   NUMBER(4)
ANO_SUBSIDISED_FILM   NUMBER(4)
ANO_SUBSIDISED_FILM   ANO_SUBSIDISED_FILM
NO_SUBSIDISED_FILM NOT NULL CHAR(1)
RGOVT_SUBSIDISED_DISTRIBUTION   NUMBER(19,2)
AGOVT_SUBSIDISED_DISTRIBUTION   NUMBER(19,2)
GOVT_SUBSIDISED_DISTRBUTION NOT NULL CHAR(1)
RGOVT_SUSBSIDISED_COLLECT   NUMBER(19,2)
AGOVT_SUSBSIDISED_COLLECT   NUMBER(19,2)
GOVT_SUBSIDISED_COLLECT NOT NULL CHAR(1)
RPRODUCTION_COMPANIES   NUMBER(4)
APRODUCTION_COMPANIES   NUMBER(4)
PRODUCTION_COMPANIES NOT NULL CHAR(1)
RFEATURE_PRODUCED   NUMBER(5)
AFEATURE_PRODUCED   NUMBER(5)
FEATURE_PRODUCED_SRC NOT NULL NUMBER(10)
FEATURE_PRODUCED NOT NULL CHAR(1)
RFEATURE_DUBBED   NUMBER(6,2)
AFEATURE_DUBBED   NUMBER(6,2)
FEATURE_DUBBED NOT NULL CHAR(1)
RFEATURE_SUBTITLED   NUMBER(6,2)
AFEATURE_SUBTITLED   NUMBER(6,2)
FEATURE_SUBTITLED NOT NULL CHAR(1)
RFEATURE_BOTH   NUMBER(6,2)
AFEATURE_BOTH   NUMBER(6,2)
FEATURE_BOTH NOT NULL CHAR(1)
RFILM_DUPLICATION_LAB   NUMBER(4)
AFILM_DUPLICATION_LAB   NUMBER(4)
FILM_DUPLICATION_LAB NOT NULL CHAR(1)
YEAR NOT NULL NUMBER(10)
COUNTRY NOT NULL NUMBER(10)
  Design
  Change the view metatemplate to show different gif's instead of showing the text as approved or rejected
  Steps to achieve
  Open the view metatemplate under the sitename/metatemplates folder. · Change the metatemplate. Pseudo code for the modification is as follows.
  < == "N" || == "A" || == "P" || == "R">
         <td width="15%" class=VTableContent > </td>
         < >
                    < "A">
                            <td width="18%" class=VTableContent align="center">
                            <img src= "/faqx/images/approve.gif">
                            </td>
                    <>
                    < "R">
                            <td width="18%" class=VTableContent align="center">
                            <img src= "/faqx/images/reject.gif">
                            </td>
                    <>
                    <>
                            <td width="18%" class=VTableContent >
                            &nbsp;
                            </td>
                    <>
                    
             height="25">
 
   
 
 
  1
4