Makerel

< MAKEREL> < / MAKEREL> -> < MAKEREL> is starting tag and < / MAKEREL> is ending tag. This tag used to make a relationship all define views under complex view with the help of ID Field and values of Bands.

INSERTAT-> User can set value of insert at like 0.
FIELD-> User can set key field as per data source sql of view and all define child view to be added with parent views.
BANDS-> User can set value of bands like 12, 3...as per taken views under complex view.
MASTER -> User can set value of master for define parent view of respected child items views under this tag.
CHILD-> User can set parent’s child views index under this tag.

Complex View

User can link multiple views through a key field in this section.

DISPGRID-> We can set display grid between < DISPGRID>starting & < DISPGRID> ending tags.

E.g.

MAINGRID -> We can define main grid using < MAINGRID >starting & < MAINGRID > ending tags.

E.g.

VIEW KEY -> User can set view for display grid.

E.g.

MODROW -> We can applied user define conditions like where condition, hidecolums etc.

E.g.

SQLWHERE2-> We can applied where condition between < SQLWHERE2> & < /SQLWHERE2>.

E.g.

STRVIEW-> We can set view display name using < STRVIEW> & < / STRVIEW> tags.

E.g.

HIDECOLS-> We can hide columns using < HIDECOLS> & < /HIDECOLS>.

E.g.

Output: