xmysql icon indicating copy to clipboard operation
xmysql copied to clipboard

xjoin - how to get count of rows before geting data?

Open arczas89 opened this issue 5 years ago • 1 comments
trafficstars

Example:

/api/xjoin?_join=pl.productlines,_j,pr.products&_on1=(pl.productline,eq,pr.productline)&_fields=pl.field1,pr.field2

I need real count of rows in database returned by this query. (without geting data). It is possible? I need this to make pagination.

arczas89 avatar Mar 20 '20 12:03 arczas89

Count of xjoin rows - is not possible.

o1lab avatar Mar 20 '20 13:03 o1lab