Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
6 replies
Subscribers
5 subscribers
Views
2230 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Plug-Ins
joinCDT
mayureshs
over 7 years ago
Hi
I have employee CDT and Skills CDT, One employee can have multiple skills.I have used joincdts() function to join both the CDT's, but some how it is throwing an error "Expression evaluation error at function 'joincdts' [line 4]: Error evaluating function 'joincdts' : null" Please find code below. any suggestions?
with(
local!employees:rule!MS_IAL_GetAllEmployeeDetails(),
local!skills:rule!MS_IAL_GetAllEmployeesSkills_CDTManipulation(),
joincdts(
joinType:"INNER",
leftCdt:local!employees,
selectFromLeft :{"firstName"},
rightCdt:local!skills,
selectFromRight:{"skillName"},
onLeft:"employee_Organization_ID",
equalsRight:"employee_Organization_ID",
leftAlias:{"employees"},
rightAlias:{"skills"}
)
)
OriginalPostID-248534
Discussion posts and replies are publicly visible
Parents
0
mayureshs
over 7 years ago
@Sally I have already tested "rule!MS_IAL_GetAllEmployeeDetails()", "MS_IAL_GetAllEmployeesSkills_CDTManipulation()" rules independently and it is returning expected data. actually these are query rules, i also tried with the query entity which is returning datasubset, but i don't think so this is valid solution, is it?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
mayureshs
over 7 years ago
@Sally I have already tested "rule!MS_IAL_GetAllEmployeeDetails()", "MS_IAL_GetAllEmployeesSkills_CDTManipulation()" rules independently and it is returning expected data. actually these are query rules, i also tried with the query entity which is returning datasubset, but i don't think so this is valid solution, is it?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data