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.

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. 

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