Forum Discussion

KevinSaquing's avatar
KevinSaquing
Ace
6 years ago
Solved

Best way to get all images under a specific board

Hi all,

Whats the best way to get all the images under a specific board? I am thinking of looping through all the messages under a board to get all the images but this might not be a good idea.

Thanks in advance!

  • VikasB's avatar
    VikasB
    6 years ago

    KevinSaquing 
    I do not think so there is any other option. But you can make it a bit optimized script by looping only those messages which contain at least one attachment/image.  
    You can use below API to get messages which meets the criteria

    SELECT id FROM messages where attachments.count(*) > 0

SELECT id FROM messages where images.count(*) > 0

    Hope it would be helpful. 

2 Replies

Sort By
  • VikasB's avatar
    VikasB
    Boss
    6 years ago

    KevinSaquing 
    I do not think so there is any other option. But you can make it a bit optimized script by looping only those messages which contain at least one attachment/image.  
    You can use below API to get messages which meets the criteria

    SELECT id FROM messages where attachments.count(*) > 0

SELECT id FROM messages where images.count(*) > 0

    Hope it would be helpful. 

  • KevinSaquing's avatar
    KevinSaquing
    Ace
    6 years ago

    I see. Thanks. Looks like I got no choice but to loop ğŸ˜€. Cheers!