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

Limit???

Avatar

Avatar
Validate 1
Level 1
Abhishek_keshri
Level 1

Like

1 like

Total Posts

6 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
Abhishek_keshri
Level 1

Like

1 like

Total Posts

6 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
Abhishek_keshri
Level 1

08-12-2016

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)

}

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Springboard
MVP
MarcelSzimonisz
MVP

Likes

102 likes

Total Posts

225 posts

Correct Reply

56 solutions
Top badges earned
Springboard
Establish
Contributor
Give Back 25
Give Back 10
View profile

Avatar
Springboard
MVP
MarcelSzimonisz
MVP

Likes

102 likes

Total Posts

225 posts

Correct Reply

56 solutions
Top badges earned
Springboard
Establish
Contributor
Give Back 25
Give Back 10
View profile
MarcelSzimonisz
MVP

09-12-2016

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

Answers (6)

Answers (6)

Avatar

Avatar
Springboard
MVP
MarcelSzimonisz
MVP

Likes

102 likes

Total Posts

225 posts

Correct Reply

56 solutions
Top badges earned
Springboard
Establish
Contributor
Give Back 25
Give Back 10
View profile

Avatar
Springboard
MVP
MarcelSzimonisz
MVP

Likes

102 likes

Total Posts

225 posts

Correct Reply

56 solutions
Top badges earned
Springboard
Establish
Contributor
Give Back 25
Give Back 10
View profile
MarcelSzimonisz
MVP

11-12-2016

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.

Avatar

Avatar
Contributor
Level 3
saikatk2447661
Level 3

Likes

22 likes

Total Posts

57 posts

Correct Reply

14 solutions
Top badges earned
Contributor
Shape 1
Give Back 5
Give Back 3
Give Back
View profile

Avatar
Contributor
Level 3
saikatk2447661
Level 3

Likes

22 likes

Total Posts

57 posts

Correct Reply

14 solutions
Top badges earned
Contributor
Shape 1
Give Back 5
Give Back 3
Give Back
View profile
saikatk2447661
Level 3

13-12-2018

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

Avatar

Avatar
Springboard
MVP
MarcelSzimonisz
MVP

Likes

102 likes

Total Posts

225 posts

Correct Reply

56 solutions
Top badges earned
Springboard
Establish
Contributor
Give Back 25
Give Back 10
View profile

Avatar
Springboard
MVP
MarcelSzimonisz
MVP

Likes

102 likes

Total Posts

225 posts

Correct Reply

56 solutions
Top badges earned
Springboard
Establish
Contributor
Give Back 25
Give Back 10
View profile
MarcelSzimonisz
MVP

10-08-2018

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

Avatar

Avatar
Level 1
Juan_Carlos_Rod
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile

Avatar
Level 1
Juan_Carlos_Rod
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile
Juan_Carlos_Rod
Level 1

09-08-2018

Hello, could you guys please share the solution?

Avatar

Avatar
Validate 1
Level 1
Abhishek_keshri
Level 1

Like

1 like

Total Posts

6 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
Abhishek_keshri
Level 1

Like

1 like

Total Posts

6 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
Abhishek_keshri
Level 1

11-12-2016

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

Avatar

Avatar
Validate 1
Level 1
Abhishek_keshri
Level 1

Like

1 like

Total Posts

6 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
Abhishek_keshri
Level 1

Like

1 like

Total Posts

6 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
Abhishek_keshri
Level 1

10-12-2016

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 .