Post

2 followers Follow
0
Avatar

Get User Skills LEVEL and find all users by Skill name

Hi guys I have an some problem for getting  all skills levels for specific USER I mean(senior or junior).
And also how can I find all users which have specific skill for example Javascript and show that users and their level of skill.


Thanks

Hkhurshudyan Answered

Official comment

Avatar

Hi,

1. The easiest way is to query users with "Skills" relation:

POST /data/entityQuery
{
"typeName": "User",
"fields": ["Name"],
"where": {
"leftExpression": { "fieldName": "ExternalId" },
"operator": "Equal",
"rightExpression": {"value" : "3f7f08fd-92f0-434d-9b7b-b487cef22d31"}
},
"relations":[ { "name":"Skills", "fields": ["Name"] } ]
}

2. This case is somehow the opposite of the previous one. You can query skills with "UserGroups" relation:

POST /data/entityQuery
{
"typeName": "Skill",
"fields": ["Name"],
"where": {
"leftExpression": { "fieldName": "Name" },
"operator": "Equal",
"rightExpression": {"value" : "Javascript"}
},
"relations":[ { "name":"UserGroups", "fields": ["Name"] } ]
}

Regards.

 

Alex Broitman

Please sign in to leave a comment.

1 comment