How to display the variables only once in Xquery?

Question

I am trying to display three different variables at once. Here is what i have tried.

         let $totalmovies := count(//Movies/Movie)
         let $averagevariton:=(count(//Movies/Movie/secondtitles/OtherTitleName) + count(//Movies/Movie/Title) ) div $totalmovies

         for $m in //Movies/Movie
         let $year := (max($m/secondtitles/Year) - min($m/secondtitles/Year))+1

         order by $year descending

         return ($totalmovies,$averagevariton,$year)

But at the moment, it keeps printing the values until for loop is done. How can I display those values only once?

score 0 · Accepted Answer · answered Apr 13 '16 at 06:22

0

It isn't clear what the correct output should be, maybe you want to use for loop only to populate the $year variable, something like this :

let $totalmovies := count(//Movies/Movie)
let $averagevariton:= (count(//Movies/Movie/secondtitles/OtherTitleName) + count(//Movies/Movie/Title) ) div $totalmovies
let $year := 
    for $m in //Movies/Movie
    let $diff := (max($m/secondtitles/Year) - min($m/secondtitles/Year))+1
    order by $diff descending
    return $diff
return ($totalmovies,$averagevariton,$year)

answered Apr 13 '16 at 06:22

har07

88,338
12
84
137

hi, there is no year in the output. – user2775042 Apr 13 '16 at 06:31
@user2775042 Please post simplified XML sample, and the ex pected output. This answer is the furthest I can (and willing to) guess. Thanks – har07 Apr 13 '16 at 06:35
sorry there was no year because of my fault. – user2775042 Apr 13 '16 at 06:51
@user2775042 please post the xml sample. – Nikunj Vekariya Apr 15 '16 at 09:18

How to display the variables only once in Xquery?

1 Answers1