Issue to show data from relational database tables in rails

Question

I am a newbie in ruby on rails it's also my first ruby application.

I want to show data from two tables these are

applied_jobs table: it contains the below columns:

applied_jobs_id | jobseeker_id | expected_salary

jobseekers table: it contains the below columns:

jobseeker_id | year_of_experience | name

My view file codes:

 <tbody>
    <% @applicants_view.each do | applicants | %>
      <tr>
        <td><%=  applicants.jobseeker.name%></td>
        <td><%=applicants.jobseeker.year_of_experience %></td>
        <td><%= applicants.expected_salary %></td>
       </tr>
     <% end %>
  </tbody>

My controller codes:

def applicantsList

   @applicants_view = AppliedJob.paginate(page: params[:page],

:per_page => 4).order('applied_jobs_id DESC')

end

My applied_job model codes:

class AppliedJob < ActiveRecord::Base

    belongs_to :jobseeker
end

My jobseeker model codes:

class Jobseeker < ActiveRecord::Base

    has_one :applied_job

end

When I try to show data it's showing the below error

 C:/wamp/www/hire_us/app/views/applicants_list/applicantsList.html.erb
   where line #51 raised:

  undefined method `name' for nil:NilClass

  Rails.root: C:/wamp/www/hire_us
  Application Trace | Framework Trace | Full Trace

  app/views/applicants_list/applicantsList.html.erb:51:in `block in
 _app_views_applicants_list_applicants_ist_html_erb___1439381291_141337560'

  app/views/applicants_list/applicantsList.html.erb:49:in
    '_app_views_applicants_list_applicants_ist_html_erb___1439381291_141337560'

Someone can help me, please to identify where the bug?

That means that particular appliedjob record has no associated jobseeker to it. — Pavan
– Pavan, Commented Jan 26, 2016 at 8:42

Ho Man · Accepted Answer · 2016-01-26 10:03:43Z

2

You can avoid the error by adding

<% @applicants_view.each do | applicants | %>
   <% next unless applicants.jobseeker %>
   ...
<% end %>

or

<% @applicants_view.each do | applicants | %>
   <% applicants.jobseeker.try(:name) %>
   ...
<% end %>

edited Jan 26, 2016 at 10:03

answered Jan 26, 2016 at 9:01

Ho Man

2,35512 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Fameless Over a year ago

At first, thanks for answer, but my issue is still @Ho Man

Ho Man Over a year ago

does the wamp stack automatically restart the server / reload the files?

Fameless Over a year ago

didn't restart, but reloaded

Ho Man Over a year ago

applicants.jobseeker.try(:name). if it still fails on the same error, same line, its not reloading :P

Fameless Over a year ago

Let us continue this discussion in chat.

Collectives™ on Stack Overflow

Issue to show data from relational database tables in rails

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related