Logic
#    ListAllItem
    FirstFocus==CODE
    KeyField==LY_MODULE_ID
    NameField==CODE
Field
    Text==LY_MODULE_ID
        Trim
        MaxLength==5
        LiveValidation
            Numericality
                OnlyInteger
    Combo==LY_MODULE_TYPE_ID
        Item==SQL
            AddNullValue
            Value==SELECT LY_MODULE_TYPE_ID,NAME FROM LY_MODULE_TYPE ORDER BY NAME
    Text==CODE
        Trim
        MaxLength==50
    Text==CONTENT
        Trim
        MaxLength==4000
    DateRange==CREATED
        Trim
        TimePicker==true
    Text==CREATOR
        Trim
        MaxLength==50
    DateRange==MODIFIED
        Trim
        TimePicker==true
    Text==MODIFIER
        Trim
        MaxLength==50
    Submit==GEN_HTML
    Submit==GEN_EXCEL
    Button==ADD
        Extra==!"onclick=\\"create" + action.getId() + "(this);\\""
    Button==REMOVE_SELECTED
        Extra==!"onclick=\\"removeSelected" + action.getId() + "(this);\\""
Popup
    Width==960
    Height==520
Layout==Simple
    Panel
        Layout==Simple
            Control==CODE
            Panel
                Layout==DropDown
                    Control==LY_MODULE_TYPE_ID
                    Control==CONTENT
                    Control==CREATED
                    Control==CREATOR
                    Control==MODIFIED
                    Control==MODIFIER
            Control==GEN_HTML
            Control==GEN_EXCEL
            Control==ADD
            Control==REMOVE_SELECTED
Query
    TableName==LY_MODULE
    FieldList
        LY_MODULE_ID==LY_MODULE_ID
            Format==#
        LY_MODULE_TYPE_ID==(SELECT NAME FROM LY_MODULE_TYPE WHERE LY_MODULE.LY_MODULE_TYPE_ID=LY_MODULE_TYPE.LY_MODULE_TYPE_ID)
        CODE==CODE
        CONTENT==to_char(CONTENT)
            OpenHtml==<div style="max-height:120px;width:400px;overflow:auto;"><a class="previewLink" href="javascript:void(0)" rel="preview.jsp?pk=$Value0$&popup=true">
            CloseHtml==</a></div>
        CREATED==CREATED
        CREATOR==CREATOR
#        MODIFIED==MODIFIED
#        MODIFIER==MODIFIER
    Condition
        LY_MODULE_ID==LY_MODULE_ID
        LY_MODULE_TYPE_ID==LY_MODULE_TYPE_ID
        CODE==CODE
            Format==UPPER(CODE) LIKE UPPER('%'||?||'%')
        CONTENT==CONTENT
            Format==UPPER(CONTENT) LIKE UPPER('%'||?||'%')
        CREATED==CREATED_FROM
            Format==CREATED >= TO_DATE(?,'DD/MM/YYYY HH24:MI:SS')
        CREATED==CREATED_TO
            Format==CREATED <= TO_DATE(?,'DD/MM/YYYY HH24:MI:SS')
        CREATOR==CREATOR
            Format==UPPER(CREATOR) LIKE UPPER('%'||?||'%')
        MODIFIED==MODIFIED_FROM
            Format==MODIFIED >= TO_DATE(?,'DD/MM/YYYY HH24:MI:SS')
        MODIFIED==MODIFIED_TO
            Format==MODIFIED <= TO_DATE(?,'DD/MM/YYYY HH24:MI:SS')
        MODIFIER==MODIFIER
            Format==UPPER(MODIFIER) LIKE UPPER('%'||?||'%')
    DefaultOrderField==CREATED
    DefaultOrderType==DESC