Forum Discussion

kgroneman's avatar
kgroneman
Boss
7 years ago
Solved

Is a teaser from multiple TKBs possible?

I'm not a developer but I'd like to know if it's possible to create a teaser custom content box from multiple TKBs?    We currently have the following code to provide a teaser for a single blog that ...
  • VikasB's avatar
    VikasB
    7 years ago

    kgroneman

    Yes, it can be done for multiple TKBs/blogs/boards. You can use "IN" query to pass the multiple TKB boards in a single query. Like this

    SELECT id FROM messages WHERE conversation.style = 'tkb' AND board.id IN ('sws-571','sws-999', 'sws-777')ORDER BY post_time DESC LIMIT 5

     

VikasB's avatar
VikasB
Boss
7 years ago

kgroneman

Yes, it can be done for multiple TKBs/blogs/boards. You can use "IN" query to pass the multiple TKB boards in a single query. Like this

SELECT id FROM messages WHERE conversation.style = 'tkb' AND board.id IN ('sws-571','sws-999', 'sws-777')ORDER BY post_time DESC LIMIT 5