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
7 subscribers
Views
2296 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
Is it possible to use multiple datasubsets inside a SAIL grid. I have a gridFiel
aswinb
over 11 years ago
Is it possible to use multiple datasubsets inside a SAIL grid. I have a gridField that is currently using two datasubsets to display data but only values from one datasubset is getting populated right now. Following is my code of two datasubsets which are called milestone_datasubset and psa_datasubset:
load(
local!start,
local!end,
local!gridSelection: a!gridSelection
(
pagingInfo:a!pagingInfo
(
startIndex:1,
batchSize:10
)
),
local!list: if(rule!COMMON_IsNullOrEmpty(ri!start), null, if(rule!COMMON_IsNullOrEmpty(ri!end), null, rule!PSA_PSAAssignmentsPSACountBtwTimeFrame(cons!PSA_MILESTONE_TYPES[1],ri!start,ri!end))),
local!psa: if(rule!COMMON_IsNullOrEmpty(local!list.PSA_ID), {}, apply(rule!DCMIFS_getPSAByPSAId,local!list.PSA_ID)),
with(
{
local!milestone_datasubset:todatasubset(local!list, local!gridSelection.pagingInfo),
local!psa_datasubset:todatasubset(local!psa, local!gridSelection.pagingInfo),
}
)
)
And my gridField lo...
OriginalPostID-106601
OriginalPostID-106601
Discussion posts and replies are publicly visible
Parents
0
Ricardo Galvan
Appian Employee
over 11 years ago
How about you use one grid per data subset; this will allow the information to be presented in a clearer way. If it is needed for both data subsets to be presented in one grid and if the data subsets are Entity Backed, then you could also consider creating a view in your DB Server to merge the tables from where the information is obtained and return it as only one data subset.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Ricardo Galvan
Appian Employee
over 11 years ago
How about you use one grid per data subset; this will allow the information to be presented in a clearer way. If it is needed for both data subsets to be presented in one grid and if the data subsets are Entity Backed, then you could also consider creating a view in your DB Server to merge the tables from where the information is obtained and return it as only one data subset.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data