Greetings from Ice Station Zulu.
I have a constituent who I can see in T_CUSTOMER. They have an "inactive" value of 1 (Active) and I can't see anything else about the record which would make me think something was amiss.
However, I can't pull them up in a constituent search. Last name, street address, constituent ID. None of these return the record. What am I missing? What could cause a record in T_CUSTOMER to return "There were no records matching the given criteria" in constituent search?
Levi,
I’ve seen where if there isn’t a row in tx_cust_sal where default_ind = ‘Y’ or if there isn’t a row in t_address where primary_ind = ‘Y’, that the constituent won’t come up in the search.
Perhaps there was a blip with the merge routine where the data didn’t get saved properly.
You could try running a trace when searching to determine what stored procedure is running. Then run that stored procedure in SQL Management Studio and track it down that way.
Tanya
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Levi Sauerbrei Sent: Wednesday, February 02, 2011 12:32 PM To: Hoffmann, Tanya Subject: RE: [Tessitura Technical Forum] Constituent not appearing in search
Tanya,
There are several of both. This record was merged with another back in May. Just a weird one to keep my brain occupied today.
From: Tanya Hoffmann <bounce-tanyahoffmann4570@tessituranetwork.com> Sent: 2/2/2011 10:30:57 AM
Is there a row in tx_cust_sal and t_address for that customer number?
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Levi Sauerbrei Sent: Wednesday, February 02, 2011 11:27 AM To: Hoffmann, Tanya Subject: Re: [Tessitura Technical Forum] Constituent not appearing in search
The checkboxes are a popular choice :)
Unfortunately, all three are checked. I can find all types of records in my searches (Ind, Org, Contacts) just not this one in particular. Other users are having similar results when they search for this particular record.
From: Dale Aucoin <bounce-daleaucoin4707@tessituranetwork.com> Sent: 2/2/2011 10:21:59 AM
Did you check to make sure you have all three account types checked in your search screen - individual, organization, and contacts? Failing that do you have a seach filter in place that might be limiting your results? Dale
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
This e-mail message is intended only for the recipient(s) named above. This message may contain trade secrets, attorney-client communication, or other privileged and confidential information. Any review, re-transmission, dissemination, reproduction or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the Sender and delete the material from any computer.
Unknown said: I’ve seen where if there isn’t a row in tx_cust_sal where default_ind = ‘Y’ or if there isn’t a row in t_address where primary_ind = ‘Y’, that the constituent won’t come up in the search.
Also, the address_no for the primary_ind = 'Y' address should appear in T_CUSTOMER -> primary_address_no. I've seen a few cases where T_ADDRESS and T_CUSTOMER get out of sync in this regard.
Thank you all!
The answer was a wrong primary address number in t_customer. Everything is once again right with the world (at least in the database).