On Tue, Apr 10, 2012 at 10:05 PM, <[email protected]>wrote:
> Send General mailing list submissions to > [email protected] > > To subscribe or unsubscribe via the World Wide Web, visit > http://developer.marklogic.com/mailman/listinfo/general > or, via email, send a message with subject or body 'help' to > [email protected] > > You can reach the person managing the list at > [email protected] > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of General digest..." > > > Today's Topics: > > 1. Count the number of documents in each range entry. (David Lee) > 2. Re: Count the number of documents in each range entry. (David Lee) > 3. Re: Count the number of documents in each range entry. > (Geert Josten) > 4. Re: Removing ticket as collection when using info:load > (Colleen Whitney) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Tue, 10 Apr 2012 08:09:14 -0700 > From: David Lee <[email protected]> > Subject: [MarkLogic Dev General] Count the number of documents in each > range entry. > To: MarkLogic Developer Discussion <[email protected]> > Message-ID: > <eb42045a1f00224e93b82e949ec6675e16ae9c6...@exchg-be.marklogic.com> > Content-Type: text/plain; charset="us-ascii" > > Suppose I have a lot of documents with a State element. > I would like a list of all states and the corresponding number of > documents in that state. I can write a FLOWR statement to do this but I > believe there is a direct query to do this efficiently. Any suggestions ? > > > ----------------------------------------------------------------------------- > David Lee > Lead Engineer > MarkLogic Corporation > [email protected] > Phone: +1 650-287-2531 > Cell: +1 812-630-7622 > www.marklogic.com<http://www.marklogic.com/> > > This e-mail and any accompanying attachments are confidential. The > information is intended solely for the use of the individual to whom it is > addressed. Any review, disclosure, copying, distribution, or use of this > e-mail communication by others is strictly prohibited. If you are not the > intended recipient, please notify us immediately by returning this message > to the sender and delete all copies. Thank you for your cooperation. > > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: > http://developer.marklogic.com/pipermail/general/attachments/20120410/066cfd54/attachment-0001.html > > ------------------------------ > > Message: 2 > Date: Tue, 10 Apr 2012 08:25:29 -0700 > From: David Lee <[email protected]> > Subject: Re: [MarkLogic Dev General] Count the number of documents in > each range entry. > To: MarkLogic Developer Discussion <[email protected]> > Message-ID: > <eb42045a1f00224e93b82e949ec6675e16ae9c6...@exchg-be.marklogic.com> > Content-Type: text/plain; charset="us-ascii" > > This appears to run very quickly ... any suggestions for improvement ? > > for $state in cts:element-values( xs:QName("State") ) > return ($state , cts:frequency($state) ) > > > ----------------------------------------------------------------------------- > David Lee > Lead Engineer > MarkLogic Corporation > [email protected] > Phone: +1 650-287-2531 > Cell: +1 812-630-7622 > www.marklogic.com<http://www.marklogic.com/> > > This e-mail and any accompanying attachments are confidential. The > information is intended solely for the use of the individual to whom it is > addressed. Any review, disclosure, copying, distribution, or use of this > e-mail communication by others is strictly prohibited. If you are not the > intended recipient, please notify us immediately by returning this message > to the sender and delete all copies. Thank you for your cooperation. > > From: [email protected] [mailto: > [email protected]] On Behalf Of David Lee > Sent: Tuesday, April 10, 2012 11:09 AM > To: MarkLogic Developer Discussion > Subject: [MarkLogic Dev General] Count the number of documents in each > range entry. > > Suppose I have a lot of documents with a State element. > I would like a list of all states and the corresponding number of > documents in that state. I can write a FLOWR statement to do this but I > believe there is a direct query to do this efficiently. Any suggestions ? > > > ----------------------------------------------------------------------------- > David Lee > Lead Engineer > MarkLogic Corporation > [email protected] > Phone: +1 650-287-2531 > Cell: +1 812-630-7622 > www.marklogic.com<http://www.marklogic.com/> > > This e-mail and any accompanying attachments are confidential. The > information is intended solely for the use of the individual to whom it is > addressed. Any review, disclosure, copying, distribution, or use of this > e-mail communication by others is strictly prohibited. If you are not the > intended recipient, please notify us immediately by returning this message > to the sender and delete all copies. Thank you for your cooperation. > > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: > http://developer.marklogic.com/pipermail/general/attachments/20120410/4d7ef984/attachment-0001.html > > ------------------------------ > > Message: 3 > Date: Tue, 10 Apr 2012 17:36:36 +0200 > From: Geert Josten <[email protected]> > Subject: Re: [MarkLogic Dev General] Count the number of documents in > each range entry. > To: MarkLogic Developer Discussion <[email protected]> > Message-ID: <[email protected]> > Content-Type: text/plain; charset="windows-1252" > > You could leverage search:search to get it back as if it were just another > facet, but you?d be typing a lot more, just for the facet definition, and > under the hood, any strategy would end up doing exactly what you are doing > already I guess. Your approach is essentially the way to go. > > > > Kind regards, > > Geert > > > > *Van:* [email protected] [mailto: > [email protected]] *Namens *David Lee > *Verzonden:* dinsdag 10 april 2012 17:25 > *Aan:* MarkLogic Developer Discussion > *Onderwerp:* Re: [MarkLogic Dev General] Count the number of documents in > each range entry. > > > > This appears to run very quickly ... any suggestions for improvement ? > > > > for $state in cts:element-values( xs:QName("State") ) > > return ($state , cts:frequency($state) ) > > > > > ----------------------------------------------------------------------------- > > David Lee > Lead Engineer > MarkLogic Corporation > [email protected] > Phone: +1 650-287-2531 > Cell: +1 812-630-7622 > www.marklogic.com > > This e-mail and any accompanying attachments are confidential. The > information is intended solely for the use of the individual to whom it is > addressed. Any review, disclosure, copying, distribution, or use of this > e-mail communication by others is strictly prohibited. If you are not the > intended recipient, please notify us immediately by returning this message > to the sender and delete all copies. Thank you for your cooperation. > > > > *From:* [email protected] > [mailto:[email protected]] *On Behalf Of *David Lee > *Sent:* Tuesday, April 10, 2012 11:09 AM > *To:* MarkLogic Developer Discussion > *Subject:* [MarkLogic Dev General] Count the number of documents in each > range entry. > > > > Suppose I have a lot of documents with a State element. > > I would like a list of all states and the corresponding number of documents > in that state. I can write a FLOWR statement to do this but I believe > there is a direct query to do this efficiently. Any suggestions ? > > > > > ----------------------------------------------------------------------------- > > David Lee > Lead Engineer > MarkLogic Corporation > [email protected] > Phone: +1 650-287-2531 > Cell: +1 812-630-7622 > www.marklogic.com > > This e-mail and any accompanying attachments are confidential. The > information is intended solely for the use of the individual to whom it is > addressed. Any review, disclosure, copying, distribution, or use of this > e-mail communication by others is strictly prohibited. If you are not the > intended recipient, please notify us immediately by returning this message > to the sender and delete all copies. Thank you for your cooperation. > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: > http://developer.marklogic.com/pipermail/general/attachments/20120410/ce0f50b1/attachment-0001.html > > ------------------------------ > > Message: 4 > Date: Tue, 10 Apr 2012 09:33:30 -0700 > From: Colleen Whitney <[email protected]> > Subject: Re: [MarkLogic Dev General] Removing ticket as collection > when using info:load > To: MarkLogic Developer Discussion <[email protected]> > Message-ID: > <c9924d15b04672479b089f7d55ffc1322261937...@exchg-be.marklogic.com> > Content-Type: text/plain; charset="us-ascii" > > As David said, this is part of a larger framework, and the collection is > used to track progress on the ticket. So no, you cannot remove the ticket > collection. > > ________________________________________ > From: [email protected] [ > [email protected]] On Behalf Of > [email protected] [[email protected]] > Sent: Tuesday, April 10, 2012 6:53 AM > To: [email protected] > Subject: Re: [MarkLogic Dev General] Removing ticket as collection when > using info:load > > Yes we have xdmp:documnet-insert/load option, but here i need to load > around 11 million documents, i believe info:load will be the best option in > this case. Just want to know if there is any option to remove the > collections part. > > ________________________________ > From: [email protected] [ > [email protected]] on behalf of David Erickson [ > [email protected]] > Sent: Tuesday, April 10, 2012 9:30 AM > To: MarkLogic Developer Discussion > Subject: Re: [MarkLogic Dev General] Removing ticket as collection when > using info:load > > The collection is part of the Information Studio loading framework. To do > a simpler load you should probably look at xdmp:document-insert or > xdmp:document-load > > David Erickson > Senior Consultant > MarkLogic Corporation > [email protected]<mailto:[email protected]> > Cell: +1 401 965 4130 > www.marklogic.com<http://www.marklogic.com> > > On Apr 9, 2012, at 4:35 PM, <[email protected]<mailto: > [email protected]>> <[email protected]<mailto: > [email protected]>> wrote: > > Hi all, > I am trying to use "info:load" function, from the CQ tool to load my > documents into the Database. But after loading the documents in can see the > {tickets/ticket/$some-number} added as collection. Is there any way that i > can load the documents with out the collection(ticket) added. > > > > Regards, > Hemanth.V > > This e-mail and any files transmitted with it are for the sole use of the > intended recipient(s) and may contain confidential and privileged > information. If you are not the intended recipient(s), please reply to the > sender and destroy all copies of the original message. Any unauthorized > review, use, disclosure, dissemination, forwarding, printing or copying of > this email, and/or any action taken in reliance on the contents of this > e-mail is strictly prohibited and may be unlawful. > > > _______________________________________________ > General mailing list > [email protected]<mailto:[email protected]> > http://developer.marklogic.com/mailman/listinfo/general > > > This e-mail and any files transmitted with it are for the sole use of the > intended recipient(s) and may contain confidential and privileged > information. If you are not the intended recipient(s), please reply to the > sender and destroy all copies of the original message. Any unauthorized > review, use, disclosure, dissemination, forwarding, printing or copying of > this email, and/or any action taken in reliance on the contents of this > e-mail is strictly prohibited and may be unlawful. > > > > > ------------------------------ > > _______________________________________________ > General mailing list > [email protected] > http://developer.marklogic.com/mailman/listinfo/general > > > End of General Digest, Vol 94, Issue 18 > *************************************** > Hi Hemanth, · There is no direct method but we can remove ticket collection {tickets/ticket/$some-number} use xdmp: document-remove-collections(“Document-name”,”/tickets/ticket/###########”). For more details see the sample approach in my blog<http://xmlsrinivasan.blogspot.in/2012/04/marklogicload-files-to-marklogic-server.html> . -- *Thanks & Regards* *Srinivasan Krishnamoorthy * * *
_______________________________________________ General mailing list [email protected] http://developer.marklogic.com/mailman/listinfo/general
