Note the upgraded forum! If you are experiencing issues logging in, you may need to reset your password which should send an email. If the email doesn't arrive, be sure to check your spam folder just in case.

Foreign key name in table list.

Hi again, admin!

I have this problem:

I'v added public $foreign_keys = array('blog' => array(FUEL_FOLDER => 'blog_model'));
and i can select the foreign values, but when i look on the rows list i can see the value(foreign id), but no the displayed name.

Screenshot:

https://i.gyazo.com/619b7b5b63b05587191fd0b6d40c6a0c.png

Thank you for help <3

Comments

  • edited 8:54AM
    When you say "rows list" are you meaning the list view for the module or are you meaning the dropdown select for that field? If it's a foreign key, I'd include an "_id" on the field name to help denote it's a foreign key ID
  • edited 8:54AM
    No, i meant not the dropdown select. It works fine.

    https://i.gyazo.com/f2bc7b6b7c804e9264e12c75e132b611.png

    When i select blog_id in dropdown select i expect to see the name of the blog in list (screenshot), but i see only id value (1,2,3) etc.

    I'v tried blog_id, but it doesnt work for me :(
  • edited 8:54AM
    That looks like you'll need to modify the model's list_items method and include a join on the blog table:
    public function list_items($limit = NULL, $offset = NULL, $col = 'id', $order = 'asc', $just_count = FALSE) { $this->db->join('blog', 'blog.id' = 'mytable.blog_id', 'left'); $this->db->select('id, blog.name....'); $data = parent::list_items($limit, $offset, $col, $order, $just_count); return $data; }
Sign In or Register to comment.