Forum Discussion

KevinSaquing's avatar
KevinSaquing
Ace
6 years ago

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. ...
  • 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. 

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!