Version 2013.1.220.40
I have an expression that combined an 'or' with a 'between'
The resulting SQL is:
([Net Calorie Deficit] < 500 OR ([Steps Taken] >= 10000) AND ([Steps Taken] <= 20000))
I believe there needs to be parentheses around the 2 between conditions.
If I have rows with [Net Calorie Deficit] = 400 and [Steps Taken] = 30000 it will not return it because the 'AND ([Steps Taken] <= 20000))' will be treated as its own expression.
Because of this I was going to parse the expressions myself. On the 'Getting familiar with Server-Side API' page:
http://www.telerik.com/help/aspnet-ajax/filter-getting-familiar-with-server-side-api.html
The methods: GetAllExpressionItems, GetSingleExpressionItems, GetSingleExpressionItems, and GetGroupExpressionItems are listed but I can't find them off my control.
I have an expression that combined an 'or' with a 'between'
The resulting SQL is:
([Net Calorie Deficit] < 500 OR ([Steps Taken] >= 10000) AND ([Steps Taken] <= 20000))
I believe there needs to be parentheses around the 2 between conditions.
If I have rows with [Net Calorie Deficit] = 400 and [Steps Taken] = 30000 it will not return it because the 'AND ([Steps Taken] <= 20000))' will be treated as its own expression.
Because of this I was going to parse the expressions myself. On the 'Getting familiar with Server-Side API' page:
http://www.telerik.com/help/aspnet-ajax/filter-getting-familiar-with-server-side-api.html
The methods: GetAllExpressionItems, GetSingleExpressionItems, GetSingleExpressionItems, and GetGroupExpressionItems are listed but I can't find them off my control.