<DataSource ID="companyDS" serverType="sql" tableName="company" autoDeriveSchema="true" >

    <operationBindings>
        <operationBinding operationType="fetch">
            <criteria fieldName="deleted" value="false"/>
        </operationBinding>
    </operationBindings>

    <field name="deleted" title="Deleted" type="boolean" hidden="true" />
    <field name="companynonlocked" title="Non Locked" type="boolean" />

    <!--

     Example of DMIHandler for all operations, fetch(), add(), update(), remove()

     <serverObject className="com.sample.DMIHandler"/>

     -->

    <!--

     Ecample of a DMIHandler for remove operation only

     <operationBinding operationType="remove">
        <serverObject className="com.sample.DMIHandler" methodName="customRemove"/>
     </operationBinding>

     -->

    <!-- SOFT DELETE WITH SERVER SCRIPTING

     <script language="java">

        if (DataSource.isRemove(dsRequest.getOperationType())) {
            dsRequest.setFieldValue("deleted", true);
        }

        dsRequest.setOperationType("update");
        return dsRequest.execute();

     </script>

     -->

    <!--

     VALIDATION EXAMPLE

     <field name="shipDate" type="date"> <validators>
        <validator
            type="serverCustom"
            serverCondition="$value.time > $record.orderDate.time"/>
        </validators>
     </field>

     -->

</DataSource>