Step 4 Creating a Real By Location Filter

Visual LANSA Framework

Step 4. Creating a Real By Location Filter

In this step you create a real By Location filter.

1.   In the Framework start the Program Coding Assistant.

2.   Drill down through the tree to find your by Location filter and select it.

3.   Select Native MS Windows and the type "Filter that searches using a file or view".

4.   Specify PSLMST as the physical file.

5.   Press the Next button.

  • For your VISUAL IDENTIFIERS specify fields EMPNO, GIVENAME and SURNAME
  • For your PROGRAMATIC IDENTIFIERS specify field EMPNO only.
  • No ADDITIONAL COLUMNS should be specified.

 

6.   Click the Next button to move the Program Coding Assistant forward to the next  prompt. This prompt is asking you to select the file or view that the filter should use for searching. 

  • Specify PSLMST as the underlying physical file.
  • Select the file view named PSLMST1 (Personnel by Department, Section, Employee Number).
  • Select the search keys DEPTMENT and SECTION.
  • Uncheck "User must specify all Chosen Keys".
  • Uncheck "Allow Generic Searching".
  • Check "Remember key values between filter executions".
  • Check "Allow user to clear instance list".

 

7.   A screen with additional options is displayed. Do not select any. Click the "Generate Code" button. The right hand side of the Program Coding Assistant now shows the code that it has generated for your filter.

8.  In the Generated Code window specify iiiCOM02 as the name of your new filter and give it a description. Then click the Create button to create your filter.

     (Alternatively you can copy the generated code to the clipboard by clicking the "Copy Code to Clipboard" button and paste the code into an existing reusable part).

9.  Your filter is displayed in the Visual LANSA editor. Compile it.