dynamic change when changing freemarker variable ?
Hello everyone, kindly, how should I change the content of freemarker variable dynamically? when clicking on the button the id of the macro change so the displayed question changes how could I achieve this? <#macro question questions id> - name is ..... ${questions[id].name} - Question is ...${questions[id].text} - next question is .. ${questions[id].next} <button onclick="changeContent(id = ${questions[id].next})"></button> </#macro> <@question questions=q.questions id="q1"/> q = <questions> <q1> <name>who?</name> <text>who are you ?</text> <next>q1</next> </q1> <q2> <name>how</name> <text>how are you ?</text> <next>q1</next> </q2> </questions> kind regards, Shery RaniaWaelSolved778Views0likes2CommentsError: Cannot find module 'object.defaults'
Hi All, I am getting te below error while executing li export-studio-plugin. module.js:478 throw err; ^ Error: Cannot find module 'object.defaults' at Function.Module._resolveFilename (module.js:476:15) at Function.Module._load (module.js:424:25) at Module.require (module.js:504:17) at require (internal/module.js:20:19) at Object.<anonymous> (/root/.npm-global/lib/node_modules/gulp/node_modules/undertaker/lib/tree.js:3:16) at Module._compile (module.js:577:32) at Object.Module._extensions..js (module.js:586:10) at Module.load (module.js:494:32) at tryModuleLoad (module.js:453:12) at Function.Module._load (module.js:445:3) Thanks in advance, DbabyDenizbaby5 years agoGuide188Views0likes5CommentsTurn off ability to delete a private message
Is there a way to turn off user's ability to delete private messages in Community? Moderators need to be able to see user's PMs for abuse reports, but if they were deleted it looks like we'd have to file a support ticket to recover deleted PMs. We'd prefer to not let users have the ability to delete their PMs.SolvedLindsey5 years agoLeader1.9KViews1like5CommentsGet Facebook public tagged posts?
Hello, Is there a feature that enables us to get all Facebook public posts with a page tagged in it? If there is no such a feature can we add such functionality by integrating Facebook's GraphAPI tagged call? Thanks in advance.AhmedDyaa5 years agoAdept601Views0likes0CommentsBULK Data API issue : unable to get output .
A week before I was aple to pull data from BUlk data api with basic ajax call var connectionUri = 'Community URL?fromDate=20200427&toDate=20200428' var dataToReturn = []; var xhr = $.ajax({ url: connectionUri, dataType: 'json', headers : { 'client-id':client_id }, beforeSend: function (xhr) { xhr.setRequestHeader ("Authorization", "Basic " + btoa(username + ":" + password )); xhr.setRequestHeader ("Accept","application/json"); //xhr.setRequestHeader ("Content-Disposition","attac"); }, success: function (json) { Now I am getting error as Cross-Origin Request Blocked: The Same Origin Policy disallows reading the remote resource at BULK DATA URL. (Reason: CORS header ‘Access-Control-Allow-Origin’ missing). Also when i tested this in post master i get this as output : SyntaxError: JSON.parse: unexpected keyword at line 1 column 1 of the JSON data One observation though I was getting CSV output when i requested the bulk data api . Now the content seems to have changed. Please let us know if anything has changed at source and do we need to handle code accordinglyRing_Test5 years agoContributor169Views0likes4CommentsDelete an SDK @override Component?
How can I delete an OOTB override component ("/res/components/badges-list@override.ftl") that was created with the SDK so that it gets deleted from the server when I "li submit-plugin"? Just removing it from the file system doesn't seem to work, and I can't find a way to do it from within the Community Admin on the Studio > Components page. I have two components now that are "stuck" in override mode because I haven't found a way to delete them. Thanks, MatthewSolved2.4KViews0likes2CommentsHow to subscribe a user to board as admin through API
I have to subscribe users to boards on behalf of them using API. How can I do it? Below API is not working. https://community.lithium.com/restapi/vc//boards/id/Collaboration/subscriptions/subscriptions/users/self/add?subscription.type=email&users.id=44&restapi.session_key=JZUCbfEGy-v_ChwWWogVF1M85Ya7dtt6aQL8YT0hllo. How can I achieve this?296Views0likes7CommentsIs there a list of quilt URLs anywhere?
Hi Khoros This has been bugging me for ages. I want to look at a quilt on our Staging site to see what it does, and if it will serve a useful purpose for our site, but I can't find it because I don't know the URL or pathway to get to it. For example, what does theSearch Experiments Page look like/do and/or how do you get to this page? I have foundhttps://community.khoros.com/t5/Community-FAQs/Khoros-Platform-URLs/ta-p/32509but this doesn't give me the URL to all quilts. Is there doco that tells me the URL and/or the pathway to get to an OOTB quilt?PAULEM5 years agoAdvisor403Views1like2Commentshow to change the component dynamically?
Hi, Excuse me, I am new to khoros. I just want to know, how could I achieve this following situation? I have a component which consists of question and some answers, by choosing one answer; the question and the set of answers changed based on the chosen answer. so the question is how should I get the other question should I call external API to a hosted backend? should I save this in save this data somewhere in the community, so I get this data from the community ? if this is the answer how ? is it actually possible to change the component content based on the api result each time? Thanks in Advance, SheryRaniaWaelSolved1.1KViews0likes1CommentDatabase and backend implementation
Hello, Excuse me, I have a few questions: Can I connect khoros community to a database and call this database using LIQL? if yes, which DBMS is supported the most? Can I write the backend logic using the freemarker in khoros or is it better to have a hosted backend (python) and call the API from khorous using the free marker? Thanks in Advance, SheryRaniaWaelSolved1KViews0likes1Commentstyling an overriden page
Hi all, I've created some page overrides for our Group Hub areas within community. The main difference is we'll be using labels with Group Hubs, this is something we don't currently use with discussion boards so I need to be display different components etc. Having created a page override I was hoping the standard CSS class for the page might have changed, but it's the same as the base page. The CSS hides some elements in the base page which I want to unhide in the overridden page, so I was hoping for a quick way to do this via a different page class. Has anybody done similar? I found an article to add a custom body class via JS, but I'd rather stick to a pure CSS solution and not add more JS since I'm trying to optimise page load currently. TIAKev_B5 years agoAdvisor307Views0likes0CommentsRest API Outside Community
Hi all, I just have a few questions regarding the REST API is it allowed to integrate with CSS libraries like bootstrap? is it allowed to call api from outside the community ex. i have a hosted backend and need to call api from the backend to get data and display it? is it allowed to call API inside inline JS? RaniaWael Thanks in AdvanceSolved1.1KViews0likes1CommentAdd multiple tags to a message with a single API call?
Can anyone tell me if it is possible to add multiple tags to a message with a single API call, or if they have to be added one-by-one with a separate API call for each? Looking at the v2 subcollection documentation it shows the payload for tags like this: { "data": { "type": "tag", "text": "something" } } This works fine for me and I'm able to add a single tag to a message via the API without issue. However, what about when I want to add multiple tags? In my experimenting I tried performing the POST request using the JSON syntax below (wrapping multiple entries in a list/array) but, while it returned a "success" response, the tags did not get added to the message. This is the syntax I used: { "data": [ { "type": "tag", "text": "tag1" }, { "type": "tag", "text": "tag1" } ]} } This is the response I received: { "status": "success", "message": "", "http_code": 200, "data": {}, "metadata": {} } Any idea on what I could be doing wrong? Thanks in advance!Solved1.1KViews0likes2CommentsCan I modify page header code for each community category?
Hello, I have created a country-specific category under my community. And I wonder if I could modify the <head> code for each category. I want to insert different header codes for each category (here in my case, it will be “country”) If it is possible to do so, I will be using it when I plant a 3rd party analysis tool. Thank you in advanceSolvedShellKim5 years agoAdept1KViews0likes1CommentAPI for "Hide messages in this board from lists"
Community Admin Structure has the node setting to "Hide messages in this board from lists": I can't find this property exposed in any way on the messages collection. This resulted in content from such nodes being unexpectedly exposed in activity components. Any way to query - ideally even filter - messages from nodes with this setting enabled? NB: The "Hide from lists and menus" is exposed via the board.hidden property on the message collection. Cannot be used in the LiQL WHERE clause though.578Views1like2CommentsWhere do I store a large amount of data, for reference?
Hi folks, planning a custom component which will basically check the user's id against a pre-existing list. I imagine this list could grow into the thousands. What are my options for storing this data/list? One option I use for smaller datasets is a hidden post and simply store it as a comma separated string. Another option might be to store a string in a custom metadata field, I guess? Any ideas how large that could be? (I don't have access to a separate server.)739Views2likes5CommentsUser Badges count
Hi, i'm trying to get a badge count number for our community users, lets say I would like to find out how many users in the community have 10 badges. I've tried several APIv2 calls, however i couldn't get any data. Most probably the calls were not correct. I was wondering if someone can point me in a right direction, thanks!451Views0likes0CommentsMove a message programmatically to a different board
thanks, trying the below to move the message. I looked at v1 and v2 calls and neither are working. The error message I get for the call below is the second snippet. I couldn't find any specific documentation for how to move a message. Any advice please? 1st snippet <#assignpathConstruct="/messages/${messageId}"/> <#assignmessagePostCall=restBuilder().method("PUT").path(pathConstruct).body({"board":{"id":"UserReportedSpam","type":"board"}}).admin(true)/> <#assignuserCanRemovePost=true/> <#assignresp=messagePostCall.call()/> 2nd snippet InMemoryObjectInstanceTemplateModel{entity=InMemoryObjectInstance [fieldMap={http_code=null, data=InMemoryObjectInstance [fieldMap={code=303, developer_message=messages is not a valid collection name (for the objectKey: ObjectKey[board(version: 1)]), more_info=, type=error_data}, object=ObjectKey[error_response_data(version: 1)]], message=board is not a valid object for the messages collection., status=error}, object=ObjectKey[error_response(version: 1)]]}Solvedbrowneandrae5 years agoExpert1.2KViews0likes1CommentSetting cookie attributes (expiration/domain) in page init
I'm able to create a new cookie on page init with ${http.response.addCookie(http.request.createCookie("name", "value"))} while this doesNOT work (but is also stated in the docs, slightly confusing =D): ${http.response.setCookie(http.request.createCookie("name","value"))} SuzieHsee section "http.request.createCookie("name", "value")" and there the example (which is the above code), this does not work, it needs to be addCookie(), not setCookie(). The cookie that is created has some attributes, mainly an expiration date and a domain to which it is scoped, I could not find anything in the docs or community that would tell me how to configure the cookie's attributes,SuzieHcould you dig into your internal docs (or dev brains) and see if that is even possible? E.g. something like: http.request.createCookie("name","value").setExpiration(<maxage in seconds>).setDomain('*.somedomain.tld') I did try to use the methods for a java servlet httpCookie from: http://docs.oracle.com/javaee/6/api/javax/servlet/http/Cookie.html but with no success, the cookie is not created anymore (can't debug it and do not get any errors because page init...) when I do things like: <#assign cookie = http.request.createCookie("name", "value") /> <#assign cookie = cookie.setMaxAge(3600) /> ${http.response.addCookie(cookie)} // note, it does not make a difference if everything is first assigned to a variable or not...e.g. this doesn't work either =): ${http.response.addCookie(http.request.createCookie("name", "value").setMaxAge(3600))} // tried .setHttpOnly(<boolean>) and .setValue() as well, same result: no cookie is created anymore thanks for clarifying!Solvedluk5 years agoBoss326Views1like4CommentsEpoch Format for current_revision.last_edit_time Not Date-Formattable?
Hello, If I execute the following LiQL query in the API Browser: SELECT post_time, current_revision.last_edit_time FROM messages LIMIT 1 I get the following (abbreviated here) result, which is as I expect, everything looks great: { "data" : { "items" : [ { "post_time" : "2019-11-22T13:06:18.863-08:00", "current_revision" : { "last_edit_time" : "2019-11-22T13:06:18.863-08:00" } } ] } } But in my component, when I use this code to format/display those date/time values: <p>Created ${result.post_time?date} / Last edited ${result.current_revision.last_edit_time?date}</p> The post_time value renders correctly, but for current_revision.last_edit_time, I get the following error: _TemplateModelException:The string doesn't match the expected date/time/date-time format. The string to parse was: "1574456778863". The expected format was: "MMM d, yyyy". The nested reason given follows: Unparseable date: "1574456778863" This value seems to be a Unix timestamp (epoch) since that value maps to "Friday, November 22, 2019 9:06:18.863 PM" which matches the "last_edit_time" in my original query. My questions are: why does the API Browser show a date/time value when my component call torestadmin("2.0","/search?q="... to run the same query returns a timestamp can I format a timestamp like this somehow is this a bug of some sort Any help would be appreciated. Thanks, MatthewSolved1.2KViews0likes2CommentsCSS optimisation / best-practice
Hi everyone, I've been acquainting myself with the Google Search Console more recently, and I'm getting reports about pages being slow to load. A big drain seems to be our CSS resource. We did some redesign work on the community in 2015, and we have a single large file of CSS being served where we've overridden some of the default behaviours and added customisations as time has gone on. This file is now >13k lines long and is the majority of community pages probably use less than 10-15% of the file in one go. I'm just wondering if anybody else has had to deal with bloated CSS contributing to poor performance? I'm considering using smaller CSS files and calling them from specific components, that should allow me to maintain any overrides present and only call the CSS when it's needed. Is that something worthwhile? It's worth noting that a lot of the performance-related bits are JS specific, and that's not directly in my control so I'm trying to fix what I can first. TL;DR - I need to optimise my 13k-line CSS file and I'm contemplating splitting into smaller 'per component' filesKev_B5 years agoAdvisor588Views1like3CommentsWay to distinguish "sender" vs "receiver" in threaded private messages (version 3.1)
In the threaded view of private messages, is there any way to distinguish by class or id which message is what the user sent, and which is the one being received? We are attempting to style the conversation in a "text message bubble" type styling, however this seems to be impossible since there is no way to make this distinction by class or id for which message is being sent or received.SolvedLindsey5 years agoLeader2.1KViews1like4CommentsIs there a way to unpublish a message
I am using the api put method for the messages endpoint to update an individual messagehttps://devdocportal.lithium.com/t5/Community-API-v2-Reference/bd-p/restv2docs?section=commv2&collection=messages. Is there a way to unpublish a message. I already tried is_draft : true in the body for the put method and i get a 200 response but the message is still published.browneandrae5 years agoExpert503Views0likes1Commentroles_to_add/roles_to_remove not working
Hi everyone, I'm developing a python script and using the Khoros python module. Through this module I'm sending a PUT request to the community to either add or remove roles from specific users. My request looks like: comm_url = 'https://community.<company>.com/api/2.0/users/6/' #+ user_id payload = {} payload={"data":{"type":"user","roles_to_add": "Customer"}} headers = {"Content-Type":"application/json"} res = khoros.api.put_request_with_retries(url=comm_url,json_payload=payload,khoros_object=community_name) At first I thought my python or something was wrong (still could be the case), but if I change "roles_to_add" to "biography", the biography gets updated correctly. But anytime I use roles_to_add or roles_to_remove, I get a 200 response back, but can't see any changes. The audit log also shows no changes. I'm onRevision: 20.3 (20.3-release r2005190939) Commit Id: be1c5d989e418530a2eadae02e4bc26cf353f913 Does anyone else have this trouble? Should I use another method to update the roles for a user via a PUT request?SolvedNconforti5 years agoMentor1.1KViews0likes8CommentsjQuery not adding to input field
I have a custom component for the "new post" button that, in some spaces/pages, will add elements to the post URL for tags and labels. I then have another custom component I've added on the New Post page that should, using jQuery, modify the lia-tags and lia-labels fields to add in the values from the URL. It looks something like this: <#assign tags = webuisupport.path.rawParameters.name.get("tags","")/> <#assign labels = webuisupport.path.rawParameters.name.get("labels","")/> <@liaAddScript> (function($) { $(document).ready(function() { $("#lia-tags").val("${tags}"); $("#lia-labels").val("${labels}"); }); })(LITHIUM.jQuery); </@liaAddScript> However, the jQuery does not appear to be doing anything. If I review the source code of the page, I can see my code there complete with the values I passed (or didn't) via the URL. Am I missing anything here?Solvedphoneboy5 years agoDirector2KViews0likes2CommentsAPI call to post message has blank response
Hi folks. Been using this in an endpoint for many years, but now it returns a blank response, so I can't read if it was successful. <#assign result_post = restadmin("/boards/id/${board_id}/messages/post?message.subject=${msg_subject?url}&message.body=${msg_body?url}")/> If, however, I do a simple $.post('/restapi/vc/boards/id/${board_id}/messages/post?message.subject=subject&message.body=body') then I get a perfectly normal response. Did something change with the v1 API?781Views0likes6CommentsHow to access a custom user profile metadata field?
We had asked Khoros support to create as a custom profile metadata a booleanprofile.receive_community_news. I am struggling to access this field via any API though. With the metadata field for messages I know that I could access them via Message.metadata calls in API v1. But I couldn't find an API v2 equivalent, nor an equivalent that works on profile metadata fields I tried this without success ("Field 'profile.receive_community_news' does not exist for object 'settings'."): SELECT profile.receive_community_news FROM settings WHERE user.id = '65' How to access a custom user profile metadata field via community API? Ideally, I would like to get this setting for all members, i.e. a working API v2 call to the users collection would be my preference.665Views1like2CommentsUnable to Authenticate using API V2
Hi, I have the Token and the Client ID for my organisation and able to get the reports from the Bulk API call. But when I try to authenticate via API V2, I get an error that I am not authorised to make this request. Could you please help me with this? I am using the Community Domain for my org as Community.anaplan.com.Solved1.3KViews0likes2CommentsRecaptcha not showing , settings entered correctly
Filled out the recaptcha settings at the community level, but not seeing the box on the registration page or comment page or any other page. I chose the v2 Checkboxrecaptcha when getting the keys from google. Has anyone had success setting this up in their community?browneandrae5 years agoExpert85Views0likes1CommentGet role for every user
Hi everyone, I'm currently trying to create a list of users and each user's role. I can make a call using V2 API to get the list of users, but in the 'roles' field, I only get the query I can use to retrieve that person's role. Right now I make a call using the Khoros python projectto get all of the users, and then have to iterate over each of the users to get the roles assigned to them, which isn't very efficient. Is it possible to make just one call to get a list of users AND the roles at one time instead of having to make hundreds of calls to get the roles? Maybe there's something I'm missing. Appreciate the help!SolvedNconforti5 years agoMentor1KViews0likes4CommentsHow to automate searching for internal notes in Lithium?
Good Afternoon, Developers! I want to know if it's possible to build a tool that would pull all internal notes (for the month) that have specific keywords. For example, now, I need to search all conversations manually to find out if our agents created a Case Management ticket (e.gINC0748534). This can take me hours and hours of manual work, and wasted resources. Is there a way to build a tool/add-on that can pull all conversations that DO NOT contain a noted Case Management ticket? I need to be able to filter these conversations for each individual agent and their handled monthly conversations that do not contain Case Management Ticket since it's a part of our KPIs. Thank you!shawniko5 years agoContributor50Views0likes0Commentsconversation.last_post_time not working?
Hi, I'm trying to use conversation.last_post_time as a constraint in a query but I'm not getting the expected results. The documentation says it can be usedas I constraint:https://community.lithium.com/t5/Developer-Documentation/bd-p/dev-doc-portal?section=commv2&collection=messages#constraints I want to pull a list of threads that were last active during a period of time to archive them, so I'm using this query: SELECT id, board, conversation, view_href, metrics, post_time FROM messages WHERE conversation.last_post_time <= ${endDate} AND conversation.last_post_time > ${startDate} AND depth = 0 AND board.id='${board}' It seems to work, but I'm doing some tests and the results are not accurate. For example If I use this query: SELECT count(*) FROM messages WHERE conversation.last_post_time <= 2011-09-18T23:59:59-07:00 AND conversation.last_post_time > 2011-09-18T00:00:00-07:00 AND depth = 0 AND board.id='ArchivesImprimantes' I get zero results. Here's the screenshot of the response when using API 2.0 directly on the production community on the browser But I know there's a thread that meet the criteria. This is the thread information I get when using the same API 2.0 It would seem as is the query is ALSO checking the original post date and matching it to the daterange. But I don't care about the original post date, I just need the last_post_date. Can someone confirm the actual behavior of the API call? Am I not understanding the documentation? Thanks!fuenteso5 years agoLeader159Views0likes4CommentsKudos leaderbord
I come to an understanding that we have to use rest api v1 to filter kudos on a period of time (one month) on my exemple. I would like to filter my leaderboard by role and exclude some, is it possible ? <#assign top_users = rest("/kudos/authors/leaderboard?max_age=one_month").users /> <#list top_users.user as user> <#assign userAvatar = rest("/users/id/${user.id}/profiles/avatar/url").value /> <#assign userInfo = rest("2.0","/search?q=" + "SELECT view_href, login FROM users WHERE id = '${user.id}'"?url).data.items /> <#assign userKudos = user.mixin.kudos.weight /> </#list>SolvedBekaD125 years agoHelper750Views0likes2CommentsHow to add <noindex> to common widget
Hello, In our search results, the content of the "ForumTopicPage"has repeated with the below content and showing metadata text: "Join Now | Log In | Help Discussion stats 5 replies 2020-03-26, Dates, logo meta tags and breadcrumbs metadata " How can I fix this? How can I add <noindex> to common. widget (Out of the box widget)? I tried to add <noindex> to the header page and custom components and uploaded them to the production. But Still, I am seeing the same metadata in the search results. How to solve this issue? please help. Thanks, Sateesh.isateesh9995 years agoHelper127Views0likes2CommentsDocumentation for Community URL patterns
Is there documentation somewhere for the exact URL rules and patterns on the Community?SolvedLindsey5 years agoLeader112Views0likes2CommentsGlobal replace text in post body
Hi We want to globally change the name we use in signatures within posts (for privacy purposes). For example, I've been using "PaulM" and I'd like to change all instances to "Paul" instead. I realise we should be using the auto-signature block feature in our profiles -- we've switched to this approach -- but is there a way to globally replace "PaulM" with "Paul" in the body of a post or reply? Thanks in advance PaulPAULEM5 years agoAdvisor88Views0likes1CommentEmpty 'metrics' field in API v2 'users' collection
We are trying to pull certain relevant metrics for all of our community users in order to feed them into an external dashboard💹. The majority of the metrics (kudos, solutions, registration date) are directly exposed in the API v2 'users' collection. Some of them - total sign-ins, minutes online, ... - are not to be found there, but it seems they can only be obtained from the 'metrics' collection(E.g. SELECT * FROM metrics WHERE id IN ('logins','minutes_online') AND user.id = '65'). Unfortunately, that doesn't scale nicely to obtain the metrics for all members.🤔 So looking back to the 'users' collection, I found a 'metrics' field which is documented as "The metrics of the user activity" and should be returning a "user_metrics" object. That sounds great🎉 Unfortunately what the API returns is literally that 😑, e.g. forSELECT metrics FROM users WHERE id = '65' I get: "metrics" : { "type" : "user_metrics" } Any advice on the right syntax to query additional metrics from the 'users' collection?153Views1like2CommentsPersonalizing Emails (Badges and Statistics)
I’m working on redesigning our automated emails and along with making the templates more visually appealing, I want to personalize them for each user with details such as their profile picture, last visit, statistics, and badges. The thing I’m most concerned about is displaying these badges/statistics in emails- I can’t find a way to code that in. This is a mock-up of what I have in mind, the badges and statistics at the top right: Has anyone had success with this kind of thing?thiagodesouza5 years agoContributor102Views0likes1CommentCustomizing the display of community.widget.page-options
In several of my page layouts, the display of the "three dots" for the "show page options" menu takes up an entire line. I assume I can customize this with CSS somehow (e.g. make it smaller, make it display something other than 3 dots). Precisely what classes control the display of this and where can I customize them in Studio?Solvedphoneboy5 years agoDirector126Views0likes4CommentsV2 api for PayPal community doesn't return any search result
Two weeks before when I executed below V2 query it resulted in 20 rows but when I executed the same query last week it gave only two rows for the same query and now it's giving zero results. Can you please help me to see what is going wrong here? If V2 is inconsistent then we can upgrade from V1 to V2 in production as it will be a problem for any customers to search in PayPal Community forum http://www.paypal-community.com/ppl/api/2.0/search?q=SELECT%20id,topic.subject,body,topic.body,view_href,%20topic.view_href%20FROM%20messages%20WHERE%20category.id%20=%20%27EN%27%20AND%20subject%20MATCHES%20%27%5C%22Payment%20issues%5C%22%27%20AND%20is_solution=true%20ORDER%20BY%20kudos.sum(weight)%20DESCLIMIT%2020Solvedbvasudevan5 years agoContributor89Views0likes2CommentsCheck if user is a member of a group hub
Hi everyone, I'm currently trying to create a component which will check if a user is a member of a group hub and then if they are, display something on a page. I keep using the LiQL fromhttps://developer.khoros.com/khoroscommunitydevdocs/docs/membership-liql-examples, but for almost each one, I get an "invalid query syntax" error. Does anyone what might be the cause? Here is the code I'm using: <#assign apiVersion = "2.0"/> <#assign liql_query = "SELECT join_date, title FROM nodes WHERE user.id = '" + user.id + "' "/> ${liql_query} <#assign users= rest(apiVersion, "/search?q=" + liql_query?url + "&restapi.response_style=view") /> <br>${users.status} <br>${users.message} I've also tried the following queries, but same error (invalid query syntax): SELECT id,login FROM users WHERE node.id = 'grouphub:EAP' SELECT login, id, join_date FROM users WHERE node.id = '<node.type>:<node.id>' <#assign liql_query = "SELECT * FROM roles WHERE users.id = '" + user.id + "' and node.id = 'grouphub:EAP'"/> I can't for the life of me figure out what is wrong with the queries. I would appreciate the help!SolvedNconforti5 years agoMentor260Views0likes4CommentsMeet our new developer documentation writer!
Hello Developer Community! Khoros is doubling down on the Developer Experience and has hired a second writer dedicated to Khoros Developer Documentation. I'm very happy to introduce Ryan Pierson (RyanPi). Ryan started in late March 2020. (You can imagine that he had quite an interesting interviewing and onboarding experience with all that has been going on in the world.) In less than two months, Ryan has already delivered exceptional content to the Care platform. Check out his Modern Chat guides in the Dev Doc Portal. I'm looking forward to introducing him to the world of Community and Marketing dev docs next. Ryan has a background in video editing and broadcasting. He loves building PCs and learning about new technologies. He's worked for development houses ranging from small web theme designers to one of the largest e-commerce retailers in the world. While he'll modestly tell you he's not a software engineer, he's super sharp and he's ready to jump in and experiment with our APIs and products. Plus, he's just about the nicest person you'll ever meet. In his own words: "I’m excited to be a part of Khoros because I can help brands connect with their customers in new ways, and make life easier for developers putting our incredible products to work for their companies.” With Ryan on the team, we now have cycles to fill some of the gaps in our guides and reference material, investigate and implement better ways to deliver information, and learn more about your needs as an audience. The entire Information Experience (IX) team is thrilled to have Ryan with us. I hope you all are as well. Welcome, Ryan!SuzieH5 years agoKhoros Alumni (Retired)106Views7likes2CommentsQuery the Users based on the "last_visit_time"
Hello everyone, I am trying to integrate with Khoros/Lithium v1-API's. I am trying to pull the user (/restapi/vc/users) data based on the "last_visit_time" element to get the list of the most recent users logged into the system unlike getting all the users information. The sample user object contains the following elements mentioned below and I am trying to find if we can pass a"query" as a queryParams to get the user data based logged in the last 24 hours ?. <user type="user" href="/users/id/5"> <last_visit_time type="date_time">2019-07-23T03:12:49+00:00</last_visit_time> <email type="string">sharst080102@yopmail.com</email> <registration_time type="date_time">2018-08-27T02:07:58+00:00</registration_time> <banned type="boolean">false</banned> <average_message_rating type="float">0.0</average_message_rating> <average_rating type="float">0.0</average_rating> <deleted type="boolean">false</deleted> <login type="string">shar</login> <anonymous type="boolean">false</anonymous> <sso_id type="string">efcb-e234f9c8cff1</sso_id> <registered type="boolean">true</registered> <id type="int">5</id> </user> any much related is highly appreciated. Thanks in advance 🙂 Note: I am querying through to get the results. any postman request/response will be greatly helpfulSolvedchakri5 years agoContributor130Views0likes3Comments