Code: Select all
for $item in Base/Item
group by $id := $item/Id
order by $id
return <Item>
<Id>{$id}</Id>
{for $marked in $item[Mark]
group by $mark := $marked/Mark
return <Marked name="{$mark}">
{sum($marked/Qty)}
</Marked>
}
<Total>{sum($item/Qty)}</Total>
</Item>
Code: Select all
System ID: C:\SomePath\test2017101602.xq
Severity: error
Description: Cannot format the document. Encountered " ":=" ":= "" at line 2, column 14.
Was expecting one of:
<WS> ...
"," ...
"stable" ...
"order" ...
"collation" ...
"count" ...
"where" ...
"return" ...
"as" ...
"for" ...
"let" ...
"group" ...
":)" ...
Start location: 2:13
Length: 1
Code: Select all
GroupingSpec ::= GroupingVariable (TypeDeclaration? ":=" ExprSingle)? ("collation" URILiteral)?
it appears to me the syntax is fine. And oXygen runs the query without problems, the problem is simply that it does not manage to format it.