Hi, Shashidhar: Does the configuration of the path index in the Admin UI specify the same data type (string with the same collation)?
If so, it might be time to add <search:debug>true</search:debug> to the options and get the response with a string handle so you can see what's being executed on the server. Erik Hennum ________________________________ From: [email protected] [[email protected]] on behalf of Shashidhar Rao [[email protected]] Sent: Sunday, April 12, 2015 11:32 AM To: [email protected] Subject: Re: [MarkLogic Dev General] How to find particular element using path index My search values in java code QueryOptionsManager optionsMgr = client.newServerConfigManager() .newQueryOptionsManager(); String optionXml = "<search:options " + "xmlns:search='http://marklogic.com/appservices/search'>" + "<search:values name='datepath'>" + "<search:range collation='http://marklogic.com/collation/' type='xs:string'>" + "<search:path-index>/product-reference/date</search:path-index>" + "</search:range>" + "</search:values>" + "</search:options>"; StringHandle writeHandle = new StringHandle(optionXml); optionsMgr.writeOptions("datepath", writeHandle); QueryManager queryMgr = client.newQueryManager(); ValuesDefinition query = queryMgr.newValuesDefinition( "datepath","datepath"); ValuesHandle values = queryMgr.values(query, new ValuesHandle()); for (CountedDistinctValue value : values.getValues()) { String textValue = value.get("xs:string", String.class); System.out.println(textValue ); } On Sun, Apr 12, 2015 at 11:19 PM, Shashidhar Rao <[email protected]<mailto:[email protected]>> wrote: Sorry that was a typo from my side and yes I created the path index in admin ui <constraint name='date'> <range collation='http://marklogic.com/collation/' type='xs:string' facet='false'> <path-index>/product-reference/date</path-index> </range> </constraint> But still I could not get the results. Error : Local message: search failed: Bad Request. Server Message: null On Sun, Apr 12, 2015 at 9:43 PM, Shashidhar Rao <[email protected]<mailto:[email protected]>> wrote: Hi , Below is the structure of my document. I want to find the date under the <product-reference> and not the date from the <store-reference>. XML-STRUCTURE <product-reference> <product-id> <country>IND</country> <product-number>AA-503</product-number> <product-type>apparel</product-type> <date>20130105</date> </product-id> </product-reference> <store-reference> <store-id> <country>JP</country> <store-number>8369</store-number> <date>20120906</date> </store-id> </store-reference> I have create this optionsname as "date-product" and constraint as <constraint name='date'> <range collation='http://marklogic.com/collation/' type='xs:string' facet='false'> <path-index>/publication-reference/date</path-index> </range> </constraint> JAVA CODE QueryManager queryMgr = client.newQueryManager(); ValuesDefinition query = queryMgr.newValuesDefinition("date-product", "date"); ValuesHandle values = queryMgr.values(query, new ValuesHandle()); for (CountedDistinctValue value : values.getValues()) { String textValue = value.get("xs:string", String.class); System.out.println(textValue ); } I am not getting any results. Am I missing something or could somebody correct my code or help me with how to find values with path-index with range element index I am getting the results. Thanks
_______________________________________________ General mailing list [email protected] Manage your subscription at: http://developer.marklogic.com/mailman/listinfo/general
