Intersoft Community - WebGrid Enterprise - Filtering in WebValueList column

Filtering in WebValueList column

Glayaar — Mon, 02 Nov 2009 23:01:40 GMT

In our environment the sample return no row and there is no such error as you described. Could you inform us the WebGrid build and WebUI Framework you are using in order to analyze this issue further.

Filtering in WebValueList column

Michael — Tue, 13 Oct 2009 01:53:18 GMT

Hi Glenn

I have still problem with AutoFilterSuggestion. Following code is from sample AutomaticFilterSuggestion.aspx. I have added property DataFormatString="dd.MM.yyyy HH:mm:ss" on columns BirthDate and HireDate. Please check this. I get Errormessages like attached pictures.

    <ISWebGrid:WebGrid ID="WebGrid1" runat="server" Height="300px" UseDefaultStyle="True"
        Width="100%" DataSourceID="AccessDataSource1">
        <RootTable DataKeyField="EmployeeID">
            <Columns>
                <ISWebGrid:WebGridColumn Caption="LastName" DataMember="LastName" Name="LastName"
                    Width="100px">
                </ISWebGrid:WebGridColumn>
                <ISWebGrid:WebGridColumn Caption="FirstName" DataMember="FirstName" Name="FirstName"
                    Width="100px">
                </ISWebGrid:WebGridColumn>
                <ISWebGrid:WebGridColumn Caption="Title" DataMember="Title" Name="Title" Width="100px">
                </ISWebGrid:WebGridColumn>
                <ISWebGrid:WebGridColumn Caption="TitleOfCourtesy" DataMember="TitleOfCourtesy" Name="TitleOfCourtesy"
                    Width="100px">
                </ISWebGrid:WebGridColumn>
                <ISWebGrid:WebGridColumn Caption="BirthDate" DataMember="BirthDate" DataType="System.DateTime"
                    Name="BirthDate" Width="200px" DataFormatString="dd.MM.yyyy HH:mm:ss">
                </ISWebGrid:WebGridColumn>
                <ISWebGrid:WebGridColumn Caption="HireDate" DataMember="HireDate" DataType="System.DateTime"
                    Name="HireDate" Width="200px" DataFormatString="dd.MM.yyyy HH:mm:ss">
                </ISWebGrid:WebGridColumn>
            </Columns>
        </RootTable>
        <LayoutSettings AutoFilterSuggestion="True">
        </LayoutSettings>
    </ISWebGrid:WebGrid>

Filtering in WebValueList column

Glayaar — Thu, 08 Oct 2009 03:54:53 GMT

You use sort the item alphabethically on EditType dropdownlist column if you are using WebValueList, just set the property UseValueListForSorting to true to sort it by tthe text value.

AutoFilterSuggestion will work with any dateformat if the column datatype is DateTime and the formatting is done using DataFormatString property of the WebGridColumn. For example here is the snippet to format column RequiredDate to displayed as "dd.MM.yyyy hh:mm:ss":

<ISWebGrid:WebGridColumn Caption="RequiredDate" DataMember="RequiredDate" DataType="System.DateTime"
    EditType="CalendarCombo" Name="RequiredDate" Width="100px" DataFormatString="dd.MM.yyyy hh:mm:ss">
</ISWebGrid:WebGridColumn>

Please execute the columnset creation code once. In the sample you attached, the columnset will be created each time PrepareDataBinding is triggered, if you only execute the code once (while page is not PostBack) the page will display without any issue.

You could try using AdvancedFilterExpression by disabling AutomaticFilter in the RootTable and handling the WebGrid filtering yourself in order to achieve filtering more than one item. Attached is a similar sample of filtering more than one City or Country

Filtering in WebValueList column

Michael — Tue, 06 Oct 2009 05:26:26 GMT

Hi Glenn

Thank you for advise.

It's possible to sort Items alphabetically if I use Dropdownlist?

I use following Dateformat "dd.MM.yyyy hh:mm:ss". AutoFilterSuggestion for Date (e.g. Today, Yesterday, ... -> in Contextmenu) doesn't work. I have set LanguageMode to UseCulture:

            e.Layout.TextSettings.Language = LanguageMode.UseCulture;
            e.Layout.TextSettings.UseWebResources = false;
            e.Layout.TextSettings.LocalizationFolder = @"~/Localization/";

If I create Columnset programmatically the row on the right side overlaps when a filter is active (see FilterOverlapColumnset.jpg). But this is only visible when there is no scroll bar is present. I have also attached a sample with Northwind Database. You should reproduce the scenario with following steps:

Change ConnectionString and run sample
Type Filtertext "Maria" in ContactName Column
Apply all Filters

WebCombo with ValueList has following Items:

ProductA added
ProductA deleted
ProductA modifided

Now I want to filter by ProductA.

Is there a way to choose more then one Item (like sample Multiple Values in WebValueList) or set Filtertext to e.g. ProductA*?

Best regards

Michael

Filtering in WebValueList column

Glayaar — Mon, 05 Oct 2009 05:27:34 GMT

Our common scenario for WebValueList column is using WebCombo edit type. For example, our EditorTypes.aspx page in WebGrid sample which WebValueList in SupplierID and CategoryID column. Please enable filtering by setting the AllowFilter property to true.

We could also use CustomFiltering which already explained in the WebGrid Documentaion under the article "CustomFilter Event". However, using this approach you will need to have the DataText WebValueList as a hidden column.

Filtering in WebValueList column

Michael — Mon, 05 Oct 2009 02:57:13 GMT

I can not find any records when I type filtertext in WebValueList column.

It's possible to filtering WebValueList columns?

Best regards

Michael