I have been looking for this off and on for 3 years, can someone help? I've put a ticket in and they aren't able to help without charging and I just don't understand why this isn't a simple answer. I don't know know or have access to SQL and neither does anyone else at our organization.
What I need:
I need to be able to add address line 1 in list criteria so I can search based on the address containing a word, like a street. For example, I want to pull everyone with an address that contains "Tropical Av"
What I know/currently have tried:
I hope that comes through clear, but in summary I have added Address Street 1 to T_Keyword, Detail Tbl of vs_addrss and Detail Col of !.street1
I appreciate any help you can offer!
Jen
If you are in List Manager, you ought to be able to get your basic query in place using the out of the box criteria, save, and then, Show Query, and put something like this into the sql SELECT DISTINCT a.customer_noFROM V_CUSTOMER_WITH_PRIMARY_GROUP AS a WITH (NOLOCK) INNER JOIN (SELECT a1.customer_no FROM VS_ADDRESS AS a1 WITH (NOLOCK) WHERE a1.street1 LIKE '%Tropical Av%' AND ISNULL(a1.inactive, 'N') IN ('N')) AS e
ON e.customer_no = a.customer_no
WHERE a.inactive = 1
I do not have access to SQL and would want to be able to search on all kinds of addresses.