Syntax

Query

  • If value (string) present: the sql query to execute otherwise the sql query will be build from children nodes

Validation

Parameter
SQL

TableName

  • List of table to query, delimited by comma (,) symbol

FieldList

Field

  • List of field in select statement
  • Multiple occurence

Condition

Field

  • List of field in where statement
  • Multiple occurence

Format

  • Condition expression

PostStatement

  • Statement to be appended after sql

Example

Query
    TableName==CLUB
    FieldList
        CLUB_ID==CLUB_ID
            Format=#
        CODE==CODE
        NAME==NAME
        MEMBER_COUNT==MEMBER_COUNT
        TOUR_COUNT==(SELECT COUNT(*) FROM TOURNAMENT WHERE TOURNAMENT.CLUB_ID=CLUB.CLUB_ID)
        STATUS==STATUS
            MappedValue==STATUS_TABLE
        CREATED==CREATED
        CREATOR==CREATOR
        MODIFIED==MODIFIED
        MODIFIER==MODIFIER
    Condition
        CLUB_ID==CLUB_ID
        CODE==CODE
            Format==UPPER(CODE) LIKE UPPER('%'||?||'%')
        NAME==NAME
            Format==UPPER(NAME) LIKE UPPER('%'||?||'%')
        SLOGAN==SLOGAN
            Format==UPPER(SLOGAN) LIKE UPPER('%'||?||'%')
        STATUS==STATUS
            Format==STATUS IN (?)
        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('%'||?||'%')
    PostStatement==ORDER BY CREATED DESC