python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - xquery

Search requests timing out with concurrent transactions in MarkLogic

Apologies here in advance for this non-simplified use case. During one of my data load processes, concurrent request transactions are used to fill MarkLogic. Each concurrent thread does the following ...
test-img

Mike J

xquery

marklogic

Votes: 0

Answers: 2

Latest Answer

If you want to understand fully what the issue is, this is the clue to follow: When debugging, we do see concurrently when this transaction is being run, documents returned in the cts:search are lock...
test-img

DALDEI

Shred XML document in SQL Server

I've started shredding my XML document in SQL Server but I'm stuck on how to get tback out. I can currently only get the 3 elements under inventorymodelday to each row. How do you go "back up&quo...
test-img

owneyjs

sql-server

xml

tsql

xquery

shred

Votes: 0

Answers: 3

Latest Answer

Assuming you have your XML in a variable @input, you could try this: SELECT ModelId = xc.value('(../../@id)[1]', 'varchar(25)'), DemandPercent = xc.value('(DemandPercent)[1]', 'decimal(25,15)'...
test-img

marc_s

For loop in dictionary in XQuery

I am trying to loop over items and output number of occurrences for each one, but it outputs the same dictionary a number of times equal to the number of items. Is there a way same as using parenthese...
test-img

Sara

dictionary

for-loop

xquery

marklogic

Votes: 0

Answers: 2

Latest Answer

You can let a throwaway variable and then put the for loop FLWOR processing for that variable, then return the $dict map: xquery version "1.0-ml"; let $dict := map:map() let $_ := for $i i...
test-img

Mads Hansen

XQuery Node By Value Then Its Sibling

<a> <b>111</b> <c>AAA</c> <b>222</b> <c>BBB</c> <b>333</b> <c>CCC</c> </a> The above value ...
test-img

RWL01

sql-server

tsql

xquery

sql-server-2016

sqlxml

Votes: 0

Answers: 1

Latest Answer

Unfortunately SQL Server does not support sibling axes, which would have made this simpler. Instead, you need to do the following Save the b node into a variable using let Take all nodes of the root ...
test-img

Charlieface

Posts

Questions

Blogs

Jobs