How to retrive the data from 3rd scroll, using traversing. any one can help wi

How to retrive the data from 3rd scroll, using traversing.
any one can help with the clear syntax

Question Posted / sangeetha

4 Answers
23684 Views
Amtex, Satyam, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to retrive the data from 3rd scroll, using traversing. any one can help with the clear syntax..

Answer / kaerthikeyan

Local Rowset &rs, &rs1,&rs2;
&rs = GetLevel0()(1).GetRowset(Scroll.record(LEVEL1));
For &i = 1 To &rs.ActiveRowCount
&rs1 = &rs(&i).GetRowset(Scroll. Record (LEVEL2));
For &j = 1 To &rs1.ActiveRowCount
&rs2=&rs1(&j).getrowset(scroll.record (LEVEL3));
For &k=1 to &rs2.activerowcount
&year = &rs2(&k). Record(LEVEL3).FieldName.Value;
WinMessage(&year);
End-For;
End-For; End-For;

Is This Answer Correct ?

15 Yes

1 No

How to retrive the data from 3rd scroll, using traversing. any one can help with the clear syntax..

Answer / devipriya

getlevel0.getrow(1).getrecord(record.level1record)getrow(2).
getrecord(record.level2record)getrow(1).
getrecord(record.level3record);

Is This Answer Correct ?

14 Yes

8 No

How to retrive the data from 3rd scroll, using traversing. any one can help with the clear syntax..

Answer / alekhya

getlevel0.getrow(1).getrecord(record.level1record)getrow(2).
getrecord(record.level2record)getrow(3).
getrecord(record.level3record);
The above answer is for to retrieve the 3rd scroll recoed
level data only.

If u want the field level information use below syntax
getlevel0.getrow(1).getrecord(record.level1record)getrow(2).
getrecord(record.level2record)getrow(3).
getrecord(record.level3record)getfield(field.fieldname);

Is This Answer Correct ?

8 Yes

4 No

How to retrive the data from 3rd scroll, using traversing. any one can help with the clear syntax..

Answer / venkatesh

&LEVEL0 = GetLevel0();
&LEVEL0_ROW = &LEVEL0(1);

&LEVEL1 = &LEVEL0_ROW.GetRowset(SCROLL. STDNT_CAREER); /*it will loop every career*/
For &I = 1 to &LEVEL1.ActiveRowCount
&LEVEL1_ROW = &LEVEL1(&I);
&LEVEL2 = &LEVEL1_ROW.GetRowset(SCROLL. STDNT_ACAD_PROG);
For &J = 1 to &LEVEL2.ActiveRowCount /*it will loop every program under career*/
&LEVEL2_ROW = &LEVEL2(&J);
&RECORD = &LEVEL2_ROW. STDNT_ACAD_PROG;
&FIELD = &RECORD.Descr;

Is This Answer Correct ?

1 Yes

0 No

Post New Answer

More PeopleSoft HRMS Interview Questions

What are tablesets and setids in peoplesoft hrms?

0 Answers

What is the diffrence between Transaction table and setup tables.

2 Answers HCL,

How do you setup search/match?

0 Answers

What is job family? How is it different from job codes in ps?