12 Replies Latest reply: Apr 13, 2015 8:29 AM by anbu cheliyan RSS

    script to get the record related to min date for each type(non key field) using QV builtin functions

    Sri Priya

      Hello All,

       

      PFB th scenario.

       

      Table 1
      ObjectDateType
      O1D11
      O2D21
      O3D32
      Table 2
      ArticleObject
      AO1
      AO2
      BO1
      BO3
      Join
      ArticleObjectDateType
      AO1D11
      AO2D21
      BO1D11
      BO3D32
      Required
        result
      ArticleObjectDateType
      AO1D11
      BO1D11
      BO3D32

       

      whenever an article has the same Type, the For each article, the Type with the minimum date is to be retained and the rest are to be excluded.

       

      Could you please suggest how this can be achieved in script, without using a group by and by using QV functions.

       

      Thanks!