Forum Discussion

nchungie's avatar
11 years ago
Solved

Community API v2: how to get latest posts (for all boards)

I tried:

 

```SELECT * FROM messages WHERE conversation.style='forum' ORDER BY latest```

  • Hi nchungie

     

    You need to do "Order by post_time DESC" to order by post date.

     

    Hope this helps.

     

    Thanks,
    Chhama

2 Replies

  • ChhamaJ's avatar
    ChhamaJ
    Khoros Alumni (Retired)
    11 years ago

    Hi nchungie

     

    You need to do "Order by post_time DESC" to order by post date.

     

    Hope this helps.

     

    Thanks,
    Chhama

  • nchungie's avatar
    nchungie
    Guide
    11 years ago

    Thank you. I am new to version 2 and I have another few questions.

     

    1. What is the difference between the tenantid and the clientid?

    2. For version1, I had to pass my id in the form username:password@username. Is that the same with version2?