# Ferret

**URL:** <https://www.ruby-forum.com/t/ferret/196745>\
**Category:** Deployment\
**Created:** [July 17, 2008, 6:49am UTC](https://www.ruby-forum.com/t/ferret/196745 "2008-07-17T06:49:27Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![gaurav\_dua123](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/bb73d2/32.png) [@gaurav\_dua123](https://www.ruby-forum.com/u/gaurav_dua123)\
**Post date:** [July 17, 2008, 6:49am UTC](https://www.ruby-forum.com/t/ferret/196745/1 "2008-07-17T06:49:27Z")

</div>

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.