Hi,
How is it that using this function, with DataObject::get('Page', etc.), we are able to separate the Tags into individual links on the template level ($Link?tag=$Tag), but if I try to customise the query using DB:query(), all I get back from the BlogEntry table is the Tags column as one solid block?
Because I need to do a couple of JOIN's, I need to use DB:query():
SELECT ST.Title, ST.Content, ST.URLSegment, BE.*, F.FileName AS ListingImage FROM BlogEntry BE
JOIN SiteTree ST ON ST.ID = BE.ID
LEFT JOIN File F ON F.ID = BE.ListingImageID
Then:
foreach($item as $sqlResult) {
$Tags = $sqlResult['Tags'];
Etc.
$results->push(new ArrayData(array(
"Tags" => $Tags,
Etc.
)));
}
return $results;
How can I pass the Tags back pre-split? They're already inside an array. Help!
Thanks,
Garrett