DataSource Tab
User can set data source SQL for view output in this section.
![](/Asset/S-4/viewdatasourcetab.png)
AppliFilters ->User can set list of filters which are applicable on this view.
E.g- Comp,Campus ..etc
![](/Asset/S-4/viewapplifilters.jpg)
Type ->User can set Data source query type Default value is Fields but user can it to Template as per requirement.
![](/Asset/S-4/viewtype.jpg)
View Width Percent ->User can set view’s output percentage.
E.g-140.00
Ignore Paging ->Default value for this is False but user can set True if paging require on view output.
![](/Asset/S-4/viewignorepaging.jpg)
Fields Tab
![](/Asset/S-4/viewfieldstab.jpg)
Select-> User can set fields of Data source Query without select and Form keywords.
![](/Asset/S-4/viewselect.jpg)
From-> User can set Data Source Tables or Functions.
![](/Asset/S-4/viewfrom.png)
Client-> User can use Client if DataSoursce is PDCClientView
![](/Asset/S-4/viewclient.png)
Group By-> User can set Group by Fields of select query.
![](/Asset/S-4/viewgroupby.jpg)
Having-> If SQL query included Having Condition then user can set having condition in this section.
![](/Asset/S-4/viewhaving.png)
Order BY-> User can set Order columns in this section.
![](/Asset/S-4/vieworderby.png)
Fixed Where-> User can set fixed where conditions in this section.
![](/Asset/S-4/viewfixedwhere.jpg)
ObjPermission-> User can set Object which must be present in that Product.
Generate->User can verify output of views after entered SQL query go to Grid available after Common tab then clicking on Generate Button and showing output.
![](/Asset/S-4/viewgenerate.jpg)
Parameters Tab
![](/Asset/S-4/parameterstab.jpg)
FiltParam-> User can set fixed filter with default value in this block.
Note: FiltParam should be in XML Code and use correct Syntax. If syntax not correct then errors showing in Errors block and applied Filters should be present in AppliFilters List.
E.g.
![](/Asset/S-4/FiltParam.png)
<FILTER> ->Starting Tag.
FILTER KEY->Set Filter key define in Table ClientFilter
ACTION->Set Default
VALUE VALUE1->Set IdField like FinyearID.Function Currfinid pick current finyearid.
OPERTYPE->Set operation type like eq for Equal.
</FILTER> ->Ending Tag.
Output->
![](/Asset/S-4/filteroutput.jpg)
WhereParam ->
How to Create where param:
User can create user define where conditions as per requirement between starting tag & ending tag and apply particular on menu’s in menu definition.
E.g: <INVSL> Starting Tag & </INVSL> ending tag.DocType=’IS’ User define condtion
![](/Asset/S-4/WhereParam.png)
How to use where param:
E.g. Use WhereParam conditions in MenuDefination
![](/Asset/S-4/WhereParaminmenudifination.png)