Orbeon Forms community mailing list

select parent based on child value

Classic

List

Threaded

3 messages Options

mbojja

select parent based on child value

Hi Alex - I'm storing this xml as a dataset using an action and pre-populate some employee details.

<lastName>Manish</lastName>

<_ type="object">

<departmentName>North East</departmentName>

<_ type="object">

<positionTitle>Teacher</positionTitle>

</_>

</positions>

</_>

<_ type="object">

<departmentName>South East</departmentName>

<_ type="object">

<positionTitle>Principal</positionTitle>

</_>

</positions>

</_>

</departmentPositions>

</staff>

</json>

While filling the form, user selects one of the multiple positions he has got from a positions dropdown. On selection of the position(control-employee-position) I should autofill the associated departmentName in another text control

for which I'm using the following xpath as calculated value - xxf:instance('fr-dataset-staffDetails')/staff/departmentPositions/_/departmentName[positions/_/positionTitle = xxf:instance('fr-form-instance')//control-employee-position]

I do not get the desired result. May I know what am I doing wrong here?

--
You received this message because you are subscribed to the Google Groups "Orbeon Forms" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/orbeon/0c59c276-3e5e-41a8-a585-98b3198b77f9%40googlegroups.com.

Alessandro Vernet

Re: select parent based on child value

Administrator

I notice at least 1 typo in that expression: `positions` isn't inside
`departmentName`, but inside the parent `_`. So something like this seems
"more correct":

xxf:instance('fr-dataset-staffDetails')/staff/departmentPositions/_[positions/_/positionTitle
=
xxf:instance('fr-form-instance')//control-employee-position]/departmentName

If this doesn't do it, one way to debug this is by just keeping a part of
the expression, and adding a `count(…)`, to check that at every level it
returns something (i.e. if it returns 0, you know that the expression you
have didn't return anything).

I hope this helps,

‑Alex

-----
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet
--
Sent from: http://discuss.orbeon.com/

--
You received this message because you are subscribed to the Google Groups "Orbeon Forms" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/orbeon/1591223296576-0.post%40n4.nabble.com.

--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet

Alessandro Vernet

Re: select parent based on child value

Administrator

Hi Manish,

Did you manage to make that expression work? (Also, I am noticing that the
XPath in my previous message got mangled, so let me know if you're still
working on this!)

‑Alex

-----
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet
--
Sent from: http://discuss.orbeon.com/

--
You received this message because you are subscribed to the Google Groups "Orbeon Forms" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/orbeon/1592942766878-0.post%40n4.nabble.com.

--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet