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

Connecting Khoros data to CRM (Salesforce)

API v1 docs gone since Atlas migration to Aurora

Does anyone know how to change the display title of Custom Fields in Aurora?

Can someone walk me through authenticating and using Postman with Aurora?

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