[Progress Communities] [Progress OpenEdge ABL] Forum Post: Widget FilterExpression For Custom Choices Field (MVC) v 12.2

[laura@refactoredmedia.com]

I am trying to filter blog posts by a custom field called ArticleType. This custom field is a choice field in the admin. In the Blog Post widgget Advanced > Model > FilterExpression I entered ArticleType = Article and got the error "No 'Article' member found in type 'Telerik.Sitefinity.Blogs.Model.BlogPost'" I also tried ArticleType.PersistedValue.ToString() = "Article" and got the error Message : An exception occurred during the execution of 'Extent ().Where(b => (b.ApplicationName == value(Telerik.Sitefinity.Modules.Blogs.Data.OpenAccessBlogProvider+<>c__DisplayClass8_0).appName)).Where(item => ((((item.FieldValue("ArticleType").PersistedValue == "Video") AndAlso (item.Parent.Id == 2f77bdaf-7a84-46cd-8e8e-a0bd7cb2451f)) AndAlso (item.Visible == True)) AndAlso (Convert(item.Status) == 2))).Count()'. Failure: Database mapped field uses different type 'System.String'. Parameter name: methodCallExpression Actual value was item.FieldValue("ArticleType"). Inner Exception --------------- Type : System.ArgumentOutOfRangeException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 Message : Database mapped field uses different type 'System.String'. Parameter name: methodCallExpression Actual value was item.FieldValue("ArticleType"). Source : Telerik.OpenAccess.35.Extensions Help link : ActualValue : item.FieldValue("ArticleType") What am I doing wrong here?

Continue reading...