How to retrive the data from 3rd scroll, using traversing.
any one can help with the clear syntax
- 4 Answers
- 23599 Views
- Amtex, Satyam, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
How to run the sqr in command prompt. What are the parameters that are used for running the sqr from command prompt?
What are the different kinds of organizational relationships in hrms? Explain each with relevant examples?
What is a control table in peoplesoft hrms?
In which scenarios can a person hold multiple jobs?
What’s the difference between person or position?
How to access an hcm component?
How do you setup search/match?
Please help me , I wan Peoplesoft training institue in Pune,?
In which situation will an employee need to have more than one employee instances with an organization? Explain with an example?
How do you modify security trees?
How to run the sqr in command prompt.
I want information about the peoplesoft freshers recruitment? Please the details
PeopleSoft HRMS 
