Pulling Constituency withe End Date

Matthew,

Thank you for this information. It looks like the criteria “Constituency Start Date” and “Constituency End Date” may in face be custom elements within my database. I am still waiting on an reply from my internal DBA on this subject. This was helpful.

Thanks,

Hi Marie,

I ran into a similar issue once. It was in v10 and it certainly could have changed in v11, so if I'm wrong hopefully somebody will correct me.

I believe that when you use the criteria "Constituent IN (whatever)" you're actually pulling from a database view that is already filtering to include only accounts that currently have that constituency. If I pull a list with just "Constituency IN Advisory Board" e.g., and don't specify start/end dates, I get a list of only the current advisory board. (In fact, I don't seem to have "Constituency End Date" in my List Builder, so that may be custom?)

If the Constituency criteria is pulling from the view vxs_cust_cont, I think you might need to manually edit the query to pull straight from the actual table, tx_const_cust instead, and then you could use start/end dates. (But if you're using custom list criteria already maybe you already have a workaround for this.) I'm definitely not a DBA so maybe somebody with a little more knowledge of the v11 backend can chime in with more useful advice. :)

Good luck!

Matthew,

Thank you for this information. It looks like the criteria “Constituency Start Date” and “Constituency End Date” may in face be custom elements within my database. I am still waiting on an reply from my internal DBA on this subject. This was helpful.

Thanks,

Hi Marie,

I ran into a similar issue once. It was in v10 and it certainly could have changed in v11, so if I'm wrong hopefully somebody will correct me.

I believe that when you use the criteria "Constituent IN (whatever)" you're actually pulling from a database view that is already filtering to include only accounts that currently have that constituency. If I pull a list with just "Constituency IN Advisory Board" e.g., and don't specify start/end dates, I get a list of only the current advisory board. (In fact, I don't seem to have "Constituency End Date" in my List Builder, so that may be custom?)

If the Constituency criteria is pulling from the view vxs_cust_cont, I think you might need to manually edit the query to pull straight from the actual table, tx_const_cust instead, and then you could use start/end dates. (But if you're using custom list criteria already maybe you already have a workaround for this.) I'm definitely not a DBA so maybe somebody with a little more knowledge of the v11 backend can chime in with more useful advice. :)

Good luck!