InfoPath Dev

I have been hunting around and think I am close but I need the exact syntax to get this to work. I have filtered for unique values in drop downs but this is a bit different with multiple repeating fields.

I have a form linked to a dataconnection to a database. So i want to display my main query results with a filter to show unique names within multiple records in a repeating group.

myFields
dataFields
d:OE
:Name
:Plan
:Amount1
:NID
:Etc

I have the fields in a repeating table within a section and I am using conditional formatting and I want to hide all duplicates by the NID field.
I think I want an expression which is not(.=..preceding::d:OE/NID) but I do not think my xpath is right.

Is there some easy way or trick to get the exact xpath for particular fields within Infopath?

So hopefully someone has done this and can tell me quickly what I am doing wrong and provide a help for someone in the future.

Thanks
Clay

Hi Clay,

Take a look at this HowTo:http://www.infopathdev.com/howto/tutorials/default.aspx?i=51dce616335a4ff6a78f2d289baf4651

As I mentioned I have done this successfully, filtering a drop down list. If "preceding" is what I am supposed to use can you give me some help on my xpath?

Thanks
Clay

I really am stuck here. From what I can tell I have to specify which column to check against, since I am not looking for identical rows but rows with common elements.

My data structure is
<dfs:myFields>
..<dfs:dataFields>
....<d:OE Name="" Plan="" Amount1=0 NID="" Etc="">

I want to filter my table so unique NID numbers only show up once even though there are multiple records for each NID number.
Right now in conditional formatting I have
NID is equal to preceding::OE/@NID
Hide this Control

Other conditions work and I have this as the only one right now but I am stuck.
I have tried both with and with out the @ but I am stuck here and not sure what it is looking for.

Please help me if you can as this is holding up my whole form implementation.

Thanks

Also the explicit xpath is ../preceding::d:OE/@NID

I think my issue is with the xpath syntax so any help would be greatly appreciated.

Hi Clay,

Can try once xpath is like “not(.=preceding::d:OE/@NID)”.

Before trying for above xpath you need to test first of all right side field xpath is correct or not. For this, you can try “d:OE/@NID” xpath is default value for one field and that field which is same level “d:OE” only. If you gets value then our above xpath is correct. By this way you can figure it out where is the problem of your xpath.

Hope this Help you

My XPath was correct.

It has now decided to work.

NID is equal to preceding::d:OE/@NID
Hide Control

Wierd

Well, congratulations!

I agree, XPath can be really funky sometimes.