I have a situation like one manager can have multiple learners under him. each

I have a situation like one manager can have multiple
learners under him. each learner will registered for more
than one certifications . their statuses for different
courses like completed, inprogress, dropped, no
certifications.

the question is i have check for each user for statuses if
he had some completed certifications i have to get latest
completed date and omit all other stauses. if he had no
complete staus then i have to get latest inprogress record
based on date. like this i have to select only one record
for user.

but i am getting one row for each status. among all
completion status one record, for all inprogress one
record, for all dropped status one record. how can i show
only one record

Question Posted / av_deepu

0 Answers
1910 Views
Flextronics, I also Faced
E-Mail Answers

No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Business Objects Interview Questions

Report have 10000 records,how to restrict the end user to 1000 Records?

6 Answers

1. What is difference SAP BW, SAP BI and SAP BOXI integration? 2. Which is good for carrier wise? 3. Which is latest one (BW/BI/SAP BOXI Integration)?

2 Answers TCS,

Explain about derived tables?

2 Answers Cap Gemini,

Difference between Object varification and validation

1 Answers Cognizant,

Example of how the fantraps and chasm traps works?

1 Answers IBM,

I have scheduled a weekly report to client. If the data is Over which client wanna receive what will happen?

2 Answers Rolta,

How do u get requirement from the client? in what format?

1 Answers TCS, Wipro,

i want to creat 2way drilling using hyrarchies and hyperlinks...can anyone please help me