Filtering when custom value editor for field defined

315

Arkadiusz posted over 12 years ago

Hi,

I have an issue which occurs when I have custom value editor defined for a field and I would also like to filter on that field. After entering a value into filtering record for that field and hitting Enter, I'm getting a message box with "Value could not be converted to..." text.

I'm attaching a sample project which presents the issue. Change filter operator for the second column to Equals, enter some value and hit Enter. You actually need to enter filtering value 2 times (first value simply disappears, which I guess is some other issue; it does not occur in my real project, only in this sample one).

I know XamDataGrid by default uses XamComboEditor in filtering record. I thought I could use my custom editor for that, but I would not like to loose functionality of choosing (Custom) filter from the drop down. Any ideas how to solve this?

FilteringIssueDemo.zip

14517

Offline Valerie S posted over 7 years ago in reply to K

Hello,
To remedy this issue, a new property, FilterEvaluator, was added to the FieldSettings in order to allow the developer to provide custom logic to enable filtering. In order to use this property you would create a filterEvaluator which implements the IFilterEvaluator interface then set the FilterEvaluator property to this class. For example in the sample attached in the original post, you could add a FilterEvaluator such as
public class AddressFilterEvaluator : IFilterEvaluator
    {

        private static object Convert(object value)
        {

            Address address = value as Address;

            if (null != address)

                return address.Street;

            return value;

        }

        public bool? Evaluate(ComparisonOperator comparisonOperator, ref object lhs, ref object rhs, ConditionEvaluationContext context)
        {

            lhs = Convert(lhs);

            rhs = Convert(rhs);

            // Return null to let the default built-in logic perform the evaluation

            // based on the above converted values.

            //

            return null;

        }

And then set it to be used on the specified field:
field = new Field
            {
                Label = "Address Street",
                Name = "Address",
                DataType = typeof(Address),
                Settings = new FieldSettings
                {
                    AllowRecordFiltering = true,
                    EditorType = typeof(AddressEditor),
                    FilterEvaluator = new AddressFilterEvaluator()
                }
            };

Please let me know if that resolves you issue.
Sincerely,
Valerie
Cancel
Reply

Cancel
20

K posted over 7 years ago in reply to Valerie S

Hello,

What was the solution? I would like to modify the message to say something more descriptive. How can I modify the error message?

Thanks!
Cancel
Reply

Cancel
14517

Offline Valerie S posted over 12 years ago in reply to Valerie S

Hello,

The issue converting the text input into the address was looged as development issue

100185: Entering text in filter cell of column with custom Value Editor gives error Invalid Value: Value could not be converter to <object type>

This issue has been fixed in teh latest service release.

Sincerely,
Valerie
Developer Support Engineer
Infragistics
www.infragistics.com/support
Cancel
Reply

Cancel
14517

Offline Valerie S posted over 12 years ago

Hello,

In your sample you can add a ValueToTextConverter in the Value Editor class to translate the values for the drop down list and add a FilterComparer to enable filtering from values selected from the list.

I am going to have development look into the issue converting the text input into the address and will create a private case to notify you of updates to this issue.

Sincerely,
Valerie
Developer Support Engineer
Infragistics
www.infragistics.com/support
Cancel
Reply

Cancel