Merged idea

This idea has been merged into another idea. To comment or vote on this idea, please visit RENXT-I-166 Allow lists to run off of dynamic queries.

Dynamic query for lists Merged

It would be helpful if lists could use dynamic queries to pull the most up to date information as to alleviate having to run a static query in the database view every time we need an updated list.  We have reports that we run every month such as gifts that have come in last month credited to a certain fundraiser.  Static queries require you to run the query in the database view before you can pull it into lists which could be alleviated using a dynamic query.

  • Guest
  • Jul 14 2016
  • Reviewed: Voting Open
Data analysis
  • Sharley LaMora commented
    June 18, 2020 15:14

    This is a great idea - I vote YES. And if NXT can provide charting tools
    can be the basis of custom real-time dashboard analyses.

    *Sharley LaMora*
    *Data Services Coordinator*
    Mount Angel Abbey & Seminary
    1 Abbey Drive, Saint Benedict, OR 97373
    503.845.3914

    www.mountangelabbey.org

    *Mount Angel Abbey* *, a Benedictine
    monastic community founded in 1882, is dedicated to a life of prayer, work,
    pastoral ministry, hospitality and education. **Mount Angel Seminary*
    * the largest seminary in the
    West, forms men for the Roman Catholic priesthood. The **Abbey Foundation
    of Oregon* * supports the monastic
    community’s mission of service to the Church.*

    Attachments Open full size
  • Bill Connors commented
    May 08, 2017 23:33

    All my users want to use the database view so they can use Query to create or at least can refresh their Static queries they have as lists.  Defeats the whole purpose of Lists in the web view.  We don't create static queries in the database view because they're not very useful; so they're not very useful here either.  Please implement soon.

    Attachments Open full size
  • Ellen Smith commented
    March 31, 2017 15:24

    So glad this will likely be implemented.  You won't have to add every field as filter on list for  now if we can use RE7 to set them up! 

    Attachments Open full size
  • Brian Bates commented
    January 31, 2017 17:30

    Any update on likely implementation?

    Attachments Open full size
  • Sunshine Watson commented
    October 17, 2016 15:31

    Great news that this is likely to be implemented! Thank you!

    Attachments Open full size
  • Blake Moody commented
    July 15, 2016 20:05

    I've created a lot of very complex queries that I wouldn't want our users to have to recreate in NXT. For example board members for a specific branch are based off of relationships that have either Board Member or Board Chair as the relationship type.

    Bonus points if the ask criteria is a dynamic filter criteria.

    Attachments Open full size
  • +117

Related ideas