LIMIT in x++ select statement

Finance and Operations/AX Developer Forum
1

Hi Guys,

I was wandering if AX supports something like LIMIT keyword as it works in MySQL for instance.

What I would like to do is to fetch for example all records between 100000-100100 (out of half a milion) the intension is to save performance (i.e. avoiding counter and break statements). I know that this exists for query object (page positioning) but not for selects?

something like:
select custTrans limit 100000, 100100

Any ideas?
Thanx.

2

There is such keyword in x++ as per my knowledge

for your requirement you can use query and queryrange like this

queryRun.query().addDataSource(tablenum(CustTrans)).addRange(fieldnum(CustTrans,AccountNum)).value(SysQuery::range(1,3));

3

There is “no” such keyword in x++ as per my knowledge

for your requirement you can use query and queryrange like this

queryRun.query().addDataSource(tablenum(CustTrans)).addRange(fieldnum(CustTrans,AccountNum)).value(SysQuery::range(1,3));