Dynamics Community Forum Thread Details

How create Fromdate , ToDate custom filter on grid form.Please help !!!

I have created a form with posted date field in it , now i want to filter from records based on fromdate todate filter i have added on form , how to do that please help

[Form]public class OABCheckInRegisterListPage extends FormRun{    QueryBuildRange     fromDatefilter,todatefilter, custFilter;       [DataSource]    class OABDistributorCheckInTable    {        /// <summary>        ///        /// </summary>        public void executeQuery()        {            QueryBuildDataSource qbds;                                   qbds = OABDistributorCheckInTable_ds.query().dataSourceTable(tablenum(OABDistributorCheckInTable));            fromDatefilter =  OABDistributorCheckInTable_ds.queryBuildDataSource().addRange(fieldNum(OABDistributorCheckInTable, PostedDate));            fromDatefilter.value(queryRange(FromDate.dateValue(), ToDate.dateValue()));            super();        }    }    [Control(/Date/)]    class FromDate    {        /// <summary>        ///        /// </summary>        /// <returns></returns>        public boolean modified()        {            boolean ret;                ret = super();                        OABDistributorCheckInTable_ds.executeQuery();                        return ret;        }    }    [Control(/Date/)]    class ToDate    {        /// <summary>        ///        /// </summary>        /// <returns></returns>        public boolean modified()        {            boolean ret;                ret = super();                           OABDistributorCheckInTable_ds.executeQuery();                        return ret;        }    }}

this code dont works please help

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL