6 Replies Latest reply: Sep 26, 2016 1:40 PM by Sunny Talwar RSS

    Max of a field

    Anam Azmi

      Dear All,

       

      I have a requirement where i have to show only one record(row) based on the last PO Approver Field and where SEQUENCE_NUM is maximum per Requisition. In the below case  the sequence no should be 6 and PO approver should be Mr. Raju P S . How can i acheive this in front end.

       

        

      Org NamePO NumberLine NumPO Creation DatePO Approved DateReq NoBuyer NamePO ApproverSEQUENCE_NUMSupplier NameItem Code
      F05 Fal-Sahibabad-Eng-Meat-Org1.816E+09105-06-201618-06-20161.816E+09Mr. Raju P SMr. Mohammed Abdul Haq4NP CHEM TREAT ENGINEERING CO.L02100401009
      F05 Fal-Sahibabad-Eng-Meat-Org1.816E+09105-06-201618-06-20161.816E+09Mr. Raju P SMr. Raju P S6NP CHEM TREAT ENGINEERING CO.L02100401009

       

      Any help would be much appreciated.

       

      Many thanks,

      Anam