4 Replies Latest reply on May 21, 2013 11:36 AM by Marcelo Konatu

    How to get the latest comment of a giving opportunity?

    Marcelo Konatu

      Happy Monday!

       

      I have an opportunity table that relates to a comment table in a 1:N relationship. The opportunity might or might not have a counterpart on the comment table so I retrieved the records using a left outer join.

       

      What I would like to do is to retrieve (if available) the last comment of an opportunity.

       

      Thanks,

       

      Marcelo.