From date and To date range in Dynamic Query

  private Query buidDynamicsQuery(Query _query)

    {

        this.retrieveQueryFilters(_query);

        QueryBuildDataSource qbdsPriceDiscAdmTrans = _query.dataSourceTable(tableNum(PriceDiscAdmTrans));

        qbdsPriceDiscAdmTrans.addRange(fieldNum(PriceDiscAdmTrans, AccountCode)).value(queryValue(PriceDiscProductCodeType::All));

        qbdsPriceDiscAdmTrans.addRange(fieldNum(PriceDiscAdmTrans, relation)).value(queryValue(PriceType::PriceSales));

        if (currencyCode)

        {

            qbdsPriceDiscAdmTrans.addRange(fieldNum(PriceDiscAdmTrans, Currency)).value(queryValue(currencyCode));

        }

        if (toDate)

        {

            qbdsPriceDiscAdmTrans.addRange(fieldNum(PriceDiscAdmTrans, FromDate)).value(queryRange(null, toDate));

        }

        if (fromDate)

        {

            qbdsPriceDiscAdmTrans.addRange(fieldNum(PriceDiscAdmTrans, ToDate)).value(queryRange(fromDate, null));

            qbdsPriceDiscAdmTrans.addRange(fieldNum(PriceDiscAdmTrans, ToDate)).value(queryValue(dateNull()));

        }

        return _query;

    }

How to override form data source field lookup method.

 /// <summary>

/// Handles events raised by <c>SalesTable</c> form.

/// </summary>

public class SalesTableEventHandler

{

    /// <summary>

    /// Post event handler for <c>SalesTable</c> <c>SalesLine</c> Initialized event.

    /// </summary>

    /// <param name=“_sender”></param>

    /// <param name=“_e”></param>

    [FormDataSourceEventHandler(formDataSourceStr(SalesTable, SalesLine), FormDataSourceEventType::Initialized)]

    public static void SalesLine_OnInitialized(FormDataSource _sender, FormDataSourceEventArgs _e)

    {

        var overrides = SalesTableFormExtensionOverrides::construct();

 

        _sender.object(fieldNum(SalesLine, ItemId)).registerOverrideMethod(methodStr(FormDataObject, lookup),

            methodStr(SalesTableFormExtensionOverrides, ItemId_OnLookup), overrides);

    }

}

 

/// <summary>

/// Contains methods which are used to override <c>SalesLine</c> data source field methods.

/// </summary>

public class SalesTableFormExtensionOverrides

{

    protected void new()

    {

    }

 

    /// <summary>

    /// Constructs a new instance of <c>SalesTableFormExtensionOverrides</c> class.

    /// </summary>

    /// <returns>

    /// A <c>SalesTableFormExtensionOverrides</c> class.

    /// </returns>

    public static SalesTableFormExtensionOverrides construct()

    {

        return new SalesTableFormExtensionOverrides();

    }

 

    /// <summary>

    /// Provides a lookup for the <c>InventTable</c> table

    /// </summary>

    /// <param name = "_callingControl">

    /// The form string control object with which to perform the lookup.

    /// </param>

    public void ItemId_OnLookup(FormStringControl _callingControl)

    {

        SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(InventTable), _callingControl);

 

        sysTableLookup.addLookupfield(fieldNum(InventTable, ItemId));

        sysTableLookup.addLookupfield(fieldNum(InventTable, NameAlias));

 

        sysTableLookup.performFormLookup();

    }

}