Forum Discussion

irach15's avatar
irach15
Maven
8 years ago

REST API exception for archived tkbs

Hi Everyone,

I am writing a search API for all active tkbs in our community.

A simple search something like:

SELECT id, board.title, subject, view_href, author.login, conversation.style, attachments, attachments.count(*), post_time, post_time_friendly FROM messages WHERE attachments.count(*) > 0 AND conversation.style='tkb' AND depth=0 ORDER BY post_time DESC

and I pull all data as json format in EndPoint.

 

as Admin, I'm guessing I get all tkbs...

The question is :

How to show only active tkbs?

- or How to write an exception to not to show archived tkbs?

- is it any API parameters for that?

 

I did extensive search and was not able to find any API to check if the article archived/active or not.

Help?

  • DougS's avatar
    DougS
    Khoros Oracle

    I'm not sure I understand what you mean by archived TKBs. Can you explain your process for archiving a TKB? Did you disable comments on the TKB articles or mark the TKB as read only? There is a read_only field you can get for each message returned, but we currently do not allow you to constrain your LiQL query by that field.

     

    -Doug