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,
Suppose Mr.A fills the form with the professional field as
Skills C, C++, Java, Jsp
Mr.B fill the form like
skills C, ruby, .net
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
Skills No. of Person
interested_in No. of Person
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
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.