^ SQL type           ^ column list  ^ join cond. ^ where cond. ^ group by ^ order by ^ union ^  
| standard grid      | C            | J          | W           | G        | O or O++   | U     |
| detail grid        | C            | J          | W+          | G        |            | U     |   
| advanced filter    | C            | J          | W++         | G        | O+         | U     |
| lookup pull down   | C+           | J          | W           | G        | O          | U     |
| lookup relation    | C++          | J          | W           | G        | O          | U     |



C - instance definition column list\\
C+ -  2 columns only\\
C++ - 3 columns mandatory\\

\\
J - instance definition join condition
\\
W - instance definition where condition\\
W+ - master-detail linked columns\\
W++ - data-filter linked columns\\

\\
O - instance definition order by clause\\
O+ - advanced filter order by ID\\
O++ - system configuration\\
\\
G - instance definition group by clause\\
\\
U - instance definition union clause\\
? - not available\\