Could I get a create_export_query example?

[adx442]

I'm very new to working with MySQL, and I could really use a little nudge in the right direction.

We're simply trying to export a target list with the contact's related account name as an additional column
.
I've looked through the forums, and it seems like I need to do this under create_export_query
in ProspectList.php, but I can't figure out how to form the LEFT JOIN statement (if I'm even in the right place, and if that's what I actually need to do).

Would someone be so kind as to show me exactly how to do this one thing? I think that will help me immensely in moving forward on my own in the future. Thank you!

[adx442]

Just one bump to see if anyone might help.

[salesagility]

Rather than cutting code that may not be export safe, you may be better to install ZuckerReports. Then you can construct queries that can extract from the db and associate the results to a target list ... all upgrade safe

[blackradius]

I'm very new to working with MySQL, and I could really use a little nudge in the right direction.

We're simply trying to export a target list with the contact's related account name as an additional column
.
I've looked through the forums, and it seems like I need to do this under create_export_query
in ProspectList.php, but I can't figure out how to form the LEFT JOIN statement (if I'm even in the right place, and if that's what I actually need to do).

Would someone be so kind as to show me exactly how to do this one thing? I think that will help me immensely in moving forward on my own in the future. Thank you!

do you need the target's email address as well?

[kenshyer79]

Asbestos Jobs
Loans For The Unemployed
Patio Lights

[racassel]

I Installed Zucker and the demo1 and demo2 packages, but the sample reports do not show up under repository, it just shows blank space and no lists. I tried changing the default report directory, and successfully got error messages, but with just a "/" in that field, no error, but no sample lists....

[adx442]

Rather than cutting code that may not be export safe, you may be better to install ZuckerReports. Then you can construct queries that can extract from the db and associate the results to a target list ... all upgrade safe

Thank you for the tip ... I will try that. Upgrade safe is an important consideration.