4.04 SQL View - Setting
Below is example to Filter Maintain Employee
01. Click Tools | Maintain DIY.
02. Click New View Template.
03. Select Maintain Employee & Click OK.
04. Click New.
05. Enter the Description.
06. In Filter Tab Click press the button add a new condition
07. Click on the Green Font & Select Code
08. Click on the Brown Font & Select equals & Enter Example '003'
09. Click Show Text
10. Click Save & Close the windows
11. Select the Record created just now at DIY View Template & Select OK
12. Right Click at View Template you just created & Select User View (for User View)/ Browse View (For Browse View)
13. Assign the View Template to user you wanted to set to by tick on User View & Click Save. (for User View)
14. Assign the View Template to user you wanted to set to by tick Default & Click Save. (for Browse View)
Related Topic https://sites.google.com/site/sqlestream/sql-payroll/4-system-sql-payroll/4-09-sql-view---user-view-vs-browse-view