mcalcaterra
Khoros Alumni (Retired)
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: Custom Component Number of experts online
Hi waldemarhelm something like this will print out a list of the ids of users that have the administrator role with a link to their profile page <#assign admins = (liql("SELECT id, online_status, href FROM users WHERE roles.id='t:Administrator'").data.items)![] /> <#list admins as admin> <#if admin.online_status = 'online'> <a href="${admin.href}">${admin.id}</a> </#if> </#list> you should be able to use this as a base template and query for the avatars as well and display that instead of the ids. Keep in mind this will return 25 users, you can increase/reduce the limit as needed221Views2likes2CommentsRe: API Help: Recent Topics (but only for subscribed boards?)
Hi keithkelly, you should be able to gather a user's subscriptions using API v2.0 https://developer.khoros.com/khoroscommunitydevdocs/docs/subscriptions Examples: SELECT * FROM subscriptions will return the current user's subscriptions, or you can also search for a specific user's subscriptions by using: SELECT * FROM subscriptions WHERE subscriber.id = '<user.id>' (replace '*' with the specific fields you want) Or if you prefer using API v1 there's this call https://devdocportal.khoros.com/t5/Community-API-v1-Reference/bd-p/restv1docs?section=commv1&leaf-id=User.subscriptions#User.subscriptions107Views0likes0Comments