Re: Complex double eval...

Jimmy — Mon, 06 Feb 2012 16:52:30 GMT

I think you can just do the same thing here as you did with the Business field:

xdMath:Eval(xdMath:Eval(xdXDocument:GetDOM("Who To Copy")/dfs:myFields/dfs:dataFields/dfs:Who_To_Copy[@Business = xdXDocument:get-DOM()/my:myFields/my:SKUIntroductionGroup/my:Business and @Admin = "1" and @Region = xdXDocument:get-DOM()/my:myFields/my:SKUIntroductionGroup/my:Region[. != '']], 'concat(@Email, "; ")'), "..")

Have you tried that yet?

Complex double eval...

Catharine — Mon, 06 Feb 2012 15:45:04 GMT

Hi, I am using InfoPath 2007.

I have a secondary data source.

myFields
dataFields (group)
    Who_To_Copy (repeating group)
      Business
      Region
      Email
      Admin.

In my main data source I have

myFields
SKUIntroductionGroup - group
Business
Region (repeating field)

I want to concatenate the email field from Who_To_Copy where the Business matches the Business in the main data source, and the Admin is set to true, AND the region matches any of the non blank regions set in the main data source. It is the last criteria that I am having problems with... so far I have the following. which works

I have tried adding the following to the filter - but that does not work.

and count(xdXDocument:get-DOM()/my:myFields/my:SKUIntroductionGroup/my:Region[. = xdXDocument:GetDOM("Who To Copy")/dfs:myFields/dfs:dataFields/dfs:Who_To_Copy/@Region]) > 0

I have tried adding and that doesn't work.

and count(xdXDocument:get-DOM()/my:myFields/my:SKUIntroductionGroup/my:Region[. = current()/@Region]) > 0

Is this a step to far ? Is there a way to achieve this ?

Thank you

Catharine

General

Re: Complex double eval...

Complex double eval...