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
.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.