Hello,

i have want only last five record by date from table. i want to fetch last five applied job.

so i have done work like below :

from my class :
 public JobapplicationCollection GetLastFiveAppliedJobs(int CandidateID)
        {
            JobapplicationCollection AppliedJob = new JobapplicationCollection();
            IPredicate JobFilter = (JobapplicationFields.CandidateId == CandidateID);
            AppliedJob.GetMulti(JobFilter, 0, new SortExpression(JobapplicationFields.DateApplied | SortOperator.Ascending));
            return AppliedJob;
            
        }


in my c# code:

JobapplicationCollection lastJobs = new JobapplicationCollection();
                    lastJobs = LastFive.GetLastFiveAppliedJobs(CandidateID);
                    GridView1.DataSource = lastJobs;
                    GridView1.DataBind();

so how can i do this for only last five record. this code will return all the rows.but i need only five record. i am using self servicing and my database in MYSQL

Set the parameter that controls the number of rows to return to 5 - it should be the value that is currently set to 0 in your GetMulti call.

Matt

MTrinder wrote:

Set the parameter that controls the number of rows to return to 5 - it should be the value that is currently set to 0 in your GetMulti call.

Matt

Thanks MTrinder, works great but i need only last five record. it gives first five records

You should be sorting Descendlingly instead of Ascendingly.

Walaa wrote:

You should be sorting Descendlingly instead of Ascendingly.

hi walaa,

Thanks for ur reply. i had done before Descending , on that time i was wrong to see my output, but it was working.

Thanks for reply.