InfoPath Dev

Ick. You could try saving the form as source files and in the view file, adding a class to the elements you need to grab via JS to work around this - but I don't have an answer to your question, I'm afraid.....

As long as you are getting the data you need, sounds fine to me.

I would try creating a new data connection - modify the SQL to call the stored procedure, and just try the data connection as is (the new one) to see if data is returned to the form. Put the data fields from the new connection on the form so you can see if data is returned. Compare the schemas of the original data connection to the new one to see ...

I think this formula would be valid and may be what you are trying to achieve: substring(xdMath:Eval(xdMath:Eval(xdXDocument:GetDOM("LeadManagers")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW[contains(xdXDocument:get-DOM()/my:myFields/my:DocInfo/my:Matrix, d:Discipline2)], 'concat(d:GrantAccess/pc:Person/pc:AccountId, ...

Ok. I don't know the full XPath to either your secondary data source node or to your main data source node where you currently have the default value from the 2ds - but the code after you run the SQL query might be something like: XPathNavigator secDSNav = ...

Oh, I hope so, before this form kills us both. :)

I take it that is from the copy of the template I gave you? In your original, it was still succeeding?

Can you put the QdabraRules execution history on your form and verify that the Modify SQL Query command for the approvers data connection is returning success? The command is supposed to execute the query, but if GetXml /dsname=approvers isn't returning any data, that would indicate there is no data being returned to the form... I also noted ...

So - to me, this indicates no data has been returned in that data source. You can check this by checking a different data connection - do you have other data connections in your form? You can also just use GetXml and it will return the main data source XML to the results field so you can see how the command works.... But I guess the next thing ...

Sounds like you may be trying to put that text in a formula editor. Put the qRules command and result field on the form so you can just enter the text as you have it into the command field and tab out: GetXml /dsname=approvers