Wildcard within IF expression in nested collection

Question

I'm having trouble getting a user wildcard to work in a valueexpression within a nested list statement. My end goal is to show a column with all those co-assigned to a user's tasks, but not show their own name. Using the collection of Assignments within a task, I can make this code work and it correctly lists only the other people that are co-assigned with the user with that specific ID: displayname=Co-Assignmentslistdelimiter=

listmethod=nested(assignments).liststype=iteratevalueexpression=IF({assignedTo}.{ID}="5d13826400d6f67f13d0f5847989da56", "", CONCAT({assignedTo}.{name}))valueformat=HTML But when I switch out the hard coded ID number for the variable $$USER.ID the column is blank. displayname=Co-Assignmentslistdelimiter=

listmethod=nested(assignments).liststype=iteratevalueexpression=IF({assignedTo}.{ID}=$$USER.ID, "", CONCAT({assignedTo}.{name}))valueformat=HTML I've also tried "$$USER.ID" and {$$USER.ID} to no avail. Does anyone know if the syntax of this wildcard is wrong when used in an IF statement or why the variable wildcard would not work?

JustinRenteria2 · Accepted Answer

I kept testing this and couldnt get the wildcard to work in the calculation. I decided to look at the documentation and found this snippet: "Wildcard filter variables are not supported when referencing nested collections in a calculated column". Unless Im misinterpreting the verbiage it looks like you cannot use the wildcard in the collection.

Link: Wildcard filter variables | Adobe Workfront

JustinRenteria2 · Answer

Looking at the API Explorer I'd try using {assignedToID} not {assignedTo}.{ID}.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded