3 Replies Latest reply: Sep 11, 2016 1:33 PM by Stefan Wühl RSS

    To Bring Values Only For Minimum Dates

    umar khan

      Hi,

       

      I have an issue where I need to bring the field values only for the minimum dates. ie, values with multiple associated dates have to show only the minimum date and the rest need to be eliminated.

       

      As seen in the image below, the segment "0248-002-TIA" appears for both the dates "25-1-2016" and "12-7-2016". This needs to be limited to only the row for date "25-1-2016" .  The Date "12-7-2016" should be eliminated.

       

      Capture.PNG

       

      This can be achieved through front end expression like " only({<Date = {'$(=min(Date))'}>} Segment) " , but I have to achieve this through script.

       

      Help will be much appreciated !

       

      Thanks,

      Umar