Step 2 Change your filter

Visual LANSA

Step 2. Change your filter

Next, you need to make changes to your filter to fill the extra fields in the instance list with data.

1.  Open the By Location filter iiiWAM110 which you created in LVF070WAM - Snapping in a Real WAM Web Filter.

2.  Make these changes to the code:

a.  Change the GROUP_BY command to include the #DEPMENT and  #SALARY field:

Group_By Name(#XG_Ident) Fields( #EMPNO #SURNAME #GIVENAME #DEPTMENT #SALARY)
 

b.  Locate Select Fields(#XG_Ident) command and change the AddtoList statement to set alpha column 1 and numeric column 1:

* Add instance details to the instance list
Invoke #avListManager.AddtoList Visualid1(#EMPNO) AKey1(#EMPNO)
Visualid2(#Surname) AColumn1(#Deptment) NColumn1(#Salary)
 

3.  Compile your changed WAM.

4.  If your Web server is on an IBM i, check in and compile your changed filter to the IBM i .

5.  Restart the Framework and test the result.