Hello there,
I've raised two tickets today so I thought that I'd throw issue number three out to everyone else instead!
A colleague was updating address details on a Constituent and got an error. They clicked 'okay' or whatever was on the window that popped up and now when we try to find the Constituent we get 'There were no records matching the given criteria'.
We've tried searching for account number, address etc but cannot access the account on Tess. Yet in SQL we can see it if we run a script on either of the below: SELECT
SELECT
* FROM T_ADDRESS where customer_no = 99217SELECT * FROM T_CUSTOMER where customer_no = 99217
A bit odd isn't it?
Paul.
When checking in SQL, make sure you are also looking at the primary_address_no,
*
FROM
dbo.T_CUSTOMER AS c
JOIN dbo.T_ADDRESS AS a ON c.customer_no = a.customer_no AND
c.primary_address_no = a.address_no
WHERE
a.customer_no = ####
I believe Lucie was also pointing you in this direction.
Marty Jones
Director of Information Services
Omaha Performing Arts 1200 Douglas Street
Omaha, Nebraska 68102
P 402.661.8469
Marty.Jones@omahaperformingarts.org
www.omahaperformingarts.org
For tickets, call Ticket Omaha at 402.345.0606
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Paul White Sent: Tuesday, September 06, 2011 3:57 AM To: Martin A. Jones Subject: RE: [Tessitura Ticketing Forum] Constituent DELETED?!
Hi Varsha,
Usually if an account is merged there's a pop-up giving details of the account it was merged into. I'm just getting 'There were no accounts matching the given criteria.'. It's like Tessitura has forgotten it. I'm sure it's fine - we'll just create a new account for her, it's just weird that I can see it in SQL but not on Tessitura.
From: Varsha Karnik <bounce-varshakarnik2805@tessituranetwork.com> Sent: 9/5/2011 11:12:34 PM
Hi Paul
Check the teh INACTIVE flag for that customer,
Select Customer_No, fname, lname, Inactive from T_Customer where Custoemr_no = 99217
If Inactive = 5 then that means it is Merged with other id. If you still want to keep that ID then update the Inactive flag to 1. Merged accounts don't appear in the selection!!
cheers, Varsha
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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!