Com_Address Table Country and State name need to download.

Ramakrishnan G asked on August 16, 2019 16:34

I download the data from com_Address table to excel file, in the table country and states are in ID format only. I need to download the excel in country name and state name.

var addresses = UserInfoProvider.GetUsers(). Source(sourceItem => sourceItem.Join

Correct Answer

Trevor Fayas answered on August 16, 2019 18:08

I would recommend just making a custom Report in the Reporting area that does the left joins to pull in the proper data, something like the below, you can right click on the table's grey header to export to excel still.

select COM_Address.*, StateName, CountryTwoLetterCode from COM_Address
left join CMS_State on StateID = AddressStateID
left join CMS_Country on CountryID = AddressCountryID

1 votesVote for this answer Unmark Correct answer

Recent Answers

Ramakrishnan G answered on August 19, 2019 16:33

Its working fine, Thanks.

0 votesVote for this answer Mark as a Correct answer