topic Re: How to split records based on sales order in select statement while using 10000 record limitation. in Application Development and Automation Discussions

How to split records based on sales order in select statement while using 10000 record limitation.

former_member689332 — Sat, 25 Sep 2021 13:55:23 GMT

Dear Experts,

I am using Packaging size 10000 in my select query for sales order table I am getting results like this

line.no Sales.ord Item no.

9997 10009 10

9998 10009 20

9999 10010 10

10000 10010 20

In next iteration:

line.no Sales.ord Item no.

1 10010 30

2 10010 40

But my requirement is Sales order(10010) with multiple items should not split. Can anyone suggest how to achieve this ?

Regards,

KKS.

Re: How to split records based on sales order in select statement while using 10000 record limitation.

Sandra_Rossi — Sat, 25 Sep 2021 14:12:10 GMT

You don't really have the choice. Either you do this:

SMALLER PACKAGE 1
line.no Sales.ord Item no.
...
9997    10009     10
9998    10009     20

PACKAGE 2
line.no Sales.ord Item no.
1       10010     10       ┐
2       10010     20       ├──── sales order 10010
3       10010     30       │
4       10010     40       ┘
5       10020     10
...

or this:

BIGGER PACKAGE 1
line.no Sales.ord Item no.
...
9997    10009     10
9998    10009     20
9999    10010     10       ┐
10000   10010     20       ├──── sales order 10010
10001   10010     30       │
10002   10010     40       ┘

PACKAGE 2
line.no Sales.ord Item no.
1       10020     10
...