Hey guys

info:

LLBLGen Pro version: 2.5 Final

Runtime: 2.5.7.1214

Template group: Adapter 2.0

Db: SqlServer 2005

I have a generic Filter method that filters an EntityCollection on a specified searchField. This is the method:

private static EntityCollectionBase2<T> Filter<T>(FilterSettings filterSettings, EntityCollectionBase2<T> collection, EntityField2 searchField, IPredicateExpression customLogicalContentTypeFilter)
            where T : EntityBase2, IEntity2
        {
            if (collection == null || collection.Count <= 0)
                return collection;

            EntityView2<T> entityView = new EntityView2<T>(collection);
            IPredicateExpression filterBucket = new PredicateExpression();

            //Check if there is a need for a logicalcontentfilter
            if (filterSettings.LogicalContentTypes != LogicalContentTypes.Unknown)
            {
                //use customfilter if given
                if (customLogicalContentTypeFilter != null)
                    filterBucket.AddWithAnd(customLogicalContentTypeFilter);
                else
                {
                    EntityField2 logicalContentField = null;
                    //User set the logicalcontenttype, lets see if there is a Field in the collection submitted
                    foreach (EntityField2 field in collection[0].Fields)
                    {
                        if (field.DataType == typeof(LogicalContentTypes))
                        {
                            logicalContentField = field;
                            break;
                        }
                    }
                    if (logicalContentField.CurrentValue != null)
                        AddLogicalContentTypeFilter(filterSettings, filterBucket, logicalContentField);
                }
            }

            if (filterSettings.SearchString != string.Empty)
                filterBucket.AddWithAnd(searchField % (GenerateSearchExpression(filterSettings)));

            entityView.Filter = filterBucket;
            return entityView.ToEntityCollection();
        }

You can see that my searchField must be an EntityField2 object. The problem is that I can't retrieve this type with a custom property. I can only fetch these custom properties as a string.

Is there a way to convert it to an EntityField2, or create a new field of this type?

Is this what you are looking for?

IPredicateExpression filter = new PredicateExpression();
filter.Add(new EntityProperty("IsDirty") == true);

Nope. And I really can't see what this has to do with my problem.

I have a custom property, and want to feed it to my search function as a EntityField2

The problem is with the requirement that it has to be an EntityField2. If you change it to IEntityFieldCore, you can pass in an EntityProperty as well, which makes it possible to filter on a custom property in an entity.

hmm. I get an error **Operator '%' cannot be applied to operands of type 'SD.LLBLGen.Pro.ORMSupportClasses.IEntityFieldCore' and 'string' **

This is the code that generates the error.

filterBucket.AddWithAnd(searchField % searchExpression);

I'd like to add that I did not write this method myself

Please try to create a FieldLikePredicate manually, instead of using the natural language form ( % ).

eg:

filterBucket.AddWithAnd(new FieldLikePredicate(searchField, null, searchExpression));

Ok tnx guys. That worked!