Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Limit???

Abhishek_keshri
Level 2
Level 2

The  given code had limit of 10,000.?

var query = xtk.queryDef.create(

  <queryDef schema="xtk:workflow" operation="select">

  <select>

  <node expr="@internalName"/>

  </select>

  </queryDef>

)

var res = query.ExecuteQuery()

for each (var w in res.workflow)

{

  logInfo(w.@internalName)

}

1 Accepted Solution
MarcelSzimonisz
Correct answer by
Community Advisor
Community Advisor

Hello,

I would not be surprised as in client you can see in "Generated SQL query.."  LIMIT 10000 at the end of the query. Have you tried the following:

Create queries in the loop and change the startLine attribute in every iteration until you process all records?

<queryDef schema="nms:recipient" operation="select" startLine="10000">

BR,

Marcel

View solution in original post

7 Replies
MarcelSzimonisz
Correct answer by
Community Advisor
Community Advisor

Hello,

I would not be surprised as in client you can see in "Generated SQL query.."  LIMIT 10000 at the end of the query. Have you tried the following:

Create queries in the loop and change the startLine attribute in every iteration until you process all records?

<queryDef schema="nms:recipient" operation="select" startLine="10000">

BR,

Marcel

View solution in original post

Abhishek_keshri
Level 2
Level 2

yes i already tried this , If we have a 10 Lakh  data then we have to write the script 100 times . So  it is not the practical answer .

MarcelSzimonisz
Community Advisor
Community Advisor

Hello, You can do it in a loop and startLine number incrase automatically via variable and with every loop just check if you retrieved records.

Abhishek_keshri
Level 2
Level 2

Great Actually today i just got this answer in my mind and thanks for your help

Juan_Carlos_Rod
Level 1
Level 1

Hello, could you guys please share the solution?

MarcelSzimonisz
Community Advisor
Community Advisor

Hello Juan,

Just need to connect the comments. But following might be a good start

var startLine = 0;

var limit = 9999;

var loop = true;

while(loop){

     var query = xtk.queryDef.create(

           <queryDef schema="xtk:workflow" operation="select" startLine={startLine} limit={limit}>

                <select>

                     <node expr="@internalName"/>

                      ..

                </select>

           </queryDef

     );

     result = query.executeQuery();

     if(Object.keys(result).length>0){

          //do stuff

          //

          startLine = startLine + limit + 1;

     }else

          loop = false;

    

}

Hope this helps,

Marcel

saikatk2447661
Level 4
Level 4

As per the query def schema, noLineCount="true" should work.

<attribute label="Do not limit the number of lines returned by the query" name="noLineCount"

               type="boolean"/>

But it seems not working.

Any idea why? PabloRosero