Forum Discussion

Suchith's avatar
Suchith
Ace
7 years ago

How to fetch Users Data based on Sort or Order by id Using V2 API.

Hi,  I have couple of question regarding Fetching User Data using V2 API. In my use case. I want to fetch all the registered user from community. For this, I am getting total count of user and ...
  • VikasB's avatar
    VikasB
    7 years ago

    Suchith

     Most of the user's field does not exist for object 'users' as a sort constraint, not even id. But you can sort it by registration time. It would work in an expected way. 

    select * from users order by registration_data.registration_time desc

    When you increment the offset each time, it would not fetch the same result again. 

VikasB's avatar
VikasB
Boss

Suchith

 Most of the user's field does not exist for object 'users' as a sort constraint, not even id. But you can sort it by registration time. It would work in an expected way. 

select * from users order by registration_data.registration_time desc

When you increment the offset each time, it would not fetch the same result again. 

  • VikasB's avatar
    VikasB
    Boss
    7 years ago

    Suchith

    Yes, login constraint will also work here with user API.  Both the APIs will resolve your duplicate entry problem.

     

    1. Order By login ascending 
      It will sort the results alphabetically.  i.e. Alan, Bob, Caty etc

    2. Order by registration_time ascending
      It will sort the results by ids i.e.  1,2,3,4