Hey y'all!
I'm trying to pull a list of anyone with a given constituency during a specific date range.
For context, I'm trying to look at historical giving for our women's board by fiscal year. So I'd like to see who had the active Women's Board constituency during FY22, FY21, etc. I know that I can pull a list based on constituency start date, or inactive constituencies, but that wouldn't capture the full scope of the list.
Any thoughts or parameters that would give me this result?
Thank you!
Hi Alex,
The only standard constituency element for lists is limited to active constituencies (VXS_CONST_CUST). Assuming you don't already have custom elements for this, your needs would seem to require a duplicate element pulling from VXS_CONST_CUST_ALL, with additional elements for the start and end dates of the constituencies. With that you could for example include the criteria for Women's Board constituency, and the for FY22, include a criteria for start date <= the last date of FY22 and end date >= the first date of FY22.