Grid Issues

[jcontreras]

Hi,

I appear to be having several Grid Issues:

1. Dates cannot be formatted correctly
2. Filtering works for some values (not all values)
3. The detail editing returns an error message - elements not supported

<ext:CommandColumn runat="server" Width="35">
                        <Commands>
                            <ext:GridCommand Icon="NoteEdit" CommandName="Edit">
                                <ToolTip Text="Edit" />
                            </ext:GridCommand>
                        </Commands>
                        <Listeners>
                            <Command Handler="CompanyX.edit(recordIndex);" />
                        </Listeners>   
                    </ext:CommandColumn>

Here is the HTML Code
<ext:GridPanel ID="grdTickets" runat="server" Title="Tickets">
                <Store>
                    <ext:Store ID="Store1" runat="server" DataSourceID="ODSTickets" PageSize="20">
                        <Model>
                            <ext:Model runat="server" IDProperty="TicketId">
                                <Fields>
                                    <ext:ModelField Name="Status" />
                                    <ext:ModelField Name="IssueType" />
                                    <ext:ModelField Name="OldRecordNumber" />
                                    <ext:ModelField Name="Product" />
                                    <ext:ModelField Name="OriginalDate" Type="Date" />
                                    <ext:ModelField Name="ClosedDate" Type="Date" />
                                    <ext:ModelField Name="SubmittedBy" />
                                    <ext:ModelField Name="Department" />
                                    <ext:ModelField Name="Priority" />
                                </Fields>
                            </ext:Model>
                        </Model>
                    </ext:Store>
                </Store>
                <ColumnModel runat="server">
                    <Columns>
                        <ext:Column runat="server" ID="Status" Text="Status" Width="75" DataIndex="Status" />
                        <ext:Column runat="server" ID="IssueType" Text="Issue Type" DataIndex="IssueType" Width="100" />
                        <ext:Column runat="server" ID="OldRecordNumber" Text="RecNo" DataIndex="OldRecordNumber" Width="100" />
                        <ext:Column runat="server" ID="Product" Text="Product" DataIndex="Product" Width="100" />
                        <ext:Column runat="server" ID="OriginalDate" Text="Entry Date" DataIndex="OriginalDate" Width="100" />
                        <ext:Column runat="server" ID="ClosedDate" Text="Closed Date" DataIndex="ClosedDate" Width="100" />
                        <ext:Column runat="server" ID="SubmittedBy" Text="Submitted By" DataIndex="SubmittedBy" Width="100" />
                        <ext:Column runat="server" ID="Department" Text="Department" DataIndex="Department" Width="100" />
                        <ext:Column runat="server" ID="Priority" Text="Priority" DataIndex="Priority" Width="100" />
                    </Columns>
                    <ext:CommandColumn runat="server" Width="35">
                        <Commands>
                            <ext:GridCommand Icon="NoteEdit" CommandName="Edit">
                                <ToolTip Text="Edit" />
                            </ext:GridCommand>
                        </Commands>
                        <Listeners>
                            <Command Handler="CompanyX.edit(recordIndex);" />
                        </Listeners>   
                    </ext:CommandColumn>
                </ColumnModel>
                <Features>
                    <ext:GridFilters runat="server" ID="grdFilters" Local="true">
                        <Filters>
                            <ext:ListFilter DataIndex="Status" Options="Active,Closed" />
                            <ext:ListFilter DataIndex="IssueType" Options="Bug,Enhancement,Product Support,Wish Item" />
                            <ext:ListFilter DataIndex="Product" Options="Citrix,ECall Report,MSD Online,OIS Paperless,OneMed,OneTrack,Other,OtherProduct,Prophet 21" />
                            <ext:StringFilter DataIndex="SubmittedBy" />
                            <ext:DateFilter DataIndex="OriginalDate" />
                            <ext:DateFilter DataIndex="ClosedDate" />
                            <ext:ListFilter DataIndex="Department" Options="Billing,BIO,CSR,Finance,IT,Marketing,OIS,Operations,PAC,PHD,Purchasing,Sales,Supply Chain,Transportation,Unassigned" />
                            <ext:ListFilter DataIndex="Priority" Options="Emergency,Normal,Urgent" />
                        </Filters>
                    </ext:GridFilters>
                </Features>               
                <TopBar>
                    <ext:Toolbar ID="Toolbar1" runat="server">
                        <Items>
                            <ext:ToolbarFill ID="ToolbarFill1" runat="server" />
                            <ext:Button ID="Button1" runat="server" Text="To XML" Icon="PageCode">
                                <Listeners>
                                    <Click Handler="exportData('xml');" />
                                </Listeners>
                            </ext:Button>

                            <ext:Button ID="Button2" runat="server" Text="To Excel" Icon="PageExcel">
                                <Listeners>
                                    <Click Handler="exportData('xls');" />
                                </Listeners>
                            </ext:Button>

                            <ext:Button ID="Button3" runat="server" Text="To CSV" Icon="PageAttach">
                                <Listeners>
                                    <Click Handler="exportData('csv');" />
                                </Listeners>
                            </ext:Button>
                        </Items>
                    </ext:Toolbar>
                </TopBar>
                <BottomBar>
                    <ext:PagingToolbar runat="server" DisplayInfo="true" />
                </BottomBar>
            </ext:GridPanel>

[jcontreras]

Hi,

How can I open another page by clicking an icon on the grid. This is straight-forward in the ASP.NET grid control. It's confusing on this control.

[Vladimir]

This is straight-forward in the ASP.NET grid control.

How do you do it in the ASP.NET grid control?

[jcontreras]

Hi,

I have something like this:

<asp:HyperLinkField DataNavigateUrlFields="col1,col2" DataNavigateUrlFormatString="gotopage.aspx?p1={0}& p2={1}" Text="Print" />

[Vladimir]

In the Command handler you can use

<Command Handler="window.location = 'myUrl';" />

[jcontreras]

How do I pass the id or other values in the command handler:

 <ext:CommandColumn runat="server" Width="25">
                    <Commands>
                        <ext:GridCommand Icon="NoteEdit" CommandName="Edit">                            
                            <ToolTip Text="Click On Icon To View Detail Page" />
                        </ext:GridCommand>
                    </Commands>
                    <Listeners>
                        <Command Handler="window.location = 'ticketadd.aspx?id={0}';" />
                    </Listeners>
                </ext:CommandColumn>

[Vladimir]

Do you mean record id? If yes

 <Command Handler="window.location = 'ticketadd.aspx?id=' + record.getId();" />

[jcontreras]

1. Date Formatting is not working. In the DB the datatype is datetime I pass that value in my entity as a datetime. In the grid I have this:
For OriginalDate the format is not MM-dd-yyyy
2. Filtering isn't working either. I have put a hard-coded Active,Closed in the

<ext:ListFilter DataIndex="Status" Options="Active,Closed" />

which is a string and that's not working.

<ext:Store ID="Store1" runat="server" DataSourceID="ODSTickets" PageSize="20">
                <Model>
                    <ext:Model runat="server" IDProperty="TicketId">
                        <Fields>
                            <ext:ModelField Name="Status" />
                            <ext:ModelField Name="IssueType" />
                            <ext:ModelField Name="OldRecordNumber" />
                            <ext:ModelField Name="Product" />
                            <ext:ModelField Name="OriginalDate" Type="Date"/>
                            <ext:ModelField Name="ClosedDate" Type="Date" />
                            <ext:ModelField Name="SubmittedBy" />
                            <ext:ModelField Name="Department" />
                            <ext:ModelField Name="Priority" />
                        </Fields>
                    </ext:Model>
                </Model>
            </ext:Store>
        </Store>
        <ColumnModel runat="server">
            <Columns>
                <ext:Column runat="server" ID="Status" Text="Status" Width="75" DataIndex="Status" />
                <ext:Column runat="server" ID="IssueType" Text="Issue Type" DataIndex="IssueType" Width="100" />
                <ext:Column runat="server" ID="OldRecordNumber" Text="RecNo" DataIndex="OldRecordNumber" Width="100" />
                <ext:Column runat="server" ID="Product" Text="Product" DataIndex="Product" Width="100" />
                <ext:Column runat="server" ID="OriginalDate" Text="Entry Date" DataIndex="OriginalDate" Width="100" Format="MM-dd-yyyy" />

Thanks,

[Vladimir]

How OriginalDate and Status are rendered?
Can you post generated script?

[jcontreras]

Hi,

That worked:

 <Listeners>
                        <Command Handler="window.location = 'ticketadd.aspx?Ticketid=' + record.getId();" />
                    </Listeners>

Thanks,