Skill_job and skill_upload fields are not filled by the user. Let me explain a little bit the global structure of the app so it could be clearer.
The app works like this:
Step 1- The user enters some skills. When he cliks on “add a skill” it adds a new line in the “UserProfileSkills” table. There’s a next button which navigate to a new page called “advanced search”
Step 2- In the “advanced search” page, he can look for a job by typing the title inside a search bar or by choosing the “skill”, the “diploma” and the “Industry” in
Step 3-the user gets a list of jobs, choose a job and click on an icon (the 3 vertical dots in the RG) to see the details in a job_description page. When he clicks on this icon, it adds a new line in the “UserJobSelection” table from the RG.
At the bottom of the job_description page, he has a button “test my skills”. When he clicks on this, it starts a quiz with x questions.
Step 4 - On the last page of the quiz, there is a button “Next”. When it’s clicked, it creates a new calcul_skills_score thing (I use add instead of add list or set list which gave blank values)
and goes to a new page called “resultat” .
At this point, the calcul_skills_score contains texts separated by coma in skills_job and skills_upload columns.
Step 5 - Finally on the resultat page, I would like to get the number of skills in the “skills_job” column which match those on “skill_upload” and convert it in percentage. That’s the starting point of my post. How can I match those two columns?
It works if I add a new entry manually in the calcul_skills_score table. It shows 0 if I push the values with the button when I’m logged in as a user.
Edit: I managed to get a yes/no information if the user’s skills are among the job’s skills by using a RG.
So it gives that:
How can I count the number of “yes” elements in the RG?