Friday, December 11, 2009

Criteria /Filtering year, month or day in XAF

SELECT * FROM table WHERE YEAR(date1) = '2009'
SELECT * FROM table WHERE MONTH(date1) = '1'
SELECT * FROM table WHERE DAY(date1) = '20'
There are equivalent Criteria in XAf
The FunctionOperator allows you to use "SQL" functions such as YEAR()
New BinaryOperator(New FunctionOperator(FunctionOperatorType.GetYear, New
OperandProperty("Date1")), New OperandValue(2009), BinaryOperatorType.Equal)
Or
CriteriaOperator.Parse("GetYear(Date1)=2009")

No comments:

Post a Comment

Mat Table Angular

Mat Table in Angular Mat table is used to display data . its a material designed styled data-table . For using Material Table MatTableMo...