Report to display users with less than 10 skills

[CV1]

Hello All,

Looking for help to create a report that list users with less than 10 skills.

TIA

[Dr Atul G- LNG]

Hi @CV1 

Create a report on the User table. Then, use the related list sys_user_has_skill to retrieve the count.

I do not currently have the skill set set up, but you can generate the report in this way

or use:

Use Database View (Recommended for Accurate Count)

1. Create a Database View joining:

   • sys_user

   • sys_user_has_skill

2. Join condition:

   • sys_user.sys_id = sys_user_has_skill.user

3. Create a report on this Database View.

4. Use:

   • Group by → User

   • Aggregation → Count

5. This will show the number of skills per user.

[CV1]

Hi @Dr Atul G- LNG ,

I tried above with a list view type report but see its not filtering users with less than 10 skills.
Please see the screen shots attached

[Tanushree Maiti]

Hi @CV1 ,

Share your report screen shot what you are getting.

As @Dr Atul G- LNG stated the process, that Database view table ONLY will help you to build the report as per your requirement i.e users with less than 10 skills

[CV1]

I shared the report screen shot as well - "report.png"