Forum: Ruby on Rails missing foreign key fields in scaffold views

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
John J. (Guest)
on 2006-01-13 08:23
(Received via mailing list)
Is there any reason that foreign key fields do not show in any of the
scaffold views ?

project table:
id serial primary key,
category_id integer,
user_id integer,
name varchar,
morestuff varchar
foreign key (category_id) references categories(id),
foreign key (user_id) references users(id)

scaffold generated views only show name, morestuff fields
Bruce B. (Guest)
on 2006-01-13 15:36
(Received via mailing list)
John:

I don't know the reason, but if it puts your mind at rest, you are
doing nothing wrong. This is the way it is with scaffolding. It is
very easy to add foreign key fields to the existing scaffolding. Just
follow the pattern laid out by the fields that are there and use
something like collection_select to get a drop down to work with the
linked tables.

bruce
Rube G. (Guest)
on 2006-01-13 18:51
John John wrote:
> Is there any reason that foreign key fields do not show in any of the
> scaffold views ?
>
> project table:
> id serial primary key,
> category_id integer,
> user_id integer,
> name varchar,
> morestuff varchar
> foreign key (category_id) references categories(id),
> foreign key (user_id) references users(id)
>
> scaffold generated views only show name, morestuff fields

From what I read, scaffold causes rails to hide anything named id or
ending with _id.

If you want, say, dropdown menus from lookup tables ( I needed these.
Took a long time to figure out how to do ) try this:

<%= options_from_collection_for_select(Yourmodel.find(:all, :order =>
"id"), :id, :lookupField, selected_value= someIDhere) %></select>

someIDhere in my cases was the foreign key field in the parent table.
This allowed me to get it to select the right entry for that record.

options_from_collection_for_select is in the rails API. You'll be
spending a LOT of time sifting through that if you plan to stick it out
in rails. Good luck.
Jeremy E. (Guest)
on 2006-01-13 21:22
(Received via mailing list)
On 1/12/06, John T. <removed_email_address@domain.invalid> wrote:
> foreign key (user_id) references users(id)
>
> scaffold generated views only show name, morestuff fields

If you want the user and category for the project scaffolded with a
select box, you can look into the Scaffolding Extensions plugin.
John J. (Guest)
on 2006-01-13 22:02
(Received via mailing list)
Thank you.  It would be helpful if someone could write an article on all
the Rails extras that are available - I think some of us are missing out
on a lot of features.
This topic is locked and can not be replied to.