Forum Discussion

octavian_krody's avatar
octavian_krody
Guide
3 years ago

How to retrieve all user badges using LIQL search on the user collection?

Hello, Do we need pagination for that field? or does it output all user_badges available for the user in one shot? I'm aware that liql queries can add a limit / offset (up to 1000 entries), or us...
API
REST API v2 & LiQL
  • RogerW's avatar
    RogerW
    3 years ago

    Hello:

    Unfortunately, in LiQL while it is possible to obtain all of the badges for a user with something like the below query, it won't allow the use of LIMIT for that field or ORDER BY.  

    select user_badges from users where login=<USER_LOGIN>

    You will get all the badges for a user, but you are correct that this particular nested field cannot be paginated.

    Thank you,

    Roger

RogerW's avatar
RogerW
Khoros Alumni (Retired)

Hello:

Unfortunately, in LiQL while it is possible to obtain all of the badges for a user with something like the below query, it won't allow the use of LIMIT for that field or ORDER BY.  

select user_badges from users where login=<USER_LOGIN>

You will get all the badges for a user, but you are correct that this particular nested field cannot be paginated.

Thank you,

Roger

octavian_krody's avatar
octavian_krody
Guide
3 years ago

Thank you Roger!

As long as we get them all pagination is of no concern, as we don't have that many to begin with.