Hi, I have a question regarding constituencies now that we've got our migrated data up and running on our V11 tetst server.
Our BDO (Board) constituency is only showing up on individual records and not households. its not clear to me how constituencies are being mapped, as there's no TRU_ mapping table for constituencies, so its hard to track this down, any one have any ideas why this would be the case?
Thanks!
Porter Venn (San Francisco Opera)
Constituencies are migrated based on the n1n2 flag they have in V10. Records with an n1n2 flag of Name1 will move to the A1 individual, Name2 to the A2 individual and Both will remain on the household record.
David
But shouldn't the constituencies on the Individual record show up in parenthesis on the Household record due to data inheritance and vice-versa? That's how I'm interpreting Porter's question.
You aren't by any chance using a custom constituent header, are you? If so, you'll want to check on the code you are using to generate @all_consts, i.e. old code will mostly work, but not quite the way the default v11 header does.
One note here. the FS_CONST_STRING function returns the constituencies for the primary affiliates/household with parenthesis, and it can be used in custom header code.
Hi David,
I am working on trying to fix our custom headers using your suggestion of FS_CONST_STRING in the stored procedure, but I am getting the error that says "the function has too many arguments specified"
I was just replacing AP_CONST_STRING with FS_CONST_STRING so maybe I am missing something else.
Thanks,
Kanani
Try FS_CONST_STRING_NEW.