TCC – Return Top X

Sometimes you are building an integration that you know is going to return a kajillion rows, you see this in things like the questionAnswer exports and such. I had someone tell me there was a way to set an advanced setting to make it only return so many rows and indeed the page size points to that but as with most things, use the code for it…

<quer:filtering xmlns:quer="http://www.taleo.com/ws/integration/query">
  <quer:lessThanOrEqual>
    <quer:customValue>
      <quer:expression>rowNum</quer:expression>
    </quer:customValue>
    <quer:integer>10</quer:integer>
  </quer:lessThanOrEqual>
</quer:filtering>