I am trying to use a variable (/process_data/@Division) to identify an xml node to determine the person for a task:
/process_data/DivisionRolesXML/divisions/division[Division='string(/process_data/@Division )' and Position='Div Executive']/LDAPId
I get no value returned (e.g. result is 'null'). The log shows that @Division has a string value.
It works if the actual value (not variable) is specified:
/process_data/DivisionRolesXML/divisions/division[Division='division_name' and Position='Div Executive']/LDAPId
This is a sample of the xml data (observed in LC log) being referenced by xpath:
<Position type="varchar">Div Executive</Position>
I'm reasonably sure that you need to remove the single quotes in your expression. The single quotes mean that your entire sub-clause is being treated as a string, rather than as an expression.