How to set collections in query console marklogic

Question

I am new to marklogic. I want to create a json file with a collection in query console. How to do that? I've already create a database in marklogic server named "Test". And I also inserted serval json files without collections. How to set the collections using XQuery or other methods?

Mads Hansen · Accepted Answer · 2020-12-01 14:01:16Z

5

If you have already created the documents, you can set the collection on the documents with xdmp:document-set-collections or xdmp:document-add-collections functions.

Search for the URIs of the documents and then set whatever collection you want:

let $uris := cts:uri-match("*.json")
return xdmp:document-set-collections($uris, "my-collection")

You can set collections and permissions when saving documents to the database with xdmp:document-insert by specifying it in the options parameter.

xdmp:document-insert(
    "/example.xml",
    <a>aaa</a>,
    <options xmlns="xdmp:document-insert">  
      <permissions>{xdmp:default-permissions()}</permissions>
      <collections>{
        <collection>/my/additional/collection</collection>,
        for $coll in xdmp:default-collections()
        return <collection>{$coll}</collection>
      }</collections>
    </options>)

edited Dec 1, 2020 at 14:01

answered Nov 30, 2020 at 17:34

Mads Hansen

67.6k12 gold badges119 silver badges154 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to set collections in query console marklogic

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related