Forum Discussion

dasyurid's avatar
dasyurid
Ace
11 years ago

Displaying most recent thread by user

Hi,   We want to make it easier for our members using our Help forum to relocate their threads more easily - specifically by placing a widget at the top of the forum index that shows them only thei...
HaidongG's avatar
HaidongG
Lithium Alumni (Retired)

Hi dasyurid ,

 

for your requirement "the rest of the code to then restrict it to only display threads originated by the user and exclude those that have been solved."

 

please look at this query

 

http://community.lithium.com/restapi/vc/search/messages?solved=false&author_id=25880&q=is_root:true

 

  1. solved=false ==> exclude those that have been solved
  2. author_id=25880 ==> originated by the user 25880 (it is you :) )
  3. q=is_root:true ==> topics only, i.e. excluding replies.

 

I hope that this helps.

 

dasyurid's avatar
dasyurid
Ace
11 years ago

HaidongG That's getting very close to what we want. When testing it on our staging board, however, it's picking up threads I've contributed to but was not the original thread creator. It's also picking up threads that are solved where I've contributed and my post is not the solution.

 

What I'm specifically after maybe better illustrated with an example:

 

Within the Help board, we have four threads:

 

Thread A - started by me, has a solution marked.

Thread B - started by you, no solution marked.

Thread C - started by me, no solution marked.

Thread D - started by a.n.other, I've posted a reply, no solution marked.

 

The component we want to create would then look through the threads and:

 

If I am logged in, it shows me Thread C

 

If you are logged in, it shows Thread B

 

If a.n.other is logged in, it shows Thread D

  • HaidongG's avatar
    HaidongG
    Lithium Alumni (Retired)
    11 years ago

    Hi dasyurid ,

     

    I realised that we should use "author_id" instead of "user_id" in my previous example, may you want to try that out? I will update my original reply too.

    • dasyurid's avatar
      dasyurid
      Ace
      11 years ago

      Bingo!

       

      Many thanks - that's pulling nicely.

       

      We've further refined it, as follows, to get it to only pull from the one forum, get it to sort by most recently created thread at the top, and only return a maximum of 5 threads:

       

      /boards/id/[board_id]/search/messages?solved=false&author_id=${user.id}&q=is_root:true&sort_by=-latestPostDate&page_size=5

       

      This so far appears to be giving us what we wanted.