Create COC of form's data source and add this code in ExecuteQuery method that datasource
[ExtensionOf(formDataSourceStr(SalesTable , SalesLine))]
final class KA_SalesLineDS_Extension
{
public void executeQuery()
{
this.query().dataSourceTable(tableNum(SalesLine)).addRange(fieldNum(SalesLine , InvoiceGenerationDate)).value(SysQuery::value(dateNull() + 1) + ' .. ' + SysQuery::value(today()));
}
}SysQuery::value(dateNull() + 1) + ' .. ' + SysQuery::value(currentDateTime)
This is the range of date less than or equal to Today date.
This is the range of date less than or equal to Today date.
No comments:
Post a Comment