0 Replies Latest reply: Dec 12, 2016 3:41 PM by DANIEL ARAUJO RSS

    Filter row values in table

    DANIEL ARAUJO

      Hi All

       

      Ive got a table in the following format:

       

      IDSTATUSPendingDone
      1Pending1
      1Done11
      2Done1
      3Pending1
      3Done11
      4Peding1

       

      It means: In the beggining of the day, the pending activities are shown in the table and we will only have one row per ID (Status = Pending - like row number 1). If the activity is done, then another row of the same ID is created (like row number 2).

       

      It is possible to do an activity that wasnt on the list in the begging of the day, so it will be shown in the table like row number 3 (ID = 2).

       

      What I want is: A list of every activity that is pending in the begging of the day and was not done yet.

       

      Thx in advance!