citizenelah
Ace
Joined 5 years ago
User Profile
User Widgets
Contributions
Re: API for newly published articles?
I got it! Had to combine post_time AND manual_sort to get the results to match my latest published article: query = "SELECT id, view_href, body, last_publish_time FROM messages WHERE board.id = 'TechnicalArticles' ORDER BY manual_sort, post_time desc limit 10" Thankskaruna179for the nudge and the help with post_time!234Views0likes1CommentAPI for newly published articles?
I'd like to automate social copy drafts in our social media platform for newly published articles. I can't seem to find the right combination of attributes / tables in a LiQL call OR the right API method that will give me what I'm looking for. I just want the last 10 articles that were published. I get the last updated, which could be older articles, and I published one two days ago that was a draft a month ago. That doesn't show up in my query of 10 at all as it's out of range, unfortunately. Any advice on how to accomplish this would be appreciated. The LiQL query I'm using: query = f"SELECT id, view_href, body, last_publish_time FROM messages WHERE board.id = 'TechnicalArticles' ORDER BY manual_sort limit 10"Solved248Views0likes4CommentsLiQL match is not accurate
Our data migration to khoros had a few misses, mainly, anything in our old forums with <code></code> tags is now a jumbled mess that I can fix manually by changing that to <li-code></li-code> in the editor. But we have over 10k of these, so that's not possible manually. I'd like to search for each message with the code tag (which as an aside, is interesting because in the stored data it's not the same view I see in the editor, it's stored as "<pre class=\"lia-code-sample language-tcl\"><code></code></pre>" and my old <code> tags are stored as <CODE></CODE>) Anyway...to my point. I have this query: SELECT id, view_href, body, current_revision FROM messages where body MATCHES '<CODE' LIMIT 1 I would expect it to only find the literal <CODE string in the body of my messages, but it seems to be matching any case of code and doesn't care at all about the less than sign. Here's the body of the first message it matched: "body" : "<H5 contenteditable=\"false\" id=\"toc-hId-1990738234\">Code is community submitted, community supported, and recognized as ‘Use At Your Own Risk’.</H5>\n<H3 contenteditable=\"false\" id=\"toc-hId-216654393\">Short Description</H3>\n<P>Please enter a short and descriptive title for your snippet.</P>\n<H3 contenteditable=\"false\" id=\"toc-hId-217577914\">Problem solved by this Code Snippet</H3>\n<P>Briefly describe the problem your snippet solves.</P>\n<H3 contenteditable=\"false\" id=\"toc-hId-218501435\">How to use this Code Snippet</H3>\n<P>Tell others how to use this code snippet.</P>\n<H3 contenteditable=\"false\" id=\"toc-hId-219424956\">Code Snippet Meta Information</H3>\n<OL>\n<LI>Version:</LI>\n<LI>Coding Language:</LI>\n</OL>\n<H3 contenteditable=\"false\" id=\"toc-hId-220348477\">Full Code Snippet</H3>\n<P>Enter your code snippet here or attach a file below.</P>", Any hints would be appreciated!146Views1like3Comments