Question

Forms Reports - Add data filter with an item from a collection

Forms

Updated November 25, 2020

asked on March 2, 2017 • Show version history

I'm trying to create report that will show items that are only marked "yes" in a radio button that is within a collection.

When trying to add the data filter, I noticed that it does not display anything that is within the collection. Is this true, I cannot restrict my report to something that is inside the collection? Is there a work around other than what I'm already thinking - modify the process designer to have a new stage called "yes" and it goes there in the end so I can use the data filter 'current running stage'? The report is ran after the form process is complete so I'd have to make it do the same thing, just in a different stage name if it's yes vs. no.

Any ideas anyone?

1 0

Replies

replied on March 2, 2017

I think the problem is that with a collection, there can be multiple copies of the same field, and it's not really possible from the Report set-up to know how many copies of the field there will be.

Are you trying to have it show on the report if any of the rows in the collection are marked as yes, or if a particular row in the collection (i.e. First Row or Last Row) is marked as a yes?

0 0

replied on March 2, 2017

The reason that filter based on variable inside collection/table is not supported is because the behavior is not clear when user set to "collection/fielda does not equal to "a"": whether we should return all the instances that contain a value doesn't equal "a" or all the instances that do not contain any value that equal "a".

0 0

replied on November 25, 2020

I don't see how the ambiguousness of multiple value is a problem for filters. We do this in the repository all the time. We might have a template with multiple check numbers and we can search for documents where check number = 123 and any document that contains that check number will show up, or where check number != 123 and any document which contains that check number will not show up.

We have a customer that simply wants to filter submissions by family, but they can have multiple families, so now they are unable to filter by family at all.

0 0

You are not allowed to follow up in this post.

Question

Question

Forms Reports - Add data filter with an item from a collection

Replies

Sign in to reply to this post.