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
2228 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
0
Tom Ryan
Appian Employee
over 7 years ago
Can you attach the complete application server log from when you reproduced the error.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
mayureshs
over 7 years ago
Hi tom PFA for complete application server log.
application-server.log
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Sally Mason
Appian Employee
over 7 years ago
Appears to be that there is missing data causing the interface to fail..
Can you test "rule!MS_IAL_GetAllEmployeeDetails()" and "MS_IAL_GetAllEmployeesSkills_CDTManipulation()" independently and confirm that these two rules are returning the expected data and if no skills are returned, the null is handled?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
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
0
Sally Mason
Appian Employee
over 7 years ago
Maybe there is another way to approach this issue? If an employee has many skills, you could make a view at the database level to retrieve and display all the skills and perform the join at that level and create a CDT to display the results?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
mayureshs
over 7 years ago
@Sally thanks for your suggestion,but the requirement to perform a join at interface level not at DB level, as it increases burden on Database.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel