Skip to content

Instantly share code, notes, and snippets.

@prestonmcgowan
Created October 10, 2019 18:45
Show Gist options
  • Save prestonmcgowan/7f7c39e91b19f65d3c7756603e78edba to your computer and use it in GitHub Desktop.
Save prestonmcgowan/7f7c39e91b19f65d3c7756603e78edba to your computer and use it in GitHub Desktop.
Example of an Empty Element Query with MarkLogic
(: Create sample docs :)
xquery version "1.0-ml";
(
xdmp:document-insert("/test/zero.xml", <doc><a>1</a><b>1</b><c>1</c><d>1</d></doc>),
xdmp:document-insert("/test/one.xml", <doc><a>1</a><b>1</b><c>1</c><d></d></doc>),
xdmp:document-insert("/test/two.xml", <doc><a>1</a><b>1</b><c></c><d></d></doc>),
xdmp:document-insert("/test/three.xml", <doc><a>1</a><b></b><c></c><d></d></doc>),
xdmp:document-insert("/test/four.xml", <doc><a></a><b></b><c></c><d></d></doc>)
)
;
(: Count empty documents for each value :)
xquery version "1.0-ml";
for $x in ("a", "b", "c", "d", "e")
return ($x,
xdmp:estimate(cts:search(fn:doc(), cts:element-value-query(xs:QName($x), "" ) ))
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment