Note : QueryVars Section is included in
1) ListType1Page, PopList1Page, etc
2) Fixed by parameter json file
2) Can not be changed by user behavior such as changing filter variables
Level1 | Level 2 | Level 3 | Descriptiion | Remarks |
---|---|---|---|---|
QueryVars | QueryName | query folder Namequery folder Namequery folder Namequery folder Namequery folder Name | plain.sql, plain_cnt.sql | |
FilterName | Query Filter Name | ex) mx.id | ||
FilterValue | Query Fileter Value be composed with FilterName | |||
SimpleFilter | Where Clause | ex) mx.id = 3, item_code = 'aaa' |
Note : QueryVars Section is included in
1) ListType1Page, PopList1Page, etc
2) Fixed by parameter json file
2) Can not be changed by user behavior such as changing filter variables
Level1 | Level 2 | Level 3 | Descriptiion | Remarks |
---|---|---|---|---|
QueryVars | QueryName | query folder Namequery folder Namequery folder Namequery folder Namequery folder Name | plain.sql, plain_cnt.sql | |
FilterName | Query Filter Name | ex) mx.id | ||
FilterValue | Query Fileter Value be composed with FilterName | |||
SimpleFilter | Where Clause | ex) mx.id = 3, item_code = 'aaa' |
Note : SimpleSelectPage Section is included in
1) ListType1Page
This is used for get query for simple select column.
In this case SimpleSelectOptions should be empty like : "SimpleSelectOptions": [],
Level1 | Level 2 | Level 3 | Descriptiion | Remarks |
---|---|---|---|---|
QueryVars | QueryName | request simple-join-page | select-option location is queries/page/simple-join | |
QueryName | ||||
PageVars | QueryName |