General

Re: Count results of filtered section/table

Doreen — Tue, 07 May 2013 22:58:56 GMT

Desmo,

did you figure this out? I have same question but this thread is so old nobody will likely respond.

Re: Count results of filtered section/table

Desmo — Fri, 29 Oct 2010 18:04:47 GMT

hi sorry to be bumping an old message but I am having difficulty w/ this one - when you say to add a boolean field in the rep. section, what type of function should it be? there's nothing that seems to evaluate whether or not the field itself is b eing displayed. if it's default is "false", what is supposed to make it true so i can count the "trues"? if that makes sense

Re: Count results of filtered section/table

b.harrison — Thu, 19 Mar 2009 20:26:28 GMT

Hi Jimmy,

I suppose I should have been more clear about my expectations of count().

I've seen this post by Greg before, and use xdExtensions multiple places. They work in rules and filters, but if I try in an expression box I receive the error "Reference to undeclared namespace prefix: 'xdExtension'."

I was able to use NamedNodeProperty, as you suggested, to perform my calculations. It behaves similarly to an attribute, from what I can tell.

I set the value in code: XDocument.SetNamedNodeProperty(node, "show", "false" or "true")

Use it to filter: xdXDocument:GetNamedNodeProperty(., "show", "true") = "true"

And also to put the count in an expression box: count(../../my:Deficiencies/my:Deficiency[xdXDocument:GetNamedNodeProperty(., "show", "true") = "true"])

Once again, thank you very much for your help!

Re: Count results of filtered section/table

Jimmy — Thu, 19 Mar 2009 17:06:10 GMT

Pardon me for assuming you knew less than you did.

I think there are ways to get around using that extra boolean field. For example, there is a way to hack the form to allow calling xdExtension functions from rules and (I believe) expression boxes:

http://www.infopathdev.com/blogs/greg/archive/2004/09/15/Use-Code-to-Determine-a-Rule-Condition.aspx

Another option, since you're already using code anyway, is to set a named node property on the relevant fields, and then use xdXDocument:GetNamedNodeProperty(,,) in your count() expression. This should enable you perform these counts without adding unwanted fields to your form.

Re: Count results of filtered section/table

b.harrison — Thu, 19 Mar 2009 16:25:03 GMT

I understand XPath, count, and that nothing in my data source is actually being modified, and I think the way count() works makes perfect sense and should function no other way (otherwise, how would you truly know the number of items in the data source?). I was just hoping to have the functionality to count the filtered nodes without having to introduce an otherwise unnecessary field into to my schema. And since position() is able to detect this, I thought there may be way with proceeding-sibling or following-sibling or something along those lines to do this.

Re: Count results of filtered section/table

Jimmy — Thu, 19 Mar 2009 16:05:42 GMT

I think that once you understand XPath a bit better, you'll find that there's really nothing silly about this behavior. When you filter a repeating section, you are only concealing certain rows from the visual representation of the data, not removing nodes from the data itself. The XPath functions are concerned with the contents of your data source, not the current appearance of your InfoPath view.

Consider this: if you had two repeating sections bound to the same repeating group and filtered on different values, what value would you expect count(full path to node) to return?

Re: Count results of filtered section/table

b.harrison — Thu, 19 Mar 2009 14:17:07 GMT

Thta is exactly the solution I ended up going with a couple days ago. Seems silly that position() can account for this but count() can't. Oh well.

Thanks again swatip!

Re: Count results of filtered section/table

swathip — Thu, 19 Mar 2009 05:16:56 GMT

Hi,

Add a Boolean field to the repeating section in data source with the default value as false. You are using a function which returns true or false. Set that value to the newly added boolean field. Use this field to filter the rows. For example, count("my:myFields/my:group1/my:group2[my:booleanField = ‘true']")

Re: Count results of filtered section/table

b.harrison — Wed, 18 Mar 2009 14:01:34 GMT

Hi swathip,

Thanks for your reply. I know the count() function, but it does not give me the result I am looking for.

Say my repeating data source has 12 rows in it. For the repeating section filter in Infopath, I use an xdExtension to call a function that returns true or false, so the filter can include or discard that row. When I have this, 4 rows are shown that make it through the filter.

If I make an expression box with count(xpath) as you suggested, its value is still 12. However, if I put an expression box with position() in the repeating section, the values shown a 1, 2, 3, and 4. So, the position() function can account for filtered data; I need something similar for count(). Any ideas?

Re: Count results of filtered section/table

swathip — Wed, 18 Mar 2009 09:16:46 GMT

Hi,

Use the count("repeating section xpath ") function. By using this you can get the number of rows are inserted in repeating section.

Count results of filtered section/table

b.harrison — Tue, 17 Mar 2009 19:31:10 GMT

I have a repeating section bound to a repeating field in my data source. When I use the Filter Data functionality to filter, how can I retrieve the number of items that will still be shown?

Thanks for any help.