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.
I have a product page which has "has_one" => 'member' .
What i would like to create - is a Tab in CMS where i could list has_one list (radiobuttons) but ONLY WITH MEMBERS from certain group (for example group id =4) .
Basically as I've got around 500 users (and growing) as buyers and only 4-5 as sellers. I knwo how I can show ALL members , however not sure how to strict the list to buyers only.
Any help would be appreciated
Thanks to IRC - adding some query WHERE and JOIN clauses helped :
jus in case someone will be looking for same solution heres my code:
$tablefield = new HasOneComplexTableField(
'FirstName' => 'First Name',
'Email' => 'Email'
'getCMSFields_forPopup', //detail form fields
'"Group_Members"."GroupID" = 4',
'JOIN "Group_Members" ON "Member"."ID" = "Group_Members"."MemberID"'
$fields->addFieldToTab( 'Root.Content.Pardavejas', $tablefield );