Forum Discussion

dustin's avatar
dustin
Expert
10 years ago

Why can I only look for messages across 16 boards at a time?

 

I'm trying to aggrigate messages across all of the boards in our system.  We currently have 18 boards.   When I run the query on all 18, it pukes: 

Freemarker template 'preview' processing failed:
MappableContainerException:java.lang.StackOverflowError

 

If I take away any 2 of the boards, it works as expected.  Does anyone have any insight into this? Is there an actual limit on items, or is something else messing with my query?

 

<#assign my_board_ids_formatted = "migration,orientation,welcome,data_talk,sales,discussion,customer,team,corporate,filternotifications,moderatordiscussion,product-documentation,abusereports,questionablecontent,pulledcontent,partnerresources,partnerdiscussion,getting-started" /> 

<#assign recent_messages = rest("2.0","/search?q=" + "SELECT * FROM messages WHERE board.id IN ('${my_board_ids_formatted}')  AND depth=0 ORDER BY post_time DESC LIMIT 15"?url).data.items />
  • PaoloT's avatar
    PaoloT
    Lithium Alumni (Retired)
    10 years ago

    Hi dustin

     

    sounds like you should raise this with Support so they can look into it. There may be a limit in which case it should be added into the documentation - or it could be a bug.

     

    Thanks,