https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/123179.aspxThu, 02 Jul 2020 18:42:59 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123179Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/123179.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=123179It took me the longest time to understand this stuff. I still find myself saying "up the tree" as I type ../ when writing XPath. :)https://www.infopathdev.com:443/forums/thread/123178.aspxThu, 02 Jul 2020 18:36:42 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123178MemphisDev0https://www.infopathdev.com:443/forums/thread/123178.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=123178That is, by far, the best explanation of how those paths work, I've read. I don't really know why I wasn't wrapping my head around it. Thank you, again, for the solution as well as the lesson!https://www.infopathdev.com:443/forums/thread/123177.aspxThu, 02 Jul 2020 18:23:09 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123177Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/123177.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=123177For me, it is easiest to think of "current()" as meaning "this element" (whether a group, a field, an attribute). So, in the case of your specific function - the TempFilter was the item in the repeating group that we needed to use current for. The rule is on CourseSection, so in this case, current() = "this specific instance of CourseSection" - because there could be a lot of them! Their grandparent is repeating! So, to get to TempFilter in the same Class (which will be in the same ClassGroup) we use current() to indicate this specific course section, go up the tree to the parent of the course section, and get the value of the temp filter that is in the same parent.... does that make sense? Since your other two filter fields are not repeating, it is ok to use the absolute instead of a relative path. :)https://www.infopathdev.com:443/forums/thread/123176.aspxThu, 02 Jul 2020 18:13:59 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123176MemphisDev0https://www.infopathdev.com:443/forums/thread/123176.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=123176So... 1) That worked; thank you SOOOO Much! 2) I guess the trick is, with current(), is that it replaces the entire path?https://www.infopathdev.com:443/forums/thread/123174.aspxThu, 02 Jul 2020 18:07:21 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123174Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/123174.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=123174Maybe try this? count(xdXDocument:GetDOM("BookStoreInventory")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:ISBN[../d:year = xdXDocument:get-DOM()/my:myFields/my:Year and ../d:term = xdXDocument:get-DOM()/my:myFields/my:Term and ../d:EventID = current()/../my:TempFilter])https://www.infopathdev.com:443/forums/thread/123173.aspxThu, 02 Jul 2020 17:42:57 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123173MemphisDev0https://www.infopathdev.com:443/forums/thread/123173.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=123173CourseSectionhttps://www.infopathdev.com:443/forums/thread/123172.aspxThu, 02 Jul 2020 17:38:58 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123172Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/123172.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=123172What field is the rule on?https://www.infopathdev.com:443/forums/thread/123169.aspxThu, 02 Jul 2020 17:32:03 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123169MemphisDev0https://www.infopathdev.com:443/forums/thread/123169.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=123169Thanks for the lightning fast reply!!! Attaching main data screen shot. I'm using a rule to set the NumberOfBooks field as I thought I might be able to get away with using the current function there. I'm open to using it as a default value; just thought the rule might give some flexibility.https://www.infopathdev.com:443/forums/thread/123166.aspxThu, 02 Jul 2020 16:57:44 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123166Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/123166.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=123166So - can you attach a copy of your form, or post a screenshot that shows the main data source structure, in a reply under the options tab? Is "my:Class" the repeating group? Is this count going in a field as a default or in a calculated value in the repeating table?https://www.infopathdev.com:443/forums/thread/123163.aspxThu, 02 Jul 2020 16:25:00 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123163MemphisDev0https://www.infopathdev.com:443/forums/thread/123163.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=123163Hi! I'm trying to use the count() function within a repeating table on a filtered secondary data source and struggling with counting within the current row. To avoid running a query each time a new row is added, as this seems to conflict with the previous row's selections, I've loaded the data on form load (~680 records) and then use some drop-downs to build a filter that selects from the secondary datasource and works reliably from row to row. I am able to count the first row correctly, however when I add a row, the count stops working and it becomes additive based on # of rows. (row A has 2 entries, row B has 1 entry, count becomes 3 on both) I tried using current(), however, I can't seem to get it to work in-place of getDOM() on the secondary data-source. Essentially, I'm trying to do an error check so that the count of rows = number of filtered entries. If anyone has any suggestions on how to make this work or a better way to run this check, I'd greatly appreciate it. Code is as follow: count(xdXDocument:GetDOM("BookStoreInventory")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:ISBN[../d:year = xdXDocument:get-DOM()/my:myFields/my:Year and ../d:term = xdXDocument:get-DOM()/my:myFields/my:Term and ../d:EventID = xdXDocument:get-DOM()/my:myFields/my:ClassForm/my:ClassGroup/my:Class/my:TempFilter])