Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
Gauravk Posted November 9, 2020 Posted November 9, 2020 Hi There, Can any SQL expert please help in creating a query to fetch following data in excel for our paid members (only)? email phone fn ln zip ct st country gen value Email: Email address Phone: Mobile Number fn: First Name ln: Last Name Zip: PO Box ct: City st: City country: Country Gen: Gender Value: Total Spent Thanks in advance.
Morrigan Posted November 9, 2020 Posted November 9, 2020 I believe you can do this via the "Download member list thing: Change things to "expired" and cancelled active I think the "Total Spent" there at the bottom should work. Gauravk 1
Gauravk Posted November 10, 2020 Author Posted November 10, 2020 I tried it and it didn't have any options for fn: First Name ln: Last Name Zip: PO Box ct: City Value: Total Spent
bfarber Posted November 11, 2020 Posted November 11, 2020 That data is stored in Commerce and would need to be pulled separately. Members can have more than one address so it's a bit trickier than just a specific SQL query. Gauravk 1
Gauravk Posted November 11, 2020 Author Posted November 11, 2020 Thanks, so is there any way out I can fetch half details with "members list" and then remaining ones with SQL and then rebuild excel manually?
CoffeeCake Posted November 25, 2020 Posted November 25, 2020 Welcome, time traveler. Here's a solution:
Recommended Posts