Hi,
I'm using a WebHierarchicalDataGrid which has a DateTime field to be bound. I have enabled sorting and filtering. When I execute the page I'm getting the following error message.
It's working fine if I removed the filtering at all. But I need filtering as well. I tried converting my DateTime field in the stored procedure as "CONVERT( VARCHAR(10), I.InvoiceDate, 101)". Then it's working fine, but the sorting is happening wrongly for this column.
I also tried adding ColumnFilters with the RuleDateNode for the grid as follow, but it still throws the same error.
<ig:Filtering> <ColumnFilters> <ig:ColumnFilter ColumnKey="InvoiceDate"> <ConditionWrapper> <ig:RuleDateNode Rule="Equals"/> </ConditionWrapper> </ig:ColumnFilter> </ColumnFilters></ig:Filtering>
My ultimate goal is to have both Sorting and Filtering for my DateTime field and I'm wondering how Infragistics does not have this. How can I achieve this?
Hello,
I was not able to reproduce the behaviour that you're seeing on your side. I have attached the sample project I used to test this. Please test this project on your side; whether or not it works correctly may help indicate the nature of this issue.
If this sample project is not an accurate demonstration of what you're trying to do, please feel free to modify it and send it back, or send a small sample project of your own if you have one.Please let me know if I can provide any further assistance.
Thanks for the sample provided. It actually made understand that there is nothing specially required to have sorting and filtering for a datetime field. I was setting RuleNumberNode somewhere in my code for the datetime field. It works well after I removed it.
However, I have another issue in setting custom format (MM/dd/yyyy) for the filter (for the column, I use DataFormatString). I want the user to search by MM/dd/yyyy and not by dd-mm-yyyy.
Help me fix this.
You can suggest setting a DateFormatString for the column filter as a new product idea for future versions at <http://ideas.infragistics.com>.
Steps to create your idea:
The benefits of submitting the product idea yourself include:
Additional benefits of the product idea system include:
The product ideas site allows you to track the progress of your ideas at any time, see how many votes it got, read comments from other developers in the community, and see if someone from the product team has additional questions for you.
Meanwhile, what is the fix for my problem???
Currently this is not supported yet, you can suggest it as product idea for future versions.