3 posts by 2 authors in: Forums > CMS Builder: Plugins & Add-ons
Last Post: September 27   (RSS)

Hey Guys.

I'm using Report Builder to display the activity of agents, and the part of the SQL below displays the agents.  However this displays the "num" and I want to display the "label".  In php I would saug $record['agentsNum:label'].  How do I do that here?

SELECT
agentsNum as 'Agent',
nlb_subscribersNum as 'Contact',
DATE_FORMAT(<?php echo $TABLE_PREFIX ?>notes.updatedDate, '%M %Y') as 'Date'
FROM <?php echo $TABLE_PREFIX ?>notes
GROUP BY Agent
ORDER BY Contact

Cheers,



Tim Forrest

Toledoh Enterprises

www.toledoh.com.au

Perfect - thanks Daniel.

Cheers,



Tim Forrest

Toledoh Enterprises

www.toledoh.com.au