11/25/2024 6:22:46 PM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss general T-SQL questions and help with queries related to SalesLogix data. View the code of conduct for posting guidelines.
|
|
|
|
Comparing Contact Address against Account Address
Posted: 10 Nov 06 2:59 PM
|
fiogf49gjkf0d I've been able to write a SQL script that will compare the addresses of contacts and accounts and only display the contacts where the addresses match, however I'm not sure how to accomplish this using groups.
We had a bad import (ugh). We have numerous accounts with the same name (banks). When the import happened we had certain key fields mapped, but when all else failed they'd match by account name. So there are some accounts with a bunch of contacts that don't belong to that account. It's a mess. You can be sure i'll be testing my import scripts a LOT more throughly next time.  |
|
|
|
Re: Comparing Contact Address against Account Address
Posted: 11 Nov 06 12:03 PM
|
fiogf49gjkf0d Here is one approach that may work.
Create a contact group.
-Add Contact.Address.Address1 to the layout.
-Add Account.Address.Address1 to the layout.
-Use the View SQL to look at the field alias. You will probable see that the Contact Address1 is a2.address1 and that the Account Address is a4.address1.
-Add a condition for Contact.Address.Address1
Operator: Equal To
Value is: a4.address1
Use Value as Literal **Checked**
-Add a condition for Contact.Address.City
Operator: Equal To
Value is: a4.city
Use Value as Literal **Checked**
-Add a condition for Contact.Address.State
Operator: Equal To
Value is: a4.state
Use Value as Literal **Checked**
Add more fields as needed...
|
|
|
| |
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|