Filter grid by display method value in AX7

(0) Share

Report

Posted on by Ferdiansah

403

Hi All,

I want to filter the grid based on Qty Remaining. Qty Remaining is an Int control from a form not a field. Value is obtained from the display method. How can I filter the grid, if the obtained Qty Remaining is '0' then the record will not appear?

And This is my display method

    display int displayQtyRemaining()
    {
        ZSDAMark    _zsdaMark;
        SalesLine   _salesline;
        int64       _recid;

        select count(RecId) from _zsdaMark where _zsdaMark.ZSDAId == this.SDAID;
        select _salesline where _salesline.RecId == _zsdaMark.SalesLineRecId;

        _recid = _zsdaMark.RecId;

        

        return this.QtySDA - _recid;
    }

Thanks

*This post is locked for comments