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
11 subscribers
Views
4765 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Data and Records
passing data from Record Type or passing just the ID and query?
erickp
over 7 years ago
So I have a record type backed by a view (It has around 15 columns). A lot of those data points I would like to display in the user interface (on the Summary view). What is better: pass those from the record type (using rf!variable) or querying directly on the summary SAIL rule?
OriginalPostID-236419
Discussion posts and replies are publicly visible
0
Josh
Certified Lead Developer
over 7 years ago
I like to have a rule that uses a type constructor and populated the values using rf! variables (type!myCDT(fieldA: rf!fieldA) and then pass the cdt to the summary interface.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
erickp
over 7 years ago
I like that idea. Thanks @joshl. Any other thoughts anyone else?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
aayusha
Certified Senior Developer
over 7 years ago
We once had the same scenario.. the related action tab was querying each related action (more than 35 RA's) which was taking huge time.
We then started passing everything from record using rf! which improved the performance from 10 secs to around 1.5 secs.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
miteshp
over 7 years ago
We are using different CDTs for record list view and summary view.
CDT for record list view is obtained using a DB view maintained in Appian Datasource. DB view is de normalized with only the columns to be viewed in record list view and the filters available. To keep the response light and performance better.
We call summary interface with the selected record ID and do a fresh call to fetch the detailed CDT (around 30 columns).
Thanks!
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
jagadeesh
Certified Senior Developer
over 7 years ago
I would preferred to go for type constructor as @joshl suggested.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Sumeet Khare
over 7 years ago
If you have 15 columns in cdt and you need all data then pass the entire cdt. Creating a new cdt will not improve your performance, it may reduced comparing to passing of id and calling if again from db.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel