Re: [MarkLogic Dev General] word query

2014-10-17 Thread Girish Kulkarni
The word Query problem was on the Marklogic version 7.0-2.1. It works fine on 7.0-3. Girish On Thu, Oct 16, 2014 at 9:45 AM, Danny Sokolsky < danny.sokol...@marklogic.com> wrote: > Have you tried this on 7.0-4? There are some bugs fixed in this area > there—it is worth a try. > > > > What I re

Re: [MarkLogic Dev General] Element Range Query with DateTime and Durations

2014-10-17 Thread Wanczowski, Andrew
Hi John and Dave, In testing the provided example worked well: xquery version "1.0-ml"; declare namespace html = "http://www.w3.org/1999/xhtml";; let $results := cts:search( fn:doc(), cts:element-range-query(xs:QName("publishedDate"), "<=", fn:current-date() - xs:dayTimeDuration("P90

Re: [MarkLogic Dev General] Is there a way to extract worksheet metadata from an Excel 97/2003?

2014-10-17 Thread Ron Hitchens
If it's feasible to do your metadata extraction upstream of MarkLogic (i.e., before insertion) you might take a look at Apache Tika. It's designed for this sort of thing. You could also setup it up in a simple web service callable from MarkLogic. POST the spreadsheet to it and have it

Re: [MarkLogic Dev General] Is there a way to extract worksheet metadata from an Excel 97/2003?

2014-10-17 Thread Gary Russo
Hello Dennis, Thanks for the info. Yes, I tried xdmp:excel-convert() but this does not get the worksheet metadata either. The metadata that I need to retrieve from the older excel format is the “Named Fields”. Users create them using the Excel “Named Box” feature as shown here. =>

Re: [MarkLogic Dev General] Element Range Query with DateTime and Durations

2014-10-17 Thread Wanczowski, Andrew
Thanks John. I'll give that a shot. On 10/17/14 9:35 AM, "John Snelson" wrote: >Work out a dateTime 90 days before the current dateTime, and query for >articles with a published dateTime before that dateTime. > >John > >On 17/10/14 14:26, Wanczowski, Andrew wrote: >> Hi All, >> >> Is possible to

Re: [MarkLogic Dev General] Element Range Query with DateTime and Durations

2014-10-17 Thread John Snelson
Work out a dateTime 90 days before the current dateTime, and query for articles with a published dateTime before that dateTime. John On 17/10/14 14:26, Wanczowski, Andrew wrote: > Hi All, > > Is possible to do a dateTime range query based on the elements value > plus or minus a xs:dayTimeDuratio

[MarkLogic Dev General] Element Range Query with DateTime and Durations

2014-10-17 Thread Wanczowski, Andrew
Hi All, Is possible to do a dateTime range query based on the elements value plus or minus a xs:dayTimeDuration. For example I want to find all articles that are 90 days passed the published date. The documentation (http://docs.marklogic.com/cts:element-range-query) gives a few examples of da

Re: [MarkLogic Dev General] using xdmp:eval in REST Service

2014-10-17 Thread David Ennis
HI Pragya. I did not supply you with the exact issue as I did not try to install and run all 900 lines of code. INstead, I looked at items that seemed suspect for you to log and verify what is happening with the data between the rewriter and the invoker. I am still not convinced that you have th