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



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 ?    14 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 ?    0 Yes 0 No

Post New Answer



More PeopleSoft HRMS Interview Questions

What are the possible hr business tractions that can follow post termination action row for an employee in job data?

0 Answers  


What is the most important Record in PS HRMS?

8 Answers  


How do you administer country codes?

0 Answers  


What is search/match?

0 Answers  


What are the different components and component interfaces in peoplesoft hrms?

0 Answers  






How do you modify security trees?

0 Answers  


What is a control table in peoplesoft hrms?

0 Answers  


What is the purpose of personal data refresh process?

0 Answers  


When a user logs into ps by virtue of which security attribute does the system default users country, name format and company etc?

0 Answers  


What is person or position structure in peoplesoft hrms?

0 Answers  


How to run the sqr in command prompt.

0 Answers  


What are the different kinds of organizational relationships in hrms? Explain each with relevant examples?

0 Answers  






Categories
  • PeopleSoft HRMS Interview Questions PeopleSoft HRMS (83)
  • PeopleSoft Financials Interview Questions PeopleSoft Financials (27)
  • PeopleSoft Administration Interview Questions PeopleSoft Administration (181)
  • PeopleSoft Tools Interview Questions PeopleSoft Tools (176)
  • PeopleSoft Interfaces Interview Questions PeopleSoft Interfaces (58)
  • Internet EBusiness Interview Questions Internet EBusiness (19)
  • PeopleSoft Implementation Interview Questions PeopleSoft Implementation (142)
  • PeopleSoft General Interview Questions PeopleSoft General (385)
  • PeopleSoft AllOther Interview Questions PeopleSoft AllOther (60)