request-json-snipets.md 1.8 KB

Request Json Components

QueryVars

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'

ListVars

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'

SimpleSelectPage

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