I created a dataobject like this:
class StaffMember extends DataObject
static $db = array (
'Name' => 'Varchar(255)',
'Role' => 'Varchar(100)',
'Description' => 'Text'
now like create a StaffPage.ss page which can use a dropdown field and filter/query only e.g. Roles like "Manager".
In this dropdown field should all Roles available and only that chosen Members with the Role should be displayed.
I know that is simple but I can't find a solution, so thank you for your help.