This is a migrated thread and some comments may be shown as answers.

[Solved] Filtering with ORM

1 Answer 104 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
bharat veer
Top achievements
Rank 1
bharat veer asked on 15 Mar 2011, 11:04 AM
I am new to ORM and RadControl.
RadFilter is being used for filtering functionality. And for data retrieving ORM is being used.
when data is shown in RadGrid. and if there is a column that does not have any "data".
Means there is a city column but no city is being populated in RadGrid. And this column is filtered with-- some value "dfs"
such error occurs.
line 1:82: Unknown type for "mailAddress"; Are you missing a FieldAlias attribute?; String literals must be 'quoted'.
Original Query: DEFINE EXTENT xt FOR iTracker.Data.Orm.Customer; SELECT * FROM xt AS this WHERE (mailAddress.contact.cityLIKE "*dfs*") ORDER BY this.customerName ASC


and this error is occured on the RadFilter method..FireApplyCommand();

please provide me solution.

1 Answer, 1 is accepted

Sort by
0
Damyan Bogoev
Telerik team
answered on 18 Mar 2011, 09:20 AM
Hi bharat veer,

Could you please verify that the properties used in the query expression are marked with a FieldAlias attribute? The FieldAlias attribute marks the property as an alias for a given field. This enables the use of public properties in the expressions. Whenever the query parser encounters a property in a query, it uses the corresponding field that has been specified in the FieldAlias attribute. The attribute is automatically generated in reverse mapping scenarios but you should write it by hand if you are using the forward mapping approach.
Hope that helps.

Best wishes,
Damyan Bogoev
the Telerik team
Tags
General Discussions
Asked by
bharat veer
Top achievements
Rank 1
Answers by
Damyan Bogoev
Telerik team
Share this question
or