In an issue or task view, show the assigned to names and the assignment job roles.
Assignment Name and Role
valueexpression=CONCAT({assignedTo}.{name}," - ",{role}.{name})
listdelimiter=
listmethod=nested(assignments).lists
valueformat=HTML
displayname=Assignment and Role
textmode=true
type=iterate
Assignment Name or Role and Week Days Elapsed
valueexpression=CONCAT(IF(ISBLANK({assignedTo}.{name}),{role}.{name},{assignedTo}.{name})," - ",CONCAT(ROUND(WEEKDAYDIFF({entryDate},$$NOW),0), " Days"))
listdelimiter=
listmethod=nested(assignments).lists
valueformat=HTML
displayname=Assignment and Weekdays to Now
textmode=true
type=iterate
Custom Forms (Any Object /w Custom Forms)
In a project, task, issue, etc. report, show the custom forms/categories attached to the object.
displayname=Custom Forms
listdelimiter=
listmethod=nested(objectCategories).lists
textmode=true
type=iterate
valueexpression={category}.{name}
valueformat=HTML
Queue Topic Custom Forms (Issue Object)
In an issue report, show the custom forms attached to the queue topic of the issue if one exists.
7 thoughts on “Text Mode in Views Using Collections”
This is great! I’m noticing that users with specific job role code section is adding additional comma’s before and after the user name. I’m unable to use the replace expression to get rid of them too. Any idea what is going on?
First, let me say how much I love your site — you provide a lot of extremely valuable information! Thank you!
I’m trying to use the “Approvals and Status (Project/Task/Issue Object)” method listed above in a Task Report. It is correctly showing the statuses, but does not list the approver names. Am I doing something wrong? Or is this not intended to show who approved?
Is it possible to do calculations on collections? For example, I’m trying to display the average percentage complete of the cross-project predecessors. I tried valueexpression=AVG({predecessor}.{percentComplete})
Hi, I really appreciate what you are putting on this site! I am trying to show a link to an originating issue converted to a project from a task report. Is that possible?
Hi Sam, glad you like the site! Unfortunately I was unable to get this to work. I believe the only way you would be able to do this is to first calculate the entire issue’s URL on the issue custom form in a calculated field. Once captured, you could then transfer that value to the converted project by ensuring a matching field exists on the project form. From there, you’d have a URL that you could render in the task report. It would require some work, but is possible I think.
This is great! I’m noticing that users with specific job role code section is adding additional comma’s before and after the user name. I’m unable to use the replace expression to get rid of them too. Any idea what is going on?
Have you tried using < div > as the list delimiter?
First, let me say how much I love your site — you provide a lot of extremely valuable information! Thank you!
I’m trying to use the “Approvals and Status (Project/Task/Issue Object)” method listed above in a Task Report. It is correctly showing the statuses, but does not list the approver names. Am I doing something wrong? Or is this not intended to show who approved?
Is it possible to do calculations on collections? For example, I’m trying to display the average percentage complete of the cross-project predecessors. I tried valueexpression=AVG({predecessor}.{percentComplete})
I don’t think it’s possible Adina.
Hi, I really appreciate what you are putting on this site! I am trying to show a link to an originating issue converted to a project from a task report. Is that possible?
Hi Sam, glad you like the site! Unfortunately I was unable to get this to work. I believe the only way you would be able to do this is to first calculate the entire issue’s URL on the issue custom form in a calculated field. Once captured, you could then transfer that value to the converted project by ensuring a matching field exists on the project form. From there, you’d have a URL that you could render in the task report. It would require some work, but is possible I think.