Grid with filter?

Hi, I am trying to make a grid with filter above. I wrote this SAIL:
= load(
local!BUfilter,
local!pagingInfo: a!pagingInfo(
startIndex: 1,
batchSize: - 1,
sort: {
field: "InvestmentMain.InvID",
ascending: false
}
),
with(
local!datasubset: if(
isnull(
local!BUfilter
),
rule!getAllInvestments(
local!pagingInfo
),
rule!getInvestmentByBU(
local!BUfilter,
local!pagingInfo
)
),
a!dashboardLayout(
firstColumnContents: {
a!textField(
label: "Filter by Bu",
value: local!BUfilter,
saveInto: local!BUfilter,
refreshAfter: "KEYPRESS"
),
a!gridField(
totalCount: local!datasubset.totalCount,
columns: {
a!gridTextColumn(
label: "ID",
data: local!datasubset.data.InvestmentMain.InvID,
field: "InvestmentMain.InvID...

OriginalPostID-97336

OriginalPostID-97336

  Discussion posts and replies are publicly visible

Parents
  • You're referring to your fields with InvestmentMain.<fieldName>. Instead, you should only refer to the field name when you use the dot notation, not the CDT name (it seems to me that your CDT name is InvestmentMain, and it doesn't have a field called InvestmentMain).

    So in all the places where you have InvestmentMain.InvID or InvestmentMain.BusinessUnit or local!datasubset.data.InvestmentMain.InvID, remove "InvestmentMain", so you'd end up with configurations like this:

    field: "InvID"

    data: local!datasubset.data.BusinessUnit

    etc
Reply
  • You're referring to your fields with InvestmentMain.<fieldName>. Instead, you should only refer to the field name when you use the dot notation, not the CDT name (it seems to me that your CDT name is InvestmentMain, and it doesn't have a field called InvestmentMain).

    So in all the places where you have InvestmentMain.InvID or InvestmentMain.BusinessUnit or local!datasubset.data.InvestmentMain.InvID, remove "InvestmentMain", so you'd end up with configurations like this:

    field: "InvID"

    data: local!datasubset.data.BusinessUnit

    etc
Children
No Data