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 ...
Views
Sign in to react to this post
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.

Sign in to react to this post
jaread83's avatar
jaread83
Champion
7 years ago

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

Sign in to react to this post
  • 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.

    Sign in to react to this post
    • 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.

      Sign in to react to this post