User can set data source SQL for view output in this section.
AppliFilters ->User can set list of filters which are applicable on this view.
E.g- Comp,Campus ..etc
Type ->User can set Data source query type Default value is Fields but user can it to Template as per requirement.
View Width Percent ->User can set view’s output percentage.
Ignore Paging ->Default value for this is False but user can set True if paging require on view output.
Select-> User can set fields of Data source Query without select and Form keywords.
From-> User can set Data Source Tables or Functions.
Client-> User can use Client if DataSoursce is PDCClientView
Group By-> User can set Group by Fields of select query.
Having-> If SQL query included Having Condition then user can set having condition in this section.
Order BY-> User can set Order columns in this section.
Fixed Where-> User can set fixed where conditions in this section.
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.
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.
<FILTER> ->Starting Tag.
FILTER KEY->Set Filter key define in Table ClientFilter
VALUE VALUE1->Set IdField like FinyearID.Function Currfinid pick current finyearid.
OPERTYPE->Set operation type like eq for Equal.
</FILTER> ->Ending Tag.
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
How to use where param:
E.g. Use WhereParam conditions in MenuDefination