How to retrive the data from 3rd scroll, using traversing.
any one can help with the clear syntax
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 |
What are prompt tables in peoplesoft hrms?
What are the different components and component interfaces in peoplesoft hrms?
What are checklists? Give an example from the delivered checklists. How will you create a checklist of your own? Explain by giving an example?
In which scenarios can a person hold multiple jobs?
What are tablesets and setids in peoplesoft hrms?
What are the options in people soft to setup the hierarchy?
What is the difference between traction table and setup tables?
What is your understanding of peoplesoft hrms system data regulation?
What is person or position structure in peoplesoft hrms?
What is peoplesoft enterprise hrms integrations?
How to run the sqr in command prompt.
Please help me , I wan Peoplesoft training institue in Pune,?