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

aswinb over 10 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...

Discussion posts and replies are publicly visible

Parents

0 aswinb over 10 years ago

...oks like this:

a!gridField(
                                                            label:"Table",
                                                            instructions:"",
                                                            totalCount:length(local!list.PSA_ID),
                                                            selection: false,

                                                            columns:{
                                                            a!gridTextColumn(label:"PSA Number",
                                                                                          field:"psaNumber",
                                                                                          data:{index(local!psa_datasubset.data, "psaNumber", {})},
                                                                                          alignment:"LEFT"),
                                                                                          a!gridTextColumn(label:"Assigned to Office Date",
                                                                                          field:"Milestone_Date",
                                                                                          data:{index(local!milestone_datasubset.data, "Milestone_Date", {})},
                                                                                          alignment:"LEFT"),

                                                            a!gridTextColumn(label:"MM-YYYY",
                                                            field:"Milestone_Date",
data:{datetext(index(local!milestone_datasubset.data, "Milestone_Date", {}), "MM/yyyy") },
alignment:"LEFT"),




                                                                                          a!gridTextColumn(label:"Office",
                                                                                          field:"primaryTechnicalOffice",
                                                                                          data:{index(local!psa_datasubset.data, "primaryTechnicalOffice", {})},
                                                                                          alignment:"LEFT")
                                                                                          },
                                                                                          value:local!gri...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 aswinb over 10 years ago

...oks like this:

a!gridField(
                                                            label:"Table",
                                                            instructions:"",
                                                            totalCount:length(local!list.PSA_ID),
                                                            selection: false,

                                                            columns:{
                                                            a!gridTextColumn(label:"PSA Number",
                                                                                          field:"psaNumber",
                                                                                          data:{index(local!psa_datasubset.data, "psaNumber", {})},
                                                                                          alignment:"LEFT"),
                                                                                          a!gridTextColumn(label:"Assigned to Office Date",
                                                                                          field:"Milestone_Date",
                                                                                          data:{index(local!milestone_datasubset.data, "Milestone_Date", {})},
                                                                                          alignment:"LEFT"),

                                                            a!gridTextColumn(label:"MM-YYYY",
                                                            field:"Milestone_Date",
data:{datetext(index(local!milestone_datasubset.data, "Milestone_Date", {}), "MM/yyyy") },
alignment:"LEFT"),




                                                                                          a!gridTextColumn(label:"Office",
                                                                                          field:"primaryTechnicalOffice",
                                                                                          data:{index(local!psa_datasubset.data, "primaryTechnicalOffice", {})},
                                                                                          alignment:"LEFT")
                                                                                          },
                                                                                          value:local!gri...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data