5539 Posts in 1738 Topics by 1224 members
|Go to End|
10 March 2012 at 7:59am
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
10 March 2012 at 9:25am
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 );
|Go to Top|