User Profile

karuna179

Expert

Joined 8 years ago

15 Posts7 LikesLikes received

Technical Lead CST

View All Badges

User Widgets

Contributions

Re: API for newly published articles?
citizenelah I'm glad the combination worked out and you were able to get results. 🙂
2 years ago Place Developer Discussion
Views
Sign in to react to this post
Comments
Re: API for newly published articles?
citizenelah You can use this query to fetch the articles if they are sorted manually from the admin structure. SELECT id, view_href, body, last_publish_time FROM messages WHERE board.id = 'TechnicalArticles' ORDER BY manual_sort asc limit 10 If you need to fetch the latest 10 published articles then you will need the below query: SELECT id, view_href, body, last_publish_time FROM messages WHERE board.id = 'TechnicalArticles' ORDER BY last_publish_time desc limit 10 The last_publish_time field contains the date time that the message was last updated. If there have been no edits to a message, then last_publish_time will equal post_time. If you do not want the edited posts then you need to just add the query and sort the posts by post_time in descending order and you will be able to fecth the latest 10 posts published from the board. SELECT id, view_href, body, last_publish_time FROM messages WHERE board.id = 'TechnicalArticles' ORDER BY post_time desc limit 10 Do let me know if in case I was able to provide you a solution or in case you have some other queries related to the same, will be happy to help.
2 years ago Place Developer Discussion
Views
Sign in to react to this post
Comments
Re: Emojis in email subject?
djondinium I am not sure if this will help you but if this is related to Classic Community then we can get the emoji filter added in the editor to be added directly. Also in case you need to add in the subject just press : "Ctrl + Cmd + space" and you will see an emoji modal open up and you would be able to add the images. I have attached a few screenshots if in case these can help you for reference. Let me know if I got your right and this serves as a solution to you or you were looking for something else?
2 years ago Place Developer Discussion
Views
Sign in to react to this post
Comments

You’ve seen all recent content