[MarkLogic Dev General] Join two different set of docs using cts:search

2013-05-23 Thread marklogicu...@yahoo.com
Hi, I have two sets of documents in ML as: fn:doc()/a. (a is root element) Sample structure: "sample1" And fn:doc()/c. (c is root element) Sample structure: "sample2" Now I have millions of both these types of docs. I have to join these two sets of docs on the element b. Return the matching

Re: [MarkLogic Dev General] Updates creating additional documents

2013-05-23 Thread Danny Sokolsky
Is there a CPF pipeline attached to the database (or some other triggers)? If so, that might be what is causing the updates. In general, batches are more efficient than single updates, maybe batches of 100 or 1000 (or more or less...), depending. As you said, tho, a failure meant that the who

Re: [MarkLogic Dev General] Sorting on aggregation in ML4.2-7

2013-05-23 Thread Danny Sokolsky
Is there always one per metadata? If so, you might be able to fragment on metadata, put a range index on value, and then do something like this: cts:sum-aggregate(cts:element-reference(xs:QName("value"), (), cts:element-word-query(xs:QName("country"), (), "usa") ) This should give you the su

Re: [MarkLogic Dev General] Querying attributes

2013-05-23 Thread Dak Tapaal
Thanks for this.. -Original Message- From: general-boun...@developer.marklogic.com [mailto:general-boun...@developer.marklogic.com] On Behalf Of Erik Hennum Sent: 23 May 2013 13:28 To: MarkLogic Developer Discussion Subject: Re: [MarkLogic Dev General] Querying attributes Hi, Dak: Your

[MarkLogic Dev General] Updates creating additional documents

2013-05-23 Thread Bob O
Hello again! So, I'm doing some investigation to my new ML project and I'm finding out some weird things happening: -When updates are done, it creates additional documents (creating rather than updating). We would get new documents when we try to update a particular field that is part of the Dat

Re: [MarkLogic Dev General] Sorting on aggregation in ML4.2-7

2013-05-23 Thread Abhishek53 S
Hi Danny, You are right, I need sorting based on the "summation of all value items". The perrformance is not acceptable with for loop or cts:search since 1.5 millions of documents required to get sorted. I was planning to keep the summation of value in some seperate field but the issue more co

Re: [MarkLogic Dev General] Sorting on aggregation in ML4.2-7

2013-05-23 Thread Danny Sokolsky
Hi Abeshek, First off, I am not totally sure what you mean by "summation value of one field", but I am guessing you mean to sum up all of the value elements under your content element. To start, the naive way to do this is to just do a flowr with an order by, something like this: xquery versi

[MarkLogic Dev General] Sorting on aggregation in ML4.2-7

2013-05-23 Thread Abhishek53 S
Hi All, I need to do some sorting over summation value of one field in MarkLogic 4.2-7. Below is the way our content is organized and the sorting is required over sum of all value tag over 1.5 million document Please advise!!! C1 USA 200 CAN 400 AUS 300 Abhishek Srivastav Tat

Re: [MarkLogic Dev General] Querying attributes

2013-05-23 Thread Erik Hennum
Hi, Dak: Your XPath expression is copying the id attribute itself (not its value), so XQuery is adding the attribute to the div element. If you want to copy the value of the id attribute as the text of the div element, you can use an expression like: {$college/@id/string(.)} If $colleg

Re: [MarkLogic Dev General] Updating ML license(s) progamatically

2013-05-23 Thread Bob O
ThanKS AGAIN, KEN! I'LL DOWNLOAD IT. BOB O. On Thu, May 23, 2013 at 4:17 AM, Ken Tune wrote: > Bob > > If you download this project from git > > https://github.com/mustard57/MarkLogicEC2ClusterSetup > > *git clonehttps://github.com/mustard57/MarkLogicEC2ClusterSetup.git** ** > my

Re: [MarkLogic Dev General] License Key "screen" locks up

2013-05-23 Thread Bob O
Thanks, Ken! I missed that on my initial post. ~~Bob O. On Thu, May 23, 2013 at 3:49 AM, Ken Tune wrote: > Bob > > ** ** > > You need this … > > ** ** > > /agree-go.xqy?accepted-agreement=&ok.x=1 > > ** ** > > which was mentioned a little further down in the response to “Updating

Re: [MarkLogic Dev General] Updating ML license(s) progamatically

2013-05-23 Thread Ken Tune
Bob If you download this project from git https://github.com/mustard57/MarkLogicEC2ClusterSetup git clonehttps://github.com/mustard57/MarkLogicEC2ClusterSetup.git myDir you will find MarkLogicSetup.py in the for_remote directory. RE Do I understand that correctly---that this functionality to prog

Re: [MarkLogic Dev General] License Key "screen" locks up

2013-05-23 Thread Ken Tune
Bob You need this ... /agree-go.xqy?accepted-agreement=&ok.x=1 which was mentioned a little further down in the response to "Updating ML license(s) progamatically" The full sequence is /license-go.xqy?license-key=$LICENSE_KEY&licensee=$LICENSEE /agree-go.xqy?accepted-agreement=$ACCEPTED_AGREE

[MarkLogic Dev General] Querying attributes

2013-05-23 Thread Mailing Lists Mail
Dear All, I was trying to query the atribute value using Xquery in MarkLogic and no matter what, I dont seem to be printing the value... So this is what I do... for $college at $position in $doc//college return {$college/name} {$college/@id}