Joining on fuel_pages

Comments

• admin

  October 2012 edited 10:51PM

  I'm assuming you are wanting to do this in the CMS form for creating a services record correct? If so, the easiest way may be to just add the $foreign_keys property to your services model like so:
  public $foreign_keys = array('page_id' => array(FUEL_FOLDER => 'pages_model'));
• Gerown

  October 2012 edited 10:51PM

  Thank you for the fast answer!. That did the trick.
  Is it also possible to add a where clause on it? So I can get only the pages where the layout is equal to "service"?
• admin

  October 2012 edited 10:51PM

  There is in the 1.0 beta branch (along with a slew of other new features):
  https://github.com/daylightstudio/FUEL-CMS/tree/1.0
  
  public $foreign_keys = array('page_id' => array(FUEL_FOLDER => 'pages_model'), 'where' => array('layout' => 'service'));
• Gerown

  October 2012 edited 10:51PM

  Thank you I will give it a try