The grid of tasks displaying correctly, and the filter text field is displaying, however the filter doesn't work.

I'm am using a portal report of "My Tasks" to display in tempo, in a grid form, and I want to provide a filter options so the users that are working across multiple applications can filter their tasks by application. I have the grid of tasks displaying correctly, and the filter text field is displaying, however the filter doesn't work. Could anyone help? Thanks!...

OriginalPostID-117070

OriginalPostID-117070

  Discussion posts and replies are publicly visible

Parents
  • see the below script - use just to follow as sample, do not copy paste as is.

    local!FIELD_IDX_TASK_NAME: 0,
    local!FIELD_IDX_TASK_PRIORITY: 4,
    local!FIELD_IDX_TASK_STATUS: 5,
    local!FIELD_IDX_TASK_ASSIGNED_TO: 6,

    local!reportFilters: {
    if(
    isnull(
    local!titleSearch
    ),
    {},
    {
    field: local!FIELD_IDX_TASK_NAME,
    operator: "LIKE",
    value: "*" & local!titleSearch & "*"
    }
    ),
    if(
    isnull(
    local!statusFilter
    ),
    {},
    {
    field: local!FIELD_IDX_TASK_STATUS,
    operator: "EQUAL",
    value: local!statusFilter
    }
    ),
    if(
    isnull(
    local!assignedToFilter
    ),
    {},
    {
    field: local!FIELD_IDX_TASK_ASSIGNED_TO,
    operator: "EQUAL",
    value: local!assignedToFilter
    }
    ),
    if(
    isnull(
    local!priorityFilter
    ),
    {},
    {
    field: local!FIELD_IDX_TASK_PRIORITY,
    operator: "EQUAL",
    value: local!priorityFilter
    }
    )
    },
              
              local!datasubset: getPortalReportDatasubset(
    reportId: local!portalReportId,
    pagingInfo: local!pagingInfo,
    contextIds: {},
    filter: local!reportFilters
    ),
              
              a!gridLinkColumn(
    label: local!datasubset.columns[local!COL_IDX_TASK_NAME].label,
    field: local!datasubset.columns[local!COL_IDX_TASK_NAME].field,
    data: if(
    local!datasubset.totalCount = 0,
    {},
    apply(
    a!processTaskLink(
    label: _,
    task: _
    ),
    merge(
    local!datasubset.data[local!COL_IDX_TASK_NAME].cells.value,
    local!datasubset.data[local!COL_IDX_TASK_NAME].cells.drilldown
    )
    )
    ),
    alignment: local!datasubset.columns[local!COL_IDX_TASK_NAME].alignment
    ),
Reply
  • see the below script - use just to follow as sample, do not copy paste as is.

    local!FIELD_IDX_TASK_NAME: 0,
    local!FIELD_IDX_TASK_PRIORITY: 4,
    local!FIELD_IDX_TASK_STATUS: 5,
    local!FIELD_IDX_TASK_ASSIGNED_TO: 6,

    local!reportFilters: {
    if(
    isnull(
    local!titleSearch
    ),
    {},
    {
    field: local!FIELD_IDX_TASK_NAME,
    operator: "LIKE",
    value: "*" & local!titleSearch & "*"
    }
    ),
    if(
    isnull(
    local!statusFilter
    ),
    {},
    {
    field: local!FIELD_IDX_TASK_STATUS,
    operator: "EQUAL",
    value: local!statusFilter
    }
    ),
    if(
    isnull(
    local!assignedToFilter
    ),
    {},
    {
    field: local!FIELD_IDX_TASK_ASSIGNED_TO,
    operator: "EQUAL",
    value: local!assignedToFilter
    }
    ),
    if(
    isnull(
    local!priorityFilter
    ),
    {},
    {
    field: local!FIELD_IDX_TASK_PRIORITY,
    operator: "EQUAL",
    value: local!priorityFilter
    }
    )
    },
              
              local!datasubset: getPortalReportDatasubset(
    reportId: local!portalReportId,
    pagingInfo: local!pagingInfo,
    contextIds: {},
    filter: local!reportFilters
    ),
              
              a!gridLinkColumn(
    label: local!datasubset.columns[local!COL_IDX_TASK_NAME].label,
    field: local!datasubset.columns[local!COL_IDX_TASK_NAME].field,
    data: if(
    local!datasubset.totalCount = 0,
    {},
    apply(
    a!processTaskLink(
    label: _,
    task: _
    ),
    merge(
    local!datasubset.data[local!COL_IDX_TASK_NAME].cells.value,
    local!datasubset.data[local!COL_IDX_TASK_NAME].cells.drilldown
    )
    )
    ),
    alignment: local!datasubset.columns[local!COL_IDX_TASK_NAME].alignment
    ),
Children
No Data