nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

# Memberships on a specific date in the past

Kevin Hardy

Hello!

I'm looking for the best way to figure out how many Memberships we had on a specific date. (ex: How many active memberships did we have on 9/4/2003)

Would prefer a SKYAPI or a SQL solution (we have access to the SQL database) since this data needs to be loaded into an external system.

Can someone point me in the right direction?

Thanks!

Find more posts tagged with

Comments

Joe Moretti

@Kevin HardyYou can always run a Compartive Membership Statistics Report in Database View for a specific date and click the box to create either a membership, constituent or Gift Query and then export information you want.

Kevin Hardy

@Joe Moretti
Thank you! Definitely headed in the right direction! This is the data I'm looking for.

Hopefully this isn't a basic question, but after setting my criteria and running/saving the report, is there a way to get the specific SQL behind the report? We've got to run a lot of these and it would make a lot more sense to do it directly on SQL server (while programmatically updating the parameters each run)

Joe Moretti

@Kevin Hardy Sorry cannot help you with that.

Alex Wong

@Kevin Hardy
RE database view query will not provide you with a SQL select statement to run.

KB does sometime have SQL article you can try searching for.

If you are (or have someone in your team) familiar with SQL, you can read the RE database schema reference help file, which will give you all the details you need to create a query SQL statement to meet your exact need. It is definitley a worthwhile time investment if you plan run more reports directly from the database tables. It is a LOT more powerful than relying on RE query/export.

It is hard for someone without your org-specific data knowledge to give you a SQL statement to run that will give you exactly what you want. so it is either going to be getting a contractor to do this for you, or you or someone within your org that have SQL knowledge to learn the RE database schema and able to create the SQL knowing how your data exist in RE. I did this for my org (until we moved to RE NXT) and the custom reports through SQL was truly a gem for them. The schema knowledge gained will also help you in the future (or maybe you are currently) in RE NXT, for custom reporting outside of what Blackbaud provide through RE NXT, using SKY API. I strongly encourage it.