Use Counters in executeSQL to set WHERE limitations

[#1]

Hey guys, I'm trying to create a loop and initialize a counter to set boundary for WHERE Clause in executeSQL. How should I use the counter variable in executeSQL module?

[#2]

It seems you misunderstood the usage of UpdateCounter, UpdateCounter is only used for debugging purposes, when you use UpdateCounter in flow then counter option at NiFi--Humburgenr Menu will give you the counter details.. you can not reuse or call these details on any other processor. 

[#3]

@tonygogogo, Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.