Create a new Template Variable
Go to Input Options Tab
Change Input Type to:
- Listbox (Multi-Select) - for multiple resource select
- Listbox (Single-Select) - for Single resource select
In Input Option Values type: @SELECT `pagetitle` AS `name`,`id` FROM `[[+PREFIX]]site_content` WHERE `published` = 1 AND `deleted` = 0
In the options below set Enable Type-Ahead: Yes
Thanks for this, works really well for larger sites. I made a slight change to the name field to match the way that the default resource list shows the ID in parentheses, since the site I'm using this on has pages with the same pagetitles (product names).