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.

Data Model Questions /

Filtering Pages on multiple many-many related DataObjects


Reply


3 Posts   1210 Views

Avatar
Felicitas

Community Member, 16 Posts

9 April 2011 at 10:11pm

Hi,

I'm having problems with filtering Pages on their many-many related DataObjects.

I have a CompanyPage. Each CompanyPage has a many-many relation with four DataObjects (Levels, Products, Markets, Competences).

In the CompanyHolderPage I would like to have a combined filter for these DataObjects, where the user can choose a combination of levels, products, markets and competences and the output will be a list of the corresponding pages for which this is true.

Does any one have any example code or a hint in the right direction?

Thanks,

Felicitas

Avatar
swaiba

Forum Moderator, 1804 Posts

18 April 2011 at 7:09am

This is not the right way - but I've used it as it is quick and easy...

class MyModelAdmin_CollectionController extends ModelAdmin_CollectionController {
   function getSearchQuery($searchCriteria){
      $query = parent::getSearchQuery($searchCriteria);

      if ($this->modelClass == 'MyModel'){
         $query->where[] = ''; //ADD YOUR SQL HERE, using stuff from $searchCriteria
      }
   }
}

Avatar
Felicitas

Community Member, 16 Posts

27 April 2011 at 7:46pm

Thanks for your reply. Maybe this is the right direction. Right now I have four dropdown boxes, one for each dataobject, but not a combination of them.