Ideas

Display Comment Count in Prayer Request List Block

3

Login To Vote

Display Comment Count in Prayer Request List Block

Prayer

For some time, we have displayed the Comment Count on each Prayer Request in the Prayer Request List block. We did this with a custom column, with the following Lava:

{% assign size = Row.Id | Notes:'2' | Size %}
{% if size > 0 %}
    <span class="badge">{{ size }}</span>
{% endif %}

However, doing this slows the block's load time significantly because, when viewing a large number of prayer requests (such as viewing expired requests) the block pulls back thousands of rows, running this lookup on each row. 

It would be nice if a comment count could be displayed in this list block that could be done in one efficient query instead of per-row lava.

Photo of Mike MundySubmitted by Mike Mundy, Bedford Alliance Church  ·   ·  Prayer
Remove Votes
Login to add a comment...

Submission Success Tips

Cultivate your ideas for maximum impact with these helpful submission tips that will increase the chances of your brilliant concepts becoming reality.

  • Clear Title: Craft a straightforward and descriptive title that instantly conveys the essence of your idea.
  • Concise Description: Provide an idea description that is succinct, ensuring it effectively communicates the concept without unnecessary verbosity.
  • Provide Additional Details: With a concise description complete, now provide any other details that are needed to better understand the requirements.
  • Thorough Ministry Need Review: Provide a comprehensive overview of the ministry need your idea addresses, emphasizing its significance.
  • Cover the WHY: Clearly articulate the rationale behind your idea, explaining why it's essential and how it aligns with the organization's goals and mission. Oftentimes a clear "why" sheds light into other possible options.