10 Replies Latest reply: Sep 30, 2014 5:47 AM by Zhihong He RSS

    Issue with firstsortedvalue

    Sindhu Neelisetty

      Hi Friends,

       

      I'm struck with some issue related to firstsortedvalue.

       

      I wrote a statement in my script like

       

      firstsortedvalue(ID,-Time) as UserID----- This statement will return the id of the user based on the latest time.

      firstsortedvalue(ID,Time) as UserID--- This statement will return the id of the user based on the earliest  time.

       

      But what I want is all the users who has done some particular task based on my where clause.

      so I also tried just

      ID as UserID--- But it is giving me all the data, wrt other users also.

       

      Can you help me in this.

       

      Thanks,

      Sindhu