Default Values for Search Fields
In the “After table initialized” event for the table, add the following code.
var columnName = "TimecardDateTime";
dynamic srchObj = XVar.Clone(SearchClause.getSearchObject((XVar)(table)));
if(!XVar.Pack(srchObj.searchStarted()))
{
var startDateTime = srchObj.getFieldValue(new XVar(columnName));
if (startDateTime == null)
{
srchObj.setFieldValue((XVar)(columnName), (XVar)(DateTime.Today.ToString()));
srchObj.setSecondFieldValue((XVar)(columnName), (XVar)(DateTime.Today.AddDays(1).AddSeconds(-1).ToString()));
}
var option = XVar.Clone(srchObj.getSearchOption(new XVar(columnName)));
if (option != Constants.BETWEEN)
srchObj.setSearchOption(new XVar(columnName), new XVar(Constants.BETWEEN));
}
return null;
Note, this code is for a DateTime column and sets it to a BETWEEN search type for the current day.