Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

Widgets /

Discuss SilverStripe Widgets.

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba, simon_w

Modifying Gallery Widget : Latest Galleries


Go to End
Reply


435 Views

Avatar
Fraser

Community Member, 47 Posts

14 June 2012 at 1:51pm

Another query about some modifications to the gallery widget..

I need to be able to pull out an image (doesn't matter which) from one of the listed galleries.

function Galleries() {
	  	$nrtoshow = (0<$this->NumberToShow) ? "0,".$this->NumberToShow : "";
    	$galleries = DataObject::get(
    		"Page",
    		"SiteTree_Live.ClassName = 'GalleryPage' AND ShowInMenus = 1",
    		"LastEdited DESC",
    		"",
    		"$nrtoshow"
    	);
    	
		return $galleries;
	}

I tried adding a join:

LEFT JOIN GalleryPage ON SiteTree_Live.ID = GalleryPage.ID LEFT JOIN File ON (GalleryPage.FolderID = File.ParentID  AND File.ClassName='Image')

but because it is a page object am unable to output an Image object. Is there a way I can do this?