XPATH

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

oakridge - 19 Dec 2005 19:43 GMT

Followed Greg Collins suggestions for Filtering Unique Values from a dropdown
list from a secondary data source.

Using the following "not(. = ../preceding-sibling::SW-VERSIONS/@MACHINE)"
Where in SW-VERSIONS is the Secondary Data SQL Table with the field MACHINE.
This is represented on the main screen as
/dfs:myFields/dfs:dataFields/d:SW-VERSIONS/@MACHINE["not(. =
../preceding-sibling::SW-VERSIONS/@MACHINE)"]
I have tried this with and without quotes and neither of them work.

What am I missing?

Ann Compton

Reply to this Message

S.Y.M. Wong-A-Ton - 19 Dec 2005 21:17 GMT

Hi,

Have you already tried asking Greg Collins at the infopathdev.com forum?

I think your final expression should look something like the following:
.....SW-VERSIONS[not(@MACHINE = preceding-sibling::SW-VERSIONS/@MACHINE)]

Note: You must not use quotes around the filter condition between the
brackets.

Hope this helps.

Regards,
S.Y.M. Wong-A-Ton

> Followed Greg Collins suggestions for Filtering Unique Values from a dropdown
> list from a secondary data source.
[quoted text clipped - 9 lines]
>
> Ann Compton

Reply to this Message

Greg Collins [InfoPath MVP] - 09 Jan 2006 17:32 GMT

Hi. It looks like you are missing your namespace (d:), and there are quotes
where there shouldn't be any:

BEFORE:
/dfs:myFields/dfs:dataFields/d:SW-VERSIONS/@MACHINE["not(. =
../preceding-sibling::SW-VERSIONS/@MACHINE)"]

AFTER:
/dfs:myFields/dfs:dataFields/d:SW-VERSIONS/@MACHINE[not(. =
../preceding-sibling::d:SW-VERSIONS/@MACHINE)]

> Hi,
>
[quoted text clipped - 26 lines]
>>
>> Ann Compton

Reply to this Message