General

Re: Xpath Syntax for Secondary Data Source

Erich — Tue, 09 Aug 2011 13:00:18 GMT

Yes, what I would like is to store the value of the 'Name' attribute from the secondary data source as a global variable. My problem is that it appears script is executed before rules are, so when I try to extract the 'Name' attribute from a rule-calculated field, it returns an empty string since the rule has not yet been applied.

Erich

Re: Xpath Syntax for Secondary Data Source

Jimmy — Tue, 09 Aug 2011 07:58:08 GMT

This can be done fairly simply with rules and such, but in code it's not possible to have a single XPath reference two data sources.

You could first get the my:user value and concatenate it into another XPath, but the JScript syntax for accessing a 2DS is somewhat involved. Is there some reason you can't use a rule to show this alert?

Xpath Syntax for Secondary Data Source

Erich — Mon, 08 Aug 2011 20:36:12 GMT

Hi,

Here is the selectSingleNode statement producing an error ("Object required")

XDocument.UI.Alert(XDocument.DOM.selectSingleNode("dfs:myFields/dfs:dataFields/d:BC_Verification[@BC_ID = my:myFields/my:user]/@Name").text);

Where 'dfs' and 'd' are the namespaces of the secondary data source, and 'my' for the primary source.

BC_Verification attributes:

BC_ID
Name

'user' is a pre-filled field in the form being used to filter a BC_Verification entry where BC_ID = user. Any ideas on what's giving the error?

Erich