You guys ever seen this before?
this doesn't seem to be whole FormData XML, it looks like you already picked just repeater part out of it.
"Sample ID: ID-123" at the end of your sample doesn't belong to repeater data. it breaks validity of XML so that's likely the reason UDA do not provide expected results.
btw, it's better to create multiline text field(s) in list dedicated to (each) repeating section on list form...
Hi Marian - thank you - I do have a dedicated column ("FormData" - multiline) which I've connected the repeating section to. ...But nothing is there. Completely blank.
And, I agree with what you're saying in that it doesn't look like the whole FormData XML ... but that's what it's giving me before going into the UDA :S
Hi Rhia Wieclawek,
first of all I would rename the column! (deleted & created new one to be extra sure column's internal name is not preserved)
there is already existing hidden FormData column. so it might happen sometime is updated one column and sometimes the other. that would explain those broken data.
It will be blank if the column created is multiline and it is not plain text
You can't connect the form data to a column. But you can update the column with FormData using workflow. So It should be the repeater control data that is connected to the column. Make the multiline column as plain text and try. Something went wrong with the QueryXMLData control.
Ah, good point, I've done this now - using XMLData - and I can update the column to have the data needed, which looks like the "BEFORE" in the original post.
So after trying this on a new item, the UDA is running, and now I'm getting this:
Workflow Status
<?xml version="1.0" encoding="utf-8"?><RepeaterData><Version /><Items><Item><beada732-0784-4577-97fd-467e31954290 type="System.String">Test&#160;Failed&#160;-&#160;Variable Name NWF.FormFiller.Functions.GetValue(&#39;382522f |
|
and it terminates there.
Well, at least I have something more pointed to investigate.
Okay I'm kind of working out loud here..
This is the fail point:
NWF.FormFiller.Functions.GetValue(&amp;amp;#39;382522f3-e8e8-43a1-94cb-13c03e961a07&amp;amp;#39;, sourceContext, &amp;amp;#39;string&amp;amp;#39;)&lt;/beada732-0784-4577-97fd-467e31954290
Now I just have to figure out what ^ that is. :|
it looks like something is breaking syntax of javascript within a page...
some missing or extra coma, brace, apostrophe, backslah.... in script or rule?
or maybe not properly escaped data?
Thanks Marian, I'll take a look. There's no javascript in this form, but I'll check out the rules for sure.
Okay, I figured it out.
I couldn't parse it out because there was only 1 section brought back.
What we've (always) had is //Items/item/{numindex}/variable
It has, as far as I know, always worked.
Now, I've removed that {numindex} and it's working.
Welp.
hm, what environment was is on with numindex?
I've never seen repeater XML structured like this
wasn't it something like
//Items/item[numindex]/variable
that would make much more sense
I agree - this is in SP2013
And, I had to take out the numindex to make it work. Boggled my mind, never seen that before. ESPECIALLY since it was working perfectly previously with //Items/item{numindex}/variable
I don't get it. But. It's working for one off items.
Do you think this is something I should raise with support
I don't know.
are you able to provide example of such repeater XML and exact XPath expression?
you can remove data, it's enough to see XML structure.
Here's an example of some of the XML:
Workflow Status
<?xml version="1.0" encoding="utf-8"?><RepeaterData><Version /><Items><Item><VariableName type="System.Double">3942</VariableName><VariableName type="System.String">4.4</VariableName> |
|
Here's an example of XML query that DOES NOT work:
//Items/itemt{WorkflowVariable:NumIndex}]/VariableName
(I've tried lower case and upper case I's on item, just in case)
And here's an example of XML query that DOES work:
//Items/item/VariableName
Now this is all well and fine if I only have one repeating item ... but... I need to loop through these stupid things.
I'm totally perplexed, the way I'm doing it has always worked. And suddenly it is having a fit about my NumIndex - which, is a number variable, and is set correctly (I checked many many times).
I'll see if I can get the full XML block out.
Hi Rhia Wieclawek,
from my point of view, everything works correctly.
//Items/item/VariableName
returns all the elements with name 'VariableName' of all the items.
in your example there are two such elements. Note both of them are within the same <Item> element
//Items/iteme{WorkflowVariable:NumIndex}]/VariableName
returns all the elements with name <VariableName> of the item selected by given NumIndex
as mentioned above, you have both <VariableName> nodes within one (first) <Item> element, so following returns all (both) the elements of name 'VariableName' of first <Item>
however. since you have only one <Item> node, following can not work - there is not second <Item> element
I guess you might be confused by following: if you had in the past just single occurrence of <VariableName> node within <Item> one, you might address <VariableName> of the 2nd <Item>, so following would work in that case.
this is as well typical case, I do not see too much sense to have two controls named the same within on repeater row.
Hmm, in reality, they aren't named the same - I should've said VariableName1 and VariableName2.
I shouldn't say anything more till I get the full XML for a repeater with more than one section, I think my issue will be more easily seen. I appreciate you responding though Marian!!