I haven't tried this yet, but I'm wondering if a list can be dynamic if it uses custom SQL? Or, working from another angle, has any one used a stored procedure to populate t_list_contents?
I'm going to be adding a constituency to records based on somewhat complex criteria that would be hard to construct in List Builder. But I would love to use the Manage Constituency report to do the actual constituency part. Is there a straightforward way to do this?
Have you tried copying the SQL code you are using into the Manual Edit window for a criteria set? If the criteria set will accept it, you can then make the list dynamic. I believe the only restriction is that the only data returned by the code is constituent ID, but it’s possible that if your code is really complex it might not work. It’s worth a shot, though.
Kevin Sheehan
Documentation & Learning Resources Specialist
Tessitura Network
1 888 643 5778 ext 329 Office
ksheehan@tessituranetwork.com