Forum Discussion

keithkelly's avatar
keithkelly
Leader
2 years ago

Quickest way to get "unanswered topic count" in a board list?

Given the scope "board" what's the best practice to grab the # of topics without replies? another rest() call?  Or is there some sort of magic I can use in the LIQL query to grab this? See ${board...
API
Community API
REST API v2 & LiQL
  • kkritika's avatar
    kkritika
    2 years ago

    keithkelly  You can try this - 

    liql("Select count(*) from messages where replies.count(*)=0 and depth=0 and board.id='[BOARDID]'").data.count

     

    f you appreciate my efforts, please give me a kudo ↓
    Accept as solution to help others find it faster.

keithkelly's avatar
keithkelly
Leader

Is the performance better?  (roughly akin to executing SQL directly, rather than through an API)?

kkritika's avatar
kkritika
Mentor
2 years ago

I believe it doesn't make any difference in the performance.