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
5 replies
Subscribers
8 subscribers
Views
2384 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
Hello: When I create a query rule of all rows of a CDT that contains
marky
over 10 years ago
Hello:
When I create a query rule of all rows of a CDT that contains a nested CDT in a one-to-many relationship, using the dot notation to access the Appian foreign key field results in an error "Cannot slice index (index by name on a list) when the element has no list type".
For example: rule!queryAllCDTs.oneToManyLinkToCDT
Logically, the field that is a foreign key to a one to many CDTs is just an array of CDTs, and should be able to be retrieved from the datasubset.
Thank you...
OriginalPostID-114430
OriginalPostID-114430
Discussion posts and replies are publicly visible
0
abhinavg
over 10 years ago
forum.appian.com/.../e-103475
Check 3 last comment from bottom in above post
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
marky
over 10 years ago
The comment left by Eduardo certainly works. The solution uses apply to loop through every element in the one-to-many nested CDT and build the array of elements. I agree that it works, but the performance is dreadfully slow for large data sets, which is a definite possibility for our data requirements. The point of this topic on the Appian forum to point out something that logically should be possible, but results in an error. Using a looping function would be much slower in almost all cases than having Appian moving the entire dataset through memory. Thank you.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
abhinavg
over 10 years ago
Marky ..even i'm facing the same issue at multiple times in my web service calls
Any workable solution you were able to find to suffice this requirement
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
marky
over 10 years ago
The only way is to iterate through every element using the looping functions ( apply ). As far as I can tell this is a problem inside of Appian, because logically there should not be an issue.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
abhinavg
over 10 years ago
True Marky .. even i have to use apply function numerous times for web service orchestration
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel