We are currently performing maintenance on Appian Community. As a result, discussions posts and replies are temporarily unavailable. We appreciate your patience.

One column will not sort in grid.

I have a Tempo report that contains 15 grids, 14 of which will sort the data on clicking the column headers. This one does not. What am I doing wrong?
rule!APN_uiSectionOneColumn(label: "Projects Launching in the Next 30 Days", contents: {

with(
projects: rule!GET_NEXT_30_DAYS(
'type!PagingInfo'(
startIndex: 1,
batchSize: -1
)
),
if(rule!APN_isEmpty(projects), {},
load(
gridPagingInfo: topaginginfo(1,-1),

rule!APN_uiPagingGrid(
           label:"",
columns:{
rule!APN_uiGridTextColumn(
label: "Projected Launch Date",
data: projects.data.projectedLaunchDate,
field: "projectedLaunchDate"
),
rule!APN_uiGridTextColumn(
label: "Category",
data: projects.data.category,
field: "category"
),
rule!APN_uiGridTextColumn(
label: "Product",
data: projects.data.site,
field: "site"
),
                     rule!A...

OriginalPostID-85350

OriginalPostID-85350

  Discussion posts and replies are publicly visible

Parents
  • @mikek137, hi.. I think the grid might not be working in your case due to following reason:
    Expressions which needs to be reevaluated (that are to be placed inside with()) are present inside load()
    I have done a quick test and your grid is working fine after doing some minor changes. Check with the following code and let me know if you have any follow-up questions:

    rule!APN_uiSectionOneColumn
    (
    label: "Projects Launching in the Next 30 Days",
    contents: {

    load(
    local!gridPagingInfo: topaginginfo(1,-1),
    projects: rule!GET_NEXT_30_DAYS(),
    if(rule!APN_isEmpty(projects), {},
    with(
    projects: rule!GET_NEXT_30_DAYS(gridPagingInfo),
    rule!APN_uiPagingGrid(
    \tlabel:" ",
    columns:{
    rule!APN_uiGridTextColumn(
    label: "Projected Launch Date",
    data: projects.data.projectedLaunchDate,
    field: "projectedLaunchDate"
    ),
    rule!APN_uiGridTextColumn(
    label: "Category",
    data: projects.data.category,
    field: "category"
    ),
    rule!APN_uiGridTextColumn(
    label: "Product",
    data: projects.data.site,
    field: "site"
    ),
    \trule!APN_uiGridTextColumn(
    label: "Title",
    data: projects.data.title,
    field: "title"
    ),
    \trule!APN_uiGridTextColumn(
    label: "Theme",
    data: projects.data.theme,
    field: "theme"
    ),
    \trule!APN_uiGridTextColumn(
    label: "Phase",
    data: projects.data.phase,
    field: "phase"
    )

    },
    pagingInfo: gridPagingInfo,
    totalCount: projects.totalCount
    )
    )
    )
    )
    }
    )
Reply
  • @mikek137, hi.. I think the grid might not be working in your case due to following reason:
    Expressions which needs to be reevaluated (that are to be placed inside with()) are present inside load()
    I have done a quick test and your grid is working fine after doing some minor changes. Check with the following code and let me know if you have any follow-up questions:

    rule!APN_uiSectionOneColumn
    (
    label: "Projects Launching in the Next 30 Days",
    contents: {

    load(
    local!gridPagingInfo: topaginginfo(1,-1),
    projects: rule!GET_NEXT_30_DAYS(),
    if(rule!APN_isEmpty(projects), {},
    with(
    projects: rule!GET_NEXT_30_DAYS(gridPagingInfo),
    rule!APN_uiPagingGrid(
    \tlabel:" ",
    columns:{
    rule!APN_uiGridTextColumn(
    label: "Projected Launch Date",
    data: projects.data.projectedLaunchDate,
    field: "projectedLaunchDate"
    ),
    rule!APN_uiGridTextColumn(
    label: "Category",
    data: projects.data.category,
    field: "category"
    ),
    rule!APN_uiGridTextColumn(
    label: "Product",
    data: projects.data.site,
    field: "site"
    ),
    \trule!APN_uiGridTextColumn(
    label: "Title",
    data: projects.data.title,
    field: "title"
    ),
    \trule!APN_uiGridTextColumn(
    label: "Theme",
    data: projects.data.theme,
    field: "theme"
    ),
    \trule!APN_uiGridTextColumn(
    label: "Phase",
    data: projects.data.phase,
    field: "phase"
    )

    },
    pagingInfo: gridPagingInfo,
    totalCount: projects.totalCount
    )
    )
    )
    )
    }
    )
Children
No Data