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