1. Create a new WAM:
   
        Name: iiiDspEmpDocs
        Description: Display Employee Documents
        Layout Weblet: iiilay01
   
2. Define your WAM based on the following logic:
   • Map field STDRENTRY for *both as a *hidden field
   • Define a Group_by, EMPDATA for fields EMPNO, SURNAME, GIVENAME, ADDRESS1, ADDRESS2, ADDRESS3, POSTCODE, DEPTMENT and SECTION.
   • Define a working list DOCLIST, containing fields DF_ELFNAM and PRIFILRRN.
     
     PRIFILRRN should be a hidden field.
     
     
   • Define a WebRoutine BEGIN
   • Map field EMPNO for *both
   • Map fields FULLNAME, ADDRESS1, ADDRESS2, ADDRESS3, POSTCODE, DEPTMENT and SECTION and list DOCLIST for *output. These fields should have a display attribute of *output.
   • If STDRENTRY = S

     -  Clear list DOCLIST -  Fetch fields for group_by EMPDATA from file PSLMST with the key EMPNO -  FULLNAME = GIVENAME + ', ' + SURNAME -  Select field DF_ELFNAM from the file DXDOCS with the key 'DEM_ORG_SEC_EMP', DEPTMENT, SECTION, EMPNO and return relative record number to PRIFILRRN               Add entry to DOCLIST -  End of select

   • End of if
   • End of routine
   • Define a WebRoutine SEND_DOCUMENT with a Response keyword of #HTTPR
   • Map for *input field PRIFILRRN
   • Fetch field DX_ELBLOB from the file DXDOCS with the relative record number PRIFILRRN.
   • Set #HTTPR property ContentFile to #DXELBLOB.FileName
   • End of routine

     Note: The field DX_ELBLOB returns the file into a local temporary directory, using an 8.3 filename. For example: C:\DOCUME~1\pcuser\LOCALS~1\Temp\lobuser\pcuser\5152\dxdocs\dx_elblob\contract.pdf This path may be defined by the LPTH=directory run time parameter. If the LPTH parameter is not defined, the path used will be the TPTH setting. The default value for this path is the user's temporary path, for example: C:\Users\John\AppData\Local\Temp This can be quickly found using %temp% in the Explorer address bar.

     
     For further information, refer to the X_RUN Parameter Summary in the Technical Reference Guide.
     
     
3. Compile iiiDspEmpDocs and open the WebRoutine BEGIN in the Design view. It should look like the following:
   
   
   
   
4. Drop a Push Button weblet alongside the employee number field.
   Set up the push button properties:

   Property	Value
   Caption	Details
   On_click_wrname	BEGIN
   submitExtraFields	Field Name: STDRENTRY
   	Literal value: S

5. Save your changes.
   
   
6. Select the column heading "Document long file" and delete it.
   Type in a new the column heading "Employee Documents".
   You may need to click somewhere else in the layout, to refresh the column heading with your changes.
   
   
7. Save your changes.     Your design should look like the following:
   
   
   
   
8. Drop an Anchor weblet into the file name column of the list (the left hand column). Ignore the increase in width of this column. At run time it will display with the width of the actual file names.
   Set up the Anchor weblet properties:

   Property	Value
   Currentrowhfield	PRIFILRRN
   Currentrownumval	$PRIFILRRN
   On_click_wrname	SEND_DOCUMENT
   Show_in_new_window	True

   
   Save your changes.
   
   
9. Execute and test your WAM in the browser.
   
   
   1. Enter employee number A0070 and select the Details push button. Your web page should look like the following:
      
      
      
      
   2. Select one of the documents shown in the list. The document should be displayed in a new browser window.
      
      

Continue at Step 4. Enhance Appearance of the Documents List (Optional).