Error:The passed parameter(s) are of the wrong type. Received the type List of User or Group.

Certified Associate Developer

a!gridColumn(
label: "Assignees",
sortField: "c4",
value:group(fv!row.c4, "groupName")
),

Using this code in a gridfield.

Getting the data from queryprocessanalytics to populate a grid. Field c4 contains the group number. i am trying to get the corresponding group name. Pls help.

  Discussion posts and replies are publicly visible

Parents Reply Children
  • 0
    Certified Associate Developer
    in reply to Harshit Bumb (Appyzie)

    How to display the Group Name in place of Group ID in task report in interface?

  • 0
    Certified Lead Developer
    in reply to Anuradha C

    The code you have attached is being used for filtering whereas the last line says that you want to show the group name instead of the group number. 

    Both of them are separate things. I am suggesting an approach below which you can try. 

    • Try to filter on the ID itself. Do not cast it to name. 
    • When consuming the output, then use the runtimetypeof() function to determine if it is a group or user and then use the relevant function. 
  • 0
    Certified Associate Developer
    in reply to Harshit Bumb (Appyzie)

    a!localVariables(
    local!taskStatuses: {
    "Assigned",
    "Accepted",
    "Completed",
    "Not Started",
    "Cancelled",
    "Paused",
    "Unattended",
    "Aborted",
    "Cancelled By Exception",
    "Submitted",
    "Running",
    "Error",
    "Other",
    "Other",
    "Skipped"
    },

    {

    a!gridField(
    label: "Read-only Grid",
    labelPosition: "ABOVE",
    data: a!queryProcessAnalytics(

    report:cons!LOS_TASKREPORT_CONSTANT,
    query:a!query(
    pagingInfo: fv!pagingInfo
    )
    ),

    columns: {
    a!gridColumn(
    label: "Task Name",
    sortField: "c0",
    value: fv!row.c0
    ),
    a!gridColumn(
    label: "Status",
    sortField: "c1",
    value: index(local!taskStatuses,(fv!row.c1+1),"Other"),
    align: "END"
    ),
    a!gridColumn(
    label: "Start Time",
    sortField: "c3",
    value: if(
    isnull(fv!row.c3),
    fv!row.c3,
    datetext(fv!row.c3, "default")
    ),
    align: "END"
    ),
    a!gridColumn(
    label: "Process Name",
    sortField: "c2",
    value: fv!row.c2
    ),
    a!gridColumn(
    label: "Assignees",
    sortField: "c4",
    value:touser(fv!row.c4)
    ),
    a!gridColumn(
    label: "Task ID",
    sortField: "c5",
    value: fv!row.c5
    )
    },
    validations: {}
    )
    }
    )

  • 0
    Certified Associate Developer
    in reply to Anuradha C

    Here the assignees field is displaying the User mail id OR group number. I want the User name OR the Group Name to be displayed. What do i do?