I am trying to create a task report and I have taken reference from:

Hi

I am trying to create a task report and I have taken reference from:
forum.appian.com/.../Task_Report_Tutorial.html

In my task report I have a column Assigned To. The values in this column are either Group or User which are being displayed but group is being displayed as Goup: id and user as username, PFA screenshot for your reference.
Can some one please suggest how do I display user's as well as group's name?

Thanks in advance....

OriginalPostID-199642



  Discussion posts and replies are publicly visible

Parents
  • Hi @sikhivahans

    Thank you for replying!!
    I tried with the help of SAIL recipe and your code snippet above. However, I am still not able to display the required data.
    I am trying to fetch the image for my column average Lag time. By default it is of type Normal Text, I have used the formatting Duration for it so that it helps me when I am calling the rule for the image.

    Below is the code where I am calling my sub rule:



    with(
    local!columnData: index(ri!data, ri!columnConfig.field, {}),
    local!columnDataCount: count(local!columnData),
    if(
    ri!columnConfig.configuredFormatting = "Duration",
               a!gridImageColumn(
    label: ri!columnConfig.label,
    field: ri!columnConfig.field,
    size: "ICON",
    data: apply(
    rule!AT_dispalyIndicatorImage(data: local!columnData, index: _),
    1 + enumerate(local!columnDataCount)
    )
    ),
    a!gridTextColumn(
    label: ri!columnConfig.label,
    field: ri!columnConfig.field,
    data: if(
    local!columnDataCount > 0,
    apply(
    if(
    ri!columnConfig.configuredFormatting = "TASK_STATUS",
    rule!AT_getTaskStatusDisplay(data: local!columnData, index: _),
    if(ri!columnConfig.configuredFormatting = "USER_OR_GROUP_NAME",
    rule!AT_displayUserName(data: local!columnData, index: _),
    rule!AT_displayTextCell(data: local!columnData, index: _)
    )
    ),
    1 + enumerate(local!columnDataCount)
    ),
    {}
    ),

    links: if(
    ri!columnConfig.configuredDrilldown = "TASK_DETAILS",
    apply(
    a!processTaskLink(task: _),
    index(ri!data, ri!columnConfig.drilldownField, {})
    ),
    null
    )

    )
    )
    )




    My sub rule where I am calling a!documentImage to display the image is:

    if(
              (ri!data[ri!index]>20),
              a!documentImage(document: a!iconIndicator(icon: "MOVE_UP"), altText: "High"),
              a!documentImage(document: a!iconIndicator(icon: "MOVE_UP"), altText: "Low")
    )


    Here data is Any Type and index of Number(Integer).

    However, the image is still not displayed.
Reply
  • Hi @sikhivahans

    Thank you for replying!!
    I tried with the help of SAIL recipe and your code snippet above. However, I am still not able to display the required data.
    I am trying to fetch the image for my column average Lag time. By default it is of type Normal Text, I have used the formatting Duration for it so that it helps me when I am calling the rule for the image.

    Below is the code where I am calling my sub rule:



    with(
    local!columnData: index(ri!data, ri!columnConfig.field, {}),
    local!columnDataCount: count(local!columnData),
    if(
    ri!columnConfig.configuredFormatting = "Duration",
               a!gridImageColumn(
    label: ri!columnConfig.label,
    field: ri!columnConfig.field,
    size: "ICON",
    data: apply(
    rule!AT_dispalyIndicatorImage(data: local!columnData, index: _),
    1 + enumerate(local!columnDataCount)
    )
    ),
    a!gridTextColumn(
    label: ri!columnConfig.label,
    field: ri!columnConfig.field,
    data: if(
    local!columnDataCount > 0,
    apply(
    if(
    ri!columnConfig.configuredFormatting = "TASK_STATUS",
    rule!AT_getTaskStatusDisplay(data: local!columnData, index: _),
    if(ri!columnConfig.configuredFormatting = "USER_OR_GROUP_NAME",
    rule!AT_displayUserName(data: local!columnData, index: _),
    rule!AT_displayTextCell(data: local!columnData, index: _)
    )
    ),
    1 + enumerate(local!columnDataCount)
    ),
    {}
    ),

    links: if(
    ri!columnConfig.configuredDrilldown = "TASK_DETAILS",
    apply(
    a!processTaskLink(task: _),
    index(ri!data, ri!columnConfig.drilldownField, {})
    ),
    null
    )

    )
    )
    )




    My sub rule where I am calling a!documentImage to display the image is:

    if(
              (ri!data[ri!index]>20),
              a!documentImage(document: a!iconIndicator(icon: "MOVE_UP"), altText: "High"),
              a!documentImage(document: a!iconIndicator(icon: "MOVE_UP"), altText: "Low")
    )


    Here data is Any Type and index of Number(Integer).

    However, the image is still not displayed.
Children
No Data