Forum: Ferret acts_as_ferret

D1ce0e5bb611e1c141fe3d0273cfb9ec?d=identicon&s=25 Gaurav Dua (gaurav_dua123)
on 2008-07-16 09:21
Hi, I had made one apllication for job posting. in which a user has to
fill a form. In that form there are section like Personal Information(in
which he has to to fill his personal information), Professional
Information. Both these section are in same page but they get stored in
two table in database. Personal Information get store in user table and
professional information get store in professional table. In the
professional information table there are field like skills,
interested_in,experience,current_project.
Suppose Mr.A fills the form with the professional field as
Skills              C, C++, Java, Jsp
interest_in         Java,Struts,ruby
Experience           5yr.
Current_project      Java

Mr.B fill the form like
skills           C, ruby, .net
interested_in       ruby,rubyonrails
Experience_in        3
current_project     Ruby.

Now these values get store in the database. Now i want to make reports
to find that how many person know which skills, how many are
interested_in which field, how many are in which project, how many yr.
of experience they are having. I had made a report like this
1. for skills
Skills          No. of Person
C                  02
C++                01
Java               01
Jsp                01
Ruby               01
.net               01

2. for interested_in
interested_in       No. of Person
Java                 01
Struts               01
ruby                 02
Robyonrails          01

like this for current project and experience.
 I had given a link to all suppose i click on c in the skill report to
check how many person know C. As i click on C it will take me to next
page where the name of all the person who know C will come out with his
little bit of more information about them.

till the report part it's working fine for all reports, i am getting the
right report.

Here in the ruby link which is in skills report you can see only one
person skills is ruby. but when i click on the ruby link it will show me
the two person on the next page.
WHY I AM GETTING TWO PERSON INSTEAD OF ONE?

What i am thinking is that these information are stored in one table.
but when we are searching for ruby the ferret has stored two name one
the person whose skills is ruby and the second ruby is for the person
who is interested_in. SO how can i search ruby only for skills column.
This topic is locked and can not be replied to.