General

Re: Using double eval to get users who don't exist.

ldkud50 — Wed, 31 Oct 2012 19:44:04 GMT

Jimmy you are the man! Worked perfectly... Thank you.

Re: Using double eval to get users who don't exist.

Jimmy — Wed, 31 Oct 2012 19:29:47 GMT

Hi ldkud,

So to clarify, you want to list all of the people in AccMgrs who are not in Weekly Summary Report. Is that right? If so, I think this might work:

substring(xdMath:Eval(xdMath:Eval(xdXDocument:GetDOM("AccMgrs")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Name[not(. = xdXDocument:GetDOM("Weekly Summary Report")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Author/pc:Person/pc:DisplayName)], 'concat(";", " ", .)'), ".."), 2)

Using double eval to get users who don't exist.

ldkud50 — Wed, 31 Oct 2012 18:22:46 GMT

I have a secondary data source for a Weekly Summary Report. The users are required to submit weekly. I want to be able to return the users who don't exist in that weeks query. To display in calculated value of "User who didn't submit". I used this - substring(xdMath:Eval(xdMath:Eval(xdXDocument:GetDOM("Weekly Summary Report")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Author/pc:Person/pc:DisplayName[. != xdXDocument:GetDOM("AccMgrs")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Name], 'concat(";", " ", .)'), ".."), 2) . This returns all the names vs just the names that don't exist. To sum it up I want to compare the list of submitted "Weekly Summary Report" to "AccMgrs" which is the list of all the names. Hoping someone can pick this apart and help.