Forum Discussion
JavidH
3 years agoKhoros Staff
charlesssgraham You can add your query ("SELECT id, login, email, rank.name, rank.simple_criteria.role.id FROM users") to a custom component in studio using the below API V2:
<#assign query = restadmin("2.0","/search?q=" + "SELECT id, login, email, rank.name, rank.simple_criteria.role.id FROM users"?url).data.items/>
<#list query as q>
${q.id}
${q.login}
${q.email}
${q.rank.name}
<#if q.rank.simple_criteria.role?? && q.rank.simple_criteria.role.id??>
${q.rank.simple_criteria.role.id}
</#if>,
</#list>
Then you can add this custom component to your desired page in your community in studio.
Hope this helps.
charlesssgraham
3 years agoContributor
This absolutely helps! Thank you for your reply!