RESTAPI sort by last_edit_time

Question

Hi,&nbsp;Is it possible to retreive threads(forum, blog, idea, tkp and Q&amp;A) from restapi sorted by last_edit_time?&nbsp;Thank you.

tariqhussain · Answer

irach15-&nbsp;I have posted Idea for the same https://community.lithium.com/t5/Product-Ideas/Sort-Messages-by-last-edit-time/idi-p/332003 which is Acknowledged by lithium.&nbsp;

suzieh · Answer

HI&nbsp;irach15,
TariqHussain&nbsp;is correct in that we don't have a way to support this at this time. We don't have a good workaround for you, unfortunately.

irach15 · Answer

SuzieH,&nbsp;TariqHussain,this is what I've coded, the way aroundAPI call to get the latest tkb from a specific boardcreate&nbsp;an object of the data you need to showpush data to the objectsort the data by using FreeMarker sort_byreverse to be decendingit works for the task I've been working on&nbsp;&nbsp;&lt;#attempt&gt;
&lt;#assign apiVersion = "2.0"/&gt;
&lt;#assign messages = rest(apiVersion,"/search?q=" + "SELECT id, body, subject, view_href, post_time, post_time_friendly, board.id, board.view_href, board.title, board, images, images.count(*), videos.count(*), attachments.count(*), current_revision.last_edit_time FROM messages WHERE board.id = '${boardID}' AND depth=0 ORDER BY post_time DESC LIMIT 5"?url) /&gt;
&lt;#recover&gt;
&lt;p&gt;Woops...&lt;/p&gt;
&lt;/#attempt&gt;

&lt;#assign sortedMessagesList = [] /&gt;

&lt;#if messages.data.items ?? &gt;
&lt;#list messages.data.items as message &gt; 
 &lt;#assign sortedMessagesList = sortedMessagesList + [{'message_subject': message.subject , 'message_revision_time':message.current_revision.last_edit_time}] /&gt;
&lt;/#list&gt;

&lt;#list sortedMessagesList?sort_by("message_revision_time")?reverse as mes &gt; 
 &lt;p&gt;- ${mes.message_subject}: ${mes.message_revision_time}&lt;/p&gt;
&lt;/#list&gt;

&lt;/#if&gt;&nbsp;

irach15 · Answer

Is it any updates on this?I need to sort API call from a specific board by last_time_edit?Is it any way around to make it work?It should be just the original tkb post that edited, not comments.SuzieH,any suggestions on this?Thank you.

tariqhussain · Answer

irach15- Thanks for sharing this code. However, this will for specific range e.g latest or oldest or for specific limit e.g 1000 messages.Example someone has edited a message which was posted 3 years ago. There is no way to get it unless we store all the messages in the object.&nbsp;

Forum Discussion

RESTAPI sort by last_edit_time

Related Content

Sort labels from restapi

RESTAPI permission

RESTAPI v2 Url

Lithium RESTAPI posts/recent sort by last_edit_time

login through restapi

Recent Discussions

Seeking Advice on Restricting Access to a posts to those who have the permalink.

TinyMceEditor is undefined

400/404 error on POST request

Connecting Khoros data to CRM (Salesforce)

How do I get the article ID in Freemarker in a TkbArticle?