Enter topic text here.

! BST generated View                                       ! BST generated View

BSTviewR2            VIEW(EMPLOYEE),FILTER('EMP:Department  = 915'),ORDER('+UPPER(EMP:LastName),+UPPER(EMP:FirstName),+UPPER(EMP:MiddleInitial)')

                      PROJECT(EMP:Department)

                      PROJECT(EMP:EmployeeId)

                      PROJECT(EMP:FirstName)

                      PROJECT(EMP:JobTitle)

                      PROJECT(EMP:LastName)

                      PROJECT(EMP:MiddleInitial)

                    END

BST automatically adds the key fields to the view. 

Add any additional fields that you need in the view used in the display, filters, etc.

Check the "Bind Hot Field" box if you need to bind the field to display on the screen or use in a filter.

Add any additional filter requirements here to the view.  BST constructs the basic filter needed by the template and grid selected.

You can also add your own local variable to change the filter at runtime.  It is added on the end of the filter used by the templates for records returned.  It is directly appended to the filter so it will not cause problems if it is empty (NULL).  If you construct a local filter to add to the view, remember to add the ' AND ' to the beginning.

Loc:Filter = ''

Loc:Filter = '' AND EMP:Department = 915'' 

Loc:Filter = ''AND EMP:Department = 239''

Remember to add and bind any fields from the view or other local variables used in the local filter.

BSTviewR2{prop:filter} = '' & Loc:Filter 

Construct your filter in the prompt, and all filter statements will be appended in the final filter with an  '  AND '.