Need help with XPath - Marking duplicate rows - Infopath 2010 database template

damnItHarsh — Tue, 29 Jan 2013 08:54:26 GMT

Hello everybody,

I'm trying to write a formula in one of the fields of a repeating table to mark the duplicate rows (the repeating table talks to a SQL table and has a foreign key constraint to another SQL table, not sure if that would matter in addressing the issue).

Below 2 solutions look pretty straightforward, except that I can't figure out the correct XPath. I get count as 0 all the time.

http://social.msdn.microsoft.com/Forums/nl-NL/sharepointcustomizationprevious/thread/b1116104-1cc4-47a3-919a-e68e9b57fc6a

http://www.bizsupportonline.net/infopath2010/find-duplicate-values-repeating-table-infopath-2010.htm

Image of myFields panel here:

http://postimage.org/image/8ai3f93md/

"ScoreCard_Period" is the field that should serve as the ID and "Error_Status" should contain the count (Validator).

Right clicking the "ScoreCard_Period" and copying XPath gives following:
/dfs:myFields/dfs:dataFields/d:EUS_Account_KPI_Configuration/d:EUS_Account_KPI_Data/@ScoreCard_Period

Any help in arriving at the formula that needs to be copied to "Error_Status" ("Validator") would be highly appreciated. Thank you.

Cheers!
Harsh

SQL Database Integration

Need help with XPath - Marking duplicate rows - Infopath 2010 database template