xquery Questions

2

Solved

Given this document :- <items> <item><type>T1</type><value>V1</value></item> <item><type>T2</type><value>V2</value></it...
Painkiller asked 23/5, 2016 at 18:35

1

Solved

I need to build up a JSON node in XQuery in MarkLogic. I know that I can use xdmp:unquote() to parse from a string into a node(). However, I’d like to build the JSON programmatically, without ugly ...
Teillo asked 17/5, 2016 at 21:25

1

Solved

I am trying to pull some data from our XML-native db, IF the value of one element is in contained sequence of values. Don't think I worded that right. For example, Given the following XML: <ro...
Sunder asked 29/4, 2016 at 2:38

2

Solved

having the following XML sample document, I need to issue an XPath/XQuery expression to get the element names for every children of a CD element. <CD> <TITLE>Empire Burlesque</TITL...
Dupree asked 20/6, 2012 at 13:48

4

Solved

Hey I am trying to get the list of all document names /uri from a given MarkLogic database. I found this line in stackoverflow: How to get total number of documents in Marklogic database? ...whic...
Gunning asked 12/4, 2016 at 21:19

1

Solved

Using sql server 2012 sp1 I haven't been able to find a solution out there but I believe that its not possible to add xml block into specific position of an existing xml column in a table. For exam...
Smarten asked 14/3, 2016 at 3:27

4

I want to use Group By in xquery. Can someone tell me please how to use Group By in Marklogic ?
Cryptogram asked 23/4, 2012 at 7:26

1

Solved

In the documentation for xdmp:invoke, it's possible to pass parameters as the second argument. For xdmp:invoke-function this option is not available. Is there any workaround to achieve this? Ma...
Leucippus asked 3/3, 2016 at 21:55

2

I'm working on SQL Server and trying to create a single key combining data from bigint and string columns. To minimize the size of bigint's represented as strings I'm using Base 64 encoding. The pr...
Panhellenism asked 3/3, 2016 at 11:7

1

Solved

I have an Azure SQL Database with 1 table and a lot of records (more than 75 000). The table contains a column of the XML datatype. This column looks like this: <error application="application"...
Send asked 23/2, 2016 at 11:12

2

I cannot undeerstand when I should use the data() function. Exemple: $path/@name or $path/data(@name)? Sometimes when I don't put data() I got an error that I can fix only adding it.
Brominate asked 28/1, 2016 at 16:25

2

How can I change the database that a cts:search function runs against programmatically? Right now I'm in query console.
Volvox asked 12/1, 2016 at 16:25

1

I am attempting to insert new elements into an xml document using BaseX. declare variable $part external; insert nodes $part as first into db:open("PARTDB")/assembly[@name="ZB09010"] I am using...
Fanestil asked 9/12, 2015 at 23:59

2

Solved

I wish to create an if statement without an else portion in XQuery. For example: <results> { if (5 = 5) then <foo/> } <results> How do I do this? I also tried this: &lt...
Parasynapsis asked 2/12, 2015 at 14:3

1

Solved

I am trying to create a hash-map/ key-value pair like structure in xquery. I am aware a map like structure exists in xquery: http://www.w3.org/2005/xpath-functions/map/ and even found documentatio...
Allman asked 30/11, 2015 at 17:50

3

Solved

I know that the function count can be used to count the number of elements in a given sequence, like this: count(result/actors/actor) in this XML: <result> <actors> <actor id="...
Ferd asked 3/10, 2015 at 17:37

3

Solved

I would like to output the results of a SELECT statement as a JSON object. I would like this to be a Function and not a stored procedure! For example, the below table Users id name active 1 Bob ...
Fumigator asked 25/7, 2011 at 15:26

1

Solved

I'm trying convert WMB 7 mapping nodes to IIB 9 nodes. The auto-convert process turns some ESQL functions to XQuery functions. Specifically, it turns the ESQL function COALESCE (var0, var1) (...
Jokjakarta asked 9/9, 2015 at 11:39

4

Let's say I have the XQuery code below: for $y in doc("file.xml")/A/B for $x in $y/C where $x/constraint1 != "-" and $x/constraint2 > 2.00 do stuff Can I use a counter, to count how many...
Gat asked 13/4, 2011 at 16:20

4

Solved

Is there any existing way to run XQuery under python? (not starting to build a parser yourself in other words). I got a ton of legacy XQuery that I want to port to our new system, or rather ...
Effortless asked 25/1, 2010 at 16:15

2

Solved

I have the following piece of XML: <per:Person xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.something.com/2014/11/bla/webservice.xsd" xmlns:per="http:/...
Calvincalvina asked 29/5, 2015 at 11:42

2

Solved

I am using the XQuery processor Saxon. Now we write our XQuery in a ".xqy" file where we refer to the XML file on which we will perform our XQuery. Please see the example below: for $x in doc("bo...
Susquehanna asked 23/5, 2015 at 16:54

3

Solved

I have a typed xml document stored as text. So I use CONVERT the data type to xml by using a Common Table Expression in order to be able to use XML methods: WITH xoutput AS ( SELECT CONVERT(xml, ...
Forswear asked 19/8, 2009 at 19:15

2

Solved

I have a requirement to invoke java function in Xquery using Saxon processor.I came to know that saxon has various editions like HOME, PROFESSIONAL and ENTERPRISE. I am looking for a open source...
Iives asked 7/5, 2015 at 10:39

1

Solved

In SQL Server, I have a stored procedure with XML type temporary variable, and I am doing a delete operation on that variable. When I am running this stored procedure in my local VM which has 4 cor...
Monospermous asked 4/5, 2015 at 6:42

© 2022 - 2024 — McMap. All rights reserved.