Is it possible to use multiple datasubsets inside a SAIL grid. I have a gridFiel

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
  • 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.
Reply
  • 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.
Children
No Data