Hi Siva, cts:not-query(cts:element-value-query(xs:QName("myelem"), "")) would exclude empty myelem elements..
Kind regards, Geert From: <general-boun...@developer.marklogic.com<mailto:general-boun...@developer.marklogic.com>> on behalf of "Mani, Sivasubramani (ELS)" <s.m...@elsevier.com<mailto:s.m...@elsevier.com>> Reply-To: MarkLogic Developer Discussion <general@developer.marklogic.com<mailto:general@developer.marklogic.com>> Date: Friday, September 1, 2017 at 1:32 PM To: "general@developer.marklogic.com<mailto:general@developer.marklogic.com>" <general@developer.marklogic.com<mailto:general@developer.marklogic.com>> Cc: ConSyn-Infosys-Support <consyn-infosys-supp...@reedelsevier.com<mailto:consyn-infosys-supp...@reedelsevier.com>> Subject: [MarkLogic Dev General] Regarding cts:element-value-query Hi Team, I use cts:element –query() & cts:element-value-query() to filter the documents based on their elements and element values. I need to filter the documents based on elements with values only but above query’s consider the empty elements also. <book> <pii>S56789</pii> <cp>ES</cp> </book> <book> <pii></pii> <cp></cp> </book> <book> <pii>S56789</pii> <cp>ES</cp> </book> This is my query cts:and-query(( cts:element-query(xs:Qname(“pii”),”*”), cts:element-query(xs:Qname(“cp”),”*”) )) or cts:and-query(( cts:element-value-query(xs:Qname(“pii”),”*”), cts:element-value-query(xs:Qname(“cp”),”*”) )) both the query includes empty element in the result. I need to filter out the empty element from the result. Kindly do the needful. Thanks & Regards, Siva
_______________________________________________ General mailing list General@developer.marklogic.com Manage your subscription at: http://developer.marklogic.com/mailman/listinfo/general