JavidH
Khoros Staff
Joined 4 years ago
User Profile
User Widgets
Contributions
Re: How to Install the Lithium Community SDK on Windows
Hello Folks, I have created a guide for how to install the SDK on windows operating system based on the Ideas shared here. I have consolidated those as a guide. Guide Link:https://developer.khoros.com/khoroscommunitydevdocs/docs/install-the-khoros-community-sdk-on-windowsRe: Access LiQL JSON with JavaScript?
Create a custom endpoint (I'm naming it as q) in the studio: <#assign query= restadmin("2.0","/search?q=" + "SELECT id, login, email, rank.name, rank.simple_criteria.role.id FROM users"?url).data.items/> ${query} Create a custom component (naming it as component_q) in the studio: <#assign communityId = community.id /> <#assign communityUrl = http.request.url /> <#assign lengthOfDomain = communityUrl?index_of("/") /> <#assign communityDomain = communityUrl?substring(0,lengthOfDomain) /> ${communityUrl} ${communityId} <@liaAddScript> ;(function($){ $.ajax({ type:"POST", url:'${communityDomain}/plugins/custom/qa/johndowden/q', contentType: 'application/json', success: function(res) { console.log(res); console.log("Results are listed"); }.bind(this), error: function(xhr, status, err) { console.error(xhr, status, err.toString()); console.log("Unable to view the results"); }.bind(this) }); })(LITHIUM.jQuery); </@liaAddScript> Note:The URL must be your community URL of the endpoint in the studio. When you add thecomponent_qto any page in your community using studio, you can view the results in the console. Hope this helps. If this answers your question, would you please mark it as an accepted solution.Re: Access LiQL JSON with JavaScript?
charlesssgrahamYou 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.
