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
4 replies
Subscribers
8 subscribers
Views
1561 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
AI and Rules
Hello, We have a use case where we use the torecord function to trans
thanosm
over 10 years ago
Hello,
We have a use case where we use the torecord function to transform an XML to a specific CDT. The problem is that the last 3 fields of the CDT do not contain the values of the respective elements in the XML.
The CDT contains approximately 70 fields.
Is there a limit to the number of fields that can be processed in a CDT within the torecord function? Is there generally some limit to the number of fields that a CDT should have?
Regards.
OriginalPostID-147426
OriginalPostID-147426
Discussion posts and replies are publicly visible
0
sikhivahans
over 10 years ago
@thanosm Keeping the torecord function (or best practices) aside, 70 shouldn't be a problem. I use a cdt which has 92 fields (of which some of them are nested CDTs) and there are no issues with it.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
thanosm
over 10 years ago
Any insights on the torecord function? And what do you mean by "best practices" in relation to this function?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sikhivahans
over 10 years ago
@thanosm Sorry, I didn't used this function till date. Best practices in the sense, we faced performance issues when we make queries over the data store entity (that has got 90+ fields) for display purposes, especially on record dashboards. Thereafter, we created one more cdt, corresponding data store entity which maps to the same table in the database, but just consists of frequently used columns and there was a drastic improvement in the performance.
Hope you will gain a better insight in subsequent comments by other Appian practitioners.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Eduardo Fuentes
Appian Employee
over 10 years ago
The torecord() function expects a second argument which will be a variable of the same target CDT, maybe your PV is of type CDT^1 meaning is a previous version that didn't have the 3 extra fields.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel