Filter the tasks which have not been accepted by any user

Certified Senior Developer

Have a task report for fetching the tasks assigned to a pool of users including logged in user.

We have a requirement to filter the tasks which have not been accepted by any user.

Am using following query filter in queryProcessAnalytics()

a!queryFilter(field:"c6",operator:"is null")
where "c6" denotes the Owner of the task i.e tp!owner

But its not working as expected. The report does not return anything.

Please suggest.

OriginalPostID-217325

OriginalPostID-217325

  Discussion posts and replies are publicly visible

Parents
  • tp!assignees - List of users and groups who have been assigned the task. The object returned takes the User or Group data type.

    tp!owner(Appian definition) -
    When a task is assigned, the Task Owner property has a null value until the assigned user views the task or until a user in the assigned group accepts the task.
    The Task Owner property can only be used to identify the user who completed a given task. If the task has been assigned to more than one user (if there were multiple users or a group of users) the Assignees property should be used to determine the users that accepted the task.

    Other than tp!owner you can look into "task_assignee_owner()" - Assignee(s) before a task has been accepted or the task owner after the task is accepted.

    And please check the security to the portal report, some times your user might not have permission to the knowledge center/folder where the ".arf" or Appian Report File exists.
Reply
  • tp!assignees - List of users and groups who have been assigned the task. The object returned takes the User or Group data type.

    tp!owner(Appian definition) -
    When a task is assigned, the Task Owner property has a null value until the assigned user views the task or until a user in the assigned group accepts the task.
    The Task Owner property can only be used to identify the user who completed a given task. If the task has been assigned to more than one user (if there were multiple users or a group of users) the Assignees property should be used to determine the users that accepted the task.

    Other than tp!owner you can look into "task_assignee_owner()" - Assignee(s) before a task has been accepted or the task owner after the task is accepted.

    And please check the security to the portal report, some times your user might not have permission to the knowledge center/folder where the ".arf" or Appian Report File exists.
Children
No Data