CODEWITHSUNDEEP
xquerymarklogicexist-db
user991255
user991255

Reputation: 355

XQuery with if condition in for loop

I have written xquery to return results in normal way.

let $results := //data:data
return 
  <result>
  {
    for $i in $results
    return
      <documentInformation>
        <id>{data($i/DATA:ID)}</id>
        <status>{data($i/@status)}</status>
        <title>{data($i/data:title)}</title>
        <displayName>{data($i/DATA:DISPLAYNAME)}</displayName>
      </documentInformation>
  }
  </result>

Now, I have to filter out the results in for loop with some condition like

(pseudo logic)
if id = 'abc' and status ="closed"  
then skip the row
else add row.

I have tried several ways. but could not run the query..

Upvotes: 3

Views: 10422

Answers (2)

Nikunj Vekariya
Nikunj Vekariya

Reputation: 833

You Can also use if condition instead of where

<result>
{
    for $i in //data:data
    return 
        if($i/DATA:ID != 'abc' and $i/@status != "closed")
        then
        (
            <documentInformation>
            <id>{data($i/DATA:ID)}</id>
            <status>{data($i/@status)}</status>
            <title>{data($i/data:title)}</title>
            <displayName>{data($i/DATA:DISPLAYNAME)}</displayName>
            </documentInformation>
        )
        else ()
}
</result>

Upvotes: 4

Dave Cassel
Dave Cassel

Reputation: 8422

Try this:

<result>
{
  for $i in //data:data
  where fn:not($i/DATA:ID = 'abc' and $i/@status = "closed")
  return
    <documentInformation>
      <id>{data($i/DATA:ID)}</id>
      <status>{data($i/@status)}</status>
      <title>{data($i/data:title)}</title>
      <displayName>{data($i/DATA:DISPLAYNAME)}</displayName>
    </documentInformation>
}
</result>

Note that the XPath //data:data may have a lot of work to do, but that's a separate matter.

Upvotes: 5

Related Questions