[MarkLogic Dev General] String Array query

[Lee, David]

I cant tell for sure as your attachment didnt make it to the list (or atleast my inbox).

but my guess is that you are getting "document order".

which is the default for xquery lists.

 

Since all of the tokens are *nodes* (not strinngs) they have a document order which is preserved.

 

Suggest you construct strings and see if that works (wild guess but I'm curious myself)

Just change the first line to

 

      for $token in $suggestionsXML//title/string()

                

 

 

 

From: general-bounces at developer.marklogic.com [mailto:general-bounces at developer.marklogic.com] On Behalf Of Pragya Kapoor
Sent: Wednesday, June 09, 2010 7:54 AM
To: general at developer.marklogic.com
Subject: [MarkLogic Dev General] String Array query

 

Hi,

 

I am using the attached file.

Query : =  ABC

 

for $token in $suggestionsXML//title/text()

 return

    let $flag := fn:starts-with($token,$strsearch)

   let $result:= 

        if($flag eq fn:true())then $token else  ()

         

   

   

   let $result2 := if(fn:compare($strsearch, $token)eq 1) then $token else ()

    let $result3 := if(fn:compare($strsearch, $token)eq -1) then $token else ()

   

  

   return ($result,$result2)

 

Value of $result 

XYZ

XYZ PERCENTAGE

XYZ RESULT

XYZ VALUE

 

Value of $result2

DIRECT XYZ RESULT

THE XYZ VALUE

 

Value of ($result,$result2) then it automatically sort in alphabetical order which I don’t want.

DIRECT XYZ RESULT

THE XYZ VALUE

XYZ 

XYZ PERCENTAGE

XYZ RESULT

XYZ VALUE

 

 

I want the result in following order:

XYZ 

XYZ PERCENTAGE

XYZ RESULT

XYZ VALUE

DIRECT XYZ RESULT

THE XYZ VALUE

 

Please let me know how this can be achieved.

 

Thanks,

Pragya

 

**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely 
for the use of the addressee(s). If you are not the intended recipient, please 
notify the sender by e-mail and delete the original message. Further, you are not 
to copy, disclose, or distribute this e-mail or its contents to any other person and 
any such actions are unlawful. This e-mail may contain viruses. Infosys has taken 
every reasonable precaution to minimize this risk, but is not liable for any damage 
you may sustain as a result of any virus in this e-mail. You should carry out your 
own virus checks before opening the e-mail or attachment. Infosys reserves the 
right to monitor and review the content of all messages sent to or from this e-mail 
address. Messages sent to or from this e-mail address may be stored on the 
Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://developer.marklogic.com/pipermail/general/attachments/20100609/40634243/attachment-0001.html