Web Editor¿¡ µå·Ó ´Ù¿î ¸Þ´º Ãß°¡

¾ç½ÄÀ» ½±°Ô ÀÛ¼ºÇÏ°í »ç¿ëÀÚ°¡ ¿Ã¹Ù¸¥ ¼±ÅûçÇ׸¸À» ¼±ÅÃÇÒ ¼ö ÀÖµµ·Ï Á¦ÇÑÇϱâ À§ÇØ Web Editor ¾ç½Ä¿¡ µå·Ó ´Ù¿î ¸Þ´º ¾ç½ÄÀÇ ¸ñ·ÏÀ» Ãß°¡ÇÒ ¼ö ÀÖ½À´Ï´Ù.

¼±ÅûçÇ× ¸ñ·ÏÀ» ÃֽŠÁ¤º¸·Î °íÄ¡±â À§ÇØ ¿î¿µÀÚ´Â Web Editor¸¦ ´Ù½Ã ½ÃÀÛÇÒ ¼ö ÀÖ½À´Ï´Ù. ¸Å¹ø µå·Ó ´Ù¿î ¸Þ´º¸¦ ´Ù½Ã ·ÎµåÇϵµ·Ï ¿î¿µÀÚ°¡ "true"·Î ¼³Á¤ÇÒ ¼ö ÀÖ´Â dynamicSqlSelectionList¶ó´Â ¾ç½Ä ¼³¸í ÇÊµå ¼Ó¼ºÀÌ ÀÖ½À´Ï´Ù.

¼±Åà ¸ñ·Ï¿¡ ´ëÇÑ Á¶È¸´Â Çϳª ¶Ç´Â µÎ °³ÀÇ ¿­À» ¸®ÅÏÇÏ´Â °á°ú ¼¼Æ®¸¦ °¡Áú ¼ö ÀÖ½À´Ï´Ù. °á°ú¿¡ µÎ °³ÀÇ ¿­ÀÌ ¸®ÅϵǴ °æ¿ì µÎ ¹øÂ° ¿­¿¡ ½ÇÁ¦ ÀúÀåµÈ °ªÀÌ Æ÷ÇԵǾî ÀÖÀ¸¸ç ù ¹øÂ° ¿­¿¡´Â »ç¿ëÀÚ ·¹À̺íÀÌ Æ÷ÇԵǾî ÀÖ½À´Ï´Ù.

¼±Åà ¸ñ·ÏÀº Çʵå ű×ÀÇ sqlSelectionList ¼Ó¼º¿¡ SQL Á¶È¸¸¦ ÀÔ·ÂÇϰųª XML ¾ç½Ä ¼³¸í ÆÄÀÏ¿¡ ¿­°Å¸¦ ÀÛ¼ºÇÏ¿© ÀÛ¼ºµË´Ï´Ù. ´ÙÀ½ ¿¹¿¡ µÎ ¹æ¹ýÀÌ ¸ðµÎ ³ª¿Í ÀÖ½À´Ï´Ù.

  <field name="MEMBER_ID"
    showInCreateMode="false"
    fieldDescription="Member Identifier"
    .
    .
    readOnly="false"
    sqlSelectionList="select orgentityname,orgentity.orgentity_id 
     from member,orgentity where member.type='O' 
     and member.member_id=orgentity.orgentity_id"
    .
    .
    fieldHelp=""
    .
    .
      </field>
        <field name="MARKFORDELETE"
          fieldDescription="Mark for Delete"
          type="NMTOKEN"
          sqlSelectionList=""
        >
        <datatype source="integer">
          <enumeration label="No" value="0"/>
          <enumeration label="Yes" value="1"/>
        </datatype>
      </field>
  >

WebSphere Commerce µ¥ÀÌÅͺ£À̽º Å×ÀÌºí¿¡ true ¹× false¿¡ ´ëÇØ 1°ú 0À» »ç¿ëÇÏ´Â Çʵ尡 ÀÖ½À´Ï´Ù. »ç¿ëÀÚ¿¡°Ô Á»´õ ¾Ë±â½¬¿î Çʵ带 ÀÛ¼ºÇϱâ À§ÇØ ÀÌ ÇʵåÀÇ ¿­°Å Å×À̺íÀ» ¼³Á¤ÇÒ ¼ö ÀÖ½À´Ï´Ù. Catalog Manager´Â "NUMDESC"¶ó´Â ¿­°Å Å×À̺íÀ» ÀÛ¼ºÇÏ´Â SQL ½ºÅ©¸³Æ®¸¦ Á¦°øÇÕ´Ï´Ù. ÀÌ ½ºÅ©¸³Æ®ÀÇ À̸§Àº "createEnum.sql"ÀÔ´Ï´Ù. ¿î¿µÀÚ´Â ´ÙÀ½ ¿¹¿¡ Ç¥½ÃµÈ ENUMDESC Å×À̺íÀ» »ç¿ëÇÏ¿© sqlSelectionList ¼Ó¼ºÀ» ÆíÁýÇÏ¿© ¼±Åà ¸ñ·ÏÀ» ÀÛ¼ºÇÒ ¼ö ÀÖ½À´Ï´Ù.

  fieldDescription="On Special"
  .
  .
  readOnly="false"
  sqlSelectionList="select description,value from
    enumdesc where columnname='ALL' and type='YESNO'"
  fieldHelp=""
  .
  .

°ü·Ã °³³ä

°ü·Ã ŽºÅ©



IBM copyright