Specify Fund ID Search in Query

Currently, when searching for a specific Fund ID while using Fund ID as a criteria in query, a search will include information from the Fund ID AND the Fund Description. This makes it difficult if you are wanting to search for a group of funds with clustered Fund ID's or those that begin with a specific letter as it pulls in the Fund Description information. It would be nice if the Fund ID criteria search was specified to allow a search for Fund ID information only.

  • Caleb Burris
  • Nov 3 2025
  • Reviewed: Voting Open
Query
  • Attach files
  • Tresa Wandrey commented
    09 Jun 20:03

    Very important at my org! We have fund IDs beginning with "SCH" for non-endowed scholarships, "END" for endowments, "PRG" for program, for example. Due to the inability to sort/search that way in query or report filters I revert back to database view for those tasks.

    Attachments Open full size
  • Maya Rosman commented
    09 Jun 18:39

    Yes! This makes it so much less efficient/more difficult to manage queries when you need to grab a group of Find IDs.

    Attachments Open full size
  • JoAnn Strommen commented
    09 Jun 18:02

    Fund ID criteria should be specific.

    Attachments Open full size
  • Sunshine Reinken Watson ⭐Community All-Star commented
    09 Jun 16:51

    This is very important. Issues with "one of" are the main reason I need to go back to DBV to complete my query criteria.


    Also see these related ideas:

    https://renxt.ideas.aha.io/ideas/RENXT-I-7542

    https://renxt.ideas.aha.io/ideas/RENXT-I-10059

    Blackbaud staff: These ideas are similar, but not the same. Please don't merge.

    Attachments Open full size

Related ideas