Forum Discussion

nchungie's avatar
nchungie
Guide
10 years ago

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

I tried:

 

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

  • ChhamaJ's avatar
    ChhamaJ
    10 years ago

    Hi nchungie

     

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

     

    Hope this helps.

     

    Thanks,
    Chhama

  • ChhamaJ's avatar
    ChhamaJ
    Khoros Staff
    10 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
      10 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?