Hi,

        I have created a multivalue control which has a bunch of values. When i try to save a record which has more than 255 characters it threw an error saying that length of the field value has exceeded 255 characters. After doing some research i found out that the column defined in the database has a size of 256. Is there anyway we can control this? This is kind of critical for our implementation. If we can't control this is there any other control that can provide the same functionality.

Maybe you can use a PlainText field instead?

http://msdn.microsoft.com/en-us/library/ms194980.aspx

I can't use plaintext field as it doesn't accept suggestedvalues list. Is there any other way of updating the field length and also by passing the field validation.

You can modify the control such that you can specify a PlainText field for the field itself and a different field for the allowed values. you can specify custom attributes in the control element in the WIT defintion XML. you need to modify this custom control to read the custom attributes and use the alternate field for allowed values. Hope this is clear. let me know if you have more questions.

I tried that too but the problem is you cant query a plaintext field.

its not as nice to query with but you can do alot with contains and does not contains. if you are looking for only one field is chekced use contains the specific tag and does not contain ; so you know its a single value...etc.

I have some similar kind of issue. I am using multivalue control having list of users. The purpose of this field in our project is to notify the selected users whenever a workitem is changed. In alert editor I cannot apply "contains" filter. However it has changes, change to and changes from filter options which are not workable in my case. Please guide me on how to achieve this behavior using multivalue control.

The basic requirement is to send email to all selected users whenever a workitem is changed.