Need some Info/Help on the Skills Table

[terrieb]

So we want to add the Skills field to Catalog tasks so mangers can assign to staff based on their current skill level.

We like the ones under the Technical Skill level (table: cmn_skill_level) and while I was able to configure that list view to show the main levels, we want to be able to only see the ones under the Technical not the other ones, like Language, etc.

I don't see a way to create a view that can be saved on this table or filter it out for everyone's use (default)

Anyone have a suggestion??

[SVimes]

If I understand correctly, what you are asking for something on the sys_dictionary entry for the skills field. You can add a reference specification where the reference qual condition is a specific filter. In the advanced view, you can change it from a Simple reference qualifier (basic filtering) to dynamic or advanced so you can provide additional parameters via script includes if needed.

[kaushal_snow]

@terrieb ,

Yes, you can achieve by adding a reference qualifier on the field that references it.....for example, edit the dictionary entry for the field on your catalog task, set an advanced reference qualifier like skill_level_type.name = Technical (or similar based on your data) so only those entries appear in the dropdown......

If you found my response helpful, please mark it as ‘Accept as Solution’ and ‘Helpful’. This helps other community members find the right answer more easily and supports the community.

[terrieb]

Yes that did work so now only Technical appears in the search icon on that field on the task form.

However, I am looking for a way to add that to the Task within the Flow.  It allows me to select the Skills field but doesn't allow me to add a particular one, like Basic.

Thanks!

[Mohammed8]

Hi @terrieb ,

I can see your cmn_skill_level table has some label modifications, but the steps below should give you the general idea

1) If you are using OOTB skill field, Go to Task table and open the Skills field, In the override dictionary for sc_task table record, set 

 (from your screenshot , Reference qualifier you can use <name=Technical^EQ> )

2) In the Skill Level table, notice multiple types like Technical and Language the above step keeps only Technical

3) Go to the Catalog Task form, click the magnifying-glass icon next to the Skills field → in the lookup window, right-click any column header → Configure → List Layout to add or remove columns

4) After saving, the lookup popup now displays only Technical skill levels along with the columns you configured

If you find this answer useful, please mark Solution Accepted/ Helpful

Thanks and Regards,

Mohammed Zakir