Code

Re: Rule to count the number of field that correspond to a specific value

Josee Sevigny — Thu, 22 Dec 2016 20:54:55 GMT

Great! I couldn't figure out how to jump over the named node ;-)

Re: Rule to count the number of field that correspond to a specific value

Josee Sevigny — Thu, 22 Dec 2016 20:51:53 GMT

Found it!! count(//my:reviewRequired[. = 1])

Thanks so much! I've lost so much time trying to figure this one out.

Re: Rule to count the number of field that correspond to a specific value

Hilary Stoupa — Thu, 22 Dec 2016 20:45:33 GMT

From where your submit button is now, this should be the formula that you can use to disable submit unless all required reviewers have a person selected:

count(../../my:reviewers/my:*/my:review[my:reviewRequired = 1 and (../my:ppicker/pc:Person/pc:AccountId = "" or not(../my:ppicker/pc:Person/pc:AccountId))]) > 0

Reviewers does not have to be repeating - I just didn't look closely enough at your sample XML.

Re: Rule to count the number of field that correspond to a specific value

Hilary Stoupa — Thu, 22 Dec 2016 20:35:33 GMT

OOOOOOHHHHHH ! I understand now that I've looked at your form. I'll post back shortly w/ the formula so you don't have to have reviewers be repeating - I misread your original XML. :)

Re: Rule to count the number of field that correspond to a specific value

Josee Sevigny — Thu, 22 Dec 2016 20:30:14 GMT

Thanks so much for helping.

First, I had to set the reviewers group as Repetitive even though none of them are. It then allowed me to select "Number of". HOWEVER, I just noticed that all my People Pickers are now unbound and cannot be bound properly, Yikes!

count(../../my:reviewers) = ""

I tried the following:

BAD count(../../my:reviewers[reviewRequired = 1])
BAD count(../../my:reviewers[my:reviewRequired = 1])
OK BUT RETURNS 1, I SHOULD GET 3 count(../../my:reviewers[//my:reviewRequired = 1])

Re: Rule to count the number of field that correspond to a specific value

Hilary Stoupa — Thu, 22 Dec 2016 20:08:59 GMT

On the submit button, add a condition for your expression - for the first dropdown, select reviewers and use the drop down to select "number of" - that will give you the XPath for the basic count, if you change the first dropdown to "the expression" - paste that into a reply & I can help you w/ the filters on the expression. :) Or attach your form under a reply under the Options tab.

Re: Rule to count the number of field that correspond to a specific value

Josee Sevigny — Thu, 22 Dec 2016 19:42:41 GMT

A simpler example of what I'm trying to accomplish is to Hide the Submit button, if not all the reviewers have been defined.

In English, I'd say: For all the Required reviewers, do we have any blank AccoundIDs under reviewers?
OR
Do we have the same number of non-blank reviewers as there are required reviewers?

Seems simple enough but I can't seem to find the number of required reviewers I have.

Any suggestion?

Re: Rule to count the number of field that correspond to a specific value

Josee Sevigny — Thu, 22 Dec 2016 19:07:06 GMT

Hmm, I'm currently using a Calculated Value control to ensure I can get the correct syntax first, then will move it to when I need it.

The intent is to hide/show another field (capture date field external to the above structure) based on some calculation within the reviewers mode-set.

I tried adding an Action rule to the reviewers node to show the count but it does not get triggered. The Reviewers node itself does not get modified nor displayed. So how do I add a formatting rule on my capturing date picker that will actually calculate values from the reviewers structure?

Re: Rule to count the number of field that correspond to a specific value

Hilary Stoupa — Thu, 22 Dec 2016 18:55:08 GMT

Where is the rule? Select reviewers using the field picker and then manually add the XPath filter. Whether "my:reviewers" is a valid path depends on where the rule / condition / expression is. :)

Re: Rule to count the number of field that correspond to a specific value

Josee Sevigny — Thu, 22 Dec 2016 18:43:25 GMT

When I do either, it won't save the rule as it tells me:
"my:reviewers/my:reviewRequired" does not point to a valid location path of a field or group.

XPath is: count(my:reviewers[my:reviewRequired = "1"])

I don't know if this is important but reviewRequired is set as Boolean.

Re: Rule to count the number of field that correspond to a specific value

Hilary Stoupa — Thu, 22 Dec 2016 16:49:15 GMT

And if review required is always a number: count(my:reviewers[my:reviewRequired = 1])

Re: Rule to count the number of field that correspond to a specific value

Hilary Stoupa — Thu, 22 Dec 2016 16:43:06 GMT

count(my:reviewers[my:reviewRequired = "1"])

Rule to count the number of field that correspond to a specific value

Josee Sevigny — Thu, 22 Dec 2016 16:30:07 GMT

Hi,

I have the below structure and want to count the number of reviewRequired fields that have a value of 1.

count(my:reviewers[//my:reviewRequired = "1"])

In total, there are nodes with a value of 1 but it keeps telling me that there's only 1.

<my:reviewers>
<my:engagementManager>
   <my:ppicker>
    <pc:Person>
     <pc:DisplayName></pc:DisplayName>
     <pc:AccountId></pc:AccountId>
     <pc:AccountType></pc:AccountType>
    </pc:Person>
   </my:ppicker>
   <my:review>
    <my:reviewDate xsi:nil="true"></my:reviewDate>
    <my:reviewRole>Engagement Manager</my:reviewRole>
    <my:reviewRequired>1</my:reviewRequired>
   </my:review>
</my:engagementManager>
<my:engagementLeader>
   <my:ppicker>
    <pc:Person>
     <pc:DisplayName></pc:DisplayName>
     <pc:AccountId></pc:AccountId>
     <pc:AccountType></pc:AccountType>
    </pc:Person>
   </my:ppicker>
   <my:review>
    <my:reviewDate xsi:nil="true"></my:reviewDate>
    <my:reviewRole>Engagement Leader</my:reviewRole>
    <my:reviewRequired>1</my:reviewRequired>
   </my:review>
</my:engagementLeader>
<my:functionalRRL>
   <my:ppicker>
    <pc:Person>
     <pc:DisplayName></pc:DisplayName>
     <pc:AccountId></pc:AccountId>
     <pc:AccountType></pc:AccountType>
    </pc:Person>
   </my:ppicker>
   <my:review>
    <my:reviewDate xsi:nil="true"></my:reviewDate>
    <my:reviewRole>Function RRL</my:reviewRole>
    <my:reviewRequired>0</my:reviewRequired>
   </my:review>
</my:functionalRRL>
...
</my:reviewers>