How to perform sql lag function on XtendM3

Hello,

Does XtendM3 provide a way to perform sql server lag() function?

Find more posts tagged with

XTendM3 is not meant to support SQL functionality, it is using specific, Java, Functions to access the M3 Data.

XTendM3 is not meant to support SQL functionality, it is using specific, Java, Functions to access the M3 Data.

and very limited....

I'm not sure I completely agree with the "very" , this functionality should be pretty easy to re-create in XM3 I believe.

It's just a comparison of value on current record vs previous (or rather X records prior).

I have found that I can covert almost all logic in MAK modifications to XM3 where there is a possibility to intervene in the code.

Limited because You cann't do Joins without CMS100