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)
3 years ago

Hello:

Have you tried using page_size via APIv1?  You can couple that with sorting similar to below and it will limit the returned results to the most recent earned <PAGE SIZE> badges.

/restapi/vc/users/id/<USER-ID>/badges?page_size=<INTEGER>&user_badges.sort_order=earned_date_desc

Here is a link to the badges API 

https://devdocportal.khoros.com/t5/Community-API-v1-Reference/bd-p/restv1docs?section=commv1&leaf-id=User.badges#User.badges

Hope that is helpful.

Roger

 

  • octavian_krody's avatar
    octavian_krody
    Guide
    3 years ago

    Is there any way of doing this with liql or v2? as we would prefer not to enable v1 access just for this use case.