Tasks which are assigned to in appropriate Users

Why are you attempting to assign a task to a non Appian user? Filter out the non Appian user from your assignments and it will show correctly

Hi @ Harshav
we can show tasks of Assignee and Tasks with Multiple Assignees also

have a look at the below link
forum.appian.com/.../Task_Report_Tutorial.html

we can show tasks based on process model Status also.

@harshav Do you have the assignees information in PV? Let me know so that I can try to point something if possible based on this. If it's the query directly being made in the epression editor of 'Assing to following', I believe it would be tough. Also can you add based on what parameters you are retrieving the assignee information from db?

Also, +1 for @rodgraham's view which was also made by me earier at /search?q=OriginalPostID-249881 and I would suggest including this in your design now.

@kchaitanyam The issue here is about a task that holds the inexistent user as a task assignee. You may replicate it by taking the following simple steps:
1. Create a process model that has a user input task.
2. Configure the assignees of the task as touser({"123",}).

Now, neither the process instance dashboard(which you can see from Process Details) nor task report shows the information about this task. And the query is how to get this kind of task information. And it hasn't got to do anything with display as the task won't be visible in the first place.

@harshav To know about those tasks that have inexistent users as task assignees, you may do as follows to get the information:

1. Use 'Get Processes By Node Status' smart service at http://bit.ly/2gC4t9H. Inputs to it are:
a. process model uuid (Process model you would like to target)
b. Process Node uuid (uuid of the User Input Task that holds dynamic assignee information)
c. Process Node Status (TASK STATUS ASSIGNED = 0)

Run the smart service and capture the 'Activity IDs' in the output. These 'Activity IDs' are the task ids. Now among these task ids, there are ones that are being shown in the report and not shown in the report(the second scenario of yours).

2. Create a report of category Tasks Per Process Model (on the Process Model which you would like to know about invisible tasks). Add task id as a column to the report.

3. Query the report created in the above step and get all the active task ids.

4. difference(output of step 1, output of step 3) are nothing but the tasks that have gone invisible and one of the reasons is the second scenario.


If the in-flights are concerning the Business, choose one among the following solutions to fix the tasks that we get as output from above:
1. Use Reassign Task smart service and reassign the tasks whose task ids are nothing but the output that we get from the above-mentioned 4th step.
2. Make an inflight modification to the processes(whose tasks have gone invisible) in such a way that these processes include a new version of User Input Task which queries the DB for assignee information but removes inexistent users. Or you may update the assignees variable(provided if you are storing the assignee information in a variable), cancel the existing task and restart the task. There are numerous ways of doing this and you may opt for any. The reason why I am mentioning this option is, Reassign Task smart service didn't work on the invisible tasks when I replicated this scenario.

@Harsha, Please try this way,
1. Fetch user list from DB
2. Get all active users from user list by Iterating and save each user into multiple 'pv' of user type
3. Now assign that result user 'pv' in Assignment tab

I hope it should work......

@sikhivahan, first of all thank you for the valuable input, yes the values are set in the expression editor of the assignment tab. and for your second post I will try this and post it here about the steps what I have done thank you all for the responses.

@harshav No worries, there is a way to do it as I have replciated the scenario and got the desired output. In case if you need anything, don't hesiate to come with follow up questions.

The second scenario you have mentioned is a good learning, because neither reassign available on Task nor Reassing Task smart service are working on a task that has inexistent users as task assignees which means that we should be quite careful in case of inexistent users.