Row Traversing




&LEVEL0 = GetLevel0();                            --level zero Rowset
&LEVEL0_ROW = &LEVEL                                          --Level Zero  Row
&LEVEL1 = &LEVEL0_ROW.GetRowset(SCROLL.EMPL_CHECKLIST); 
             --level1 Rowset

For &I = 1 to &LEVEL1.ActiveRowCount                                 --for loop to get all the values till current row
   &LEVEL1_ROW = &LEVEL1(&I);
   &LEVEL2 = &LEVEL1_ROW.GetRowset(SCROLL.EMPL_CHKLST_ITM);
   For &J = 1 to &LEVEL2.ActiveRowCount
        &LEVEL2_ROW = &LEVEL2(&J);
        &LEVEL3 = &LEVEL2_ROW.GetRowset(SCROLL.EMPL_CHKLST_ITM_1);
        For &k = 1 to &LEVEL3.ActiveRowCount
                &LEVEL3_ROW = &LEVEL3(&k);
               &RECORD = &LEVEL3_ROW.EMPL_CHKLST_ITM_1;              --get record
               &Emplid = &RECORD.emplid.value;                       --get value
               Winmessage(“Employee ID: “|&Emplid);                  --to display all retrieved employee IDs online
        End-For;
   End-For;
End-For;
SHARE

peoplesoft

  • Image
  • Image
  • Image
  • Image
  • Image
    Blogger Comment
    Facebook Comment

0 comments:

Post a Comment

Phaniraavi@gmail.com