How to get unique email addresses of customer ?

(1) Share

Report

Posted on by harshil9898

I have a requirement where I want to pull all the email address of customer which should be unique. Please let me know how to do this in X++ what tables to use and what could ne the possible relations between them.

Thanks in advance :)

Categories:

Dynamics 365 Finance

Microsoft Dynamics AX

I have the same question (0)

All responses (2)

Answers (2)

Verified answer

harshil9898 33 on at

Like (0)

Report

How to get unique email addresses of customer ?

@CA Neeraj Kumar thank you for your help. The enum value is LogisticsElectronicAddressMethodType::Email. By using this we can pull the required emails.

Also in x++ code i have used set.

while (setIterator.more())
{
uniqueEmail = setIterator.value();

if (uniqueEmail)
{
con = connull();
con = conins(con, 1, uniqueEmail);
}
setIterator.next();
}

this worked for me in x++.

Was this reply helpful? Yes No
Verified answer

CA Neeraj Kumar 834 on at

Like (1)

Report

How to get unique email addresses of customer ?

Hi Harshil,

Below is sql query for reference:

-Select distinct T1. locator, T2. AccountNum from dirPartyContactInfoView T1JOIN Custtable T2 ON T1.PARTY =T2.PARTY

WHERE T1.Type = LogisticsElectronicAddressType = Email.. (Unable to recall enum value).

Regards,

Neeraj

1 people found this reply helpful.

Was this reply helpful? Yes No