How to query for data from database in ruby on rails without using the primary id

Question

I'm working on Rails 3.2.9 app with ruby 1.9.3 and mysql as my DB . I want to retrieve a particular column data called 'no_of_tc'from a model named "excel_file' but i dont have the primary key/id of tat row . All i have is the filename.

tc_no = ExcelFile.find(35).no_of_tc gives me the result but i dont have id all the time

tc_no = ExcelFile.find_by filename: 'excel_name' gives the error "unknown method - find_by"

How can i get the required data without having the primary key?? and why am I getting unknown method error for 'find_by'

Swati Sucharita · Accepted Answer · 2013-08-23 06:37:28Z

1

I am assuming :file_name is another attribute of ExcelFile class.

try:

tc_no = ExcelFile.find_by_file_name(#name_of_the_fie)

answered Aug 23, 2013 at 6:37

Swati Sucharita

648 bronze badges

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

1 Comment

Aks.. Over a year ago

Thanks a lot that worked:):) tc_no = ExcelFile.find_by_file_name(#name_of_the_fie).no_of_tc gave me the data i wanted

Collectives™ on Stack Overflow

How to query for data from database in ruby on rails without using the primary id

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related