DIC query process
Syntax
Query
- If value (string) present: the sql query to execute otherwise the sql query will be build from children nodes
Validation
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