Forum Discussion

jaread83's avatar
jaread83
Champion
7 years ago

Online users API V2 call brings back duplicates

I am trying to bring back a list of all online users using the V2 api but when trying it out on the live environment, it shows a lot of duplicates - possibly other browser sessions? Not sure. Is it ...
jperk's avatar
jperk
Expert
7 years ago

We had a similar problem when retrieving all users. It was resolved by specifying an ORDER BY. It seems that's the only way to avoid duplicates.

jaread83's avatar
jaread83
Champion
7 years ago

Hi jperk, that's interesting - what did you order by?

  • jperk's avatar
    jperk
    Expert
    7 years ago

    We used "registration_data.registration_time" but I think any of the items in the Sorts table would work.

    • Parshant's avatar
      Parshant
      Boss
      7 years ago

      jperk, Unfortunately, Its not worked for me. I tried with "ORDER BY" for all of the sort fields. its still giving online_status of same user 16 times in request for one of the community.