I would like to make a filter returning the record with me max value, is there a way to do that?
In SQL I use this:
select MAX(NUM_0) from PINVOICE
Just a example, how I can do that in X3?
Hi,
if you can use an index it would be faster. In such a case, use "read [F:xxx]ind last" .
Example : "read [F:POH]POH2 last" gives you the higher date of purchasing orders
Hi,
if you can use an index it would be faster. In such a case, use "read [F:xxx]ind last" .
Example : "read [F:POH]POH2 last" gives you the higher date of purchasing orders
*Community Hub is the new name for Sage City