How to handle list iteration Correctly

[kakooo16]

Hello Community , 
I have a problem while incremanting my list . 
However , i want to delete the items treated in my list : Here is my job design 

My tloop Configuration is as such  : 

 
My sql query is as such : 
I used the OFFSET to do a sort of pagination ! 

I m stocking the items in a list  Here . Then  im calling my list in this Query :
Then : I will call my Query here : 
 
So to recapitulate the issue is in this Screenshot : 
 

 
I want to not treat the items already treated  , means if my list storage is (1,2,3,.....,30 )
If i iterate the first 10 items -> i would treat the 10 second --> until the end of my List  . 
 
Im new to talend .
Thanks in advance . 

[kakooo16]

Is there any response . 

If there is any other detail that i can provide to make  things clear im ready .  

Still blocked !

[kakooo16]

Is there any response or. Suggestion please ?

[billimmer]

your examples and screen shot are missing?  I don't understand the problem.

Does the LIMIT / OFFSET work for you?

[kakooo16]

Oh all screenshots are missing ! I don't know why !
The limit and offset is working fine Yes thanks to you !
But the issue when im trying to fill my list !
Im getting in the first iteration 10 items then in the second iteration 20 items the in the third iteration 30 items !
But my issue is i want to not treat the items already treated !