This is a migrated thread and some comments may be shown as answers.

Grid filtering and date formatting

6 Answers 88 Views
GridView
This is a migrated thread and some comments may be shown as answers.
Lee
Top achievements
Rank 1
Lee asked on 14 Jun 2012, 09:32 PM
I am using RadGridView in a SL app, the latest Telerik update, and when I try to enter a filtering date the box goes read and says,
"One of the identified items was in an invalid format." Clicking the 'Filter' button results in no filtering, only closing the popup and no other help. My date entry was 7/1/2015 so it could be either m/d/yyyy or d/m/yyyy. I also tried 07/01/2015 and 2015/07/01 with the same result. Since the break point is never reached in code to process the number I think I can accurately conclude that the date is not being processed but there is no usable explanation as to the correct format.

6 Answers, 1 is accepted

Sort by
0
Dimitrina
Telerik team
answered on 15 Jun 2012, 06:42 AM
Hello,

You got such an error because the filtering is always performed on raw data values in the data engine. The DataFormatString is only used for presentation purposes only. 


Regards,
Didie
the Telerik team

Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>

0
Lee
Top achievements
Rank 1
answered on 15 Jun 2012, 03:47 PM
Pardon me for seeming obtuse, but your reply makes no sense to me. You said,
" filtering is always performed on raw data values in the data engine". Does that mean that the data I type into the input window is not raw data, or that the data in the data engine is not raw data? Because I am not using DataFormatString in this scenario, my code is not invoked. So what does your reference, " The DataFormatString is only used for presentation purposes only." mean? When I type in my search parameter data is it not finding matches because my underlying data perhaps has been converted to strings instead of being Date types? Are you saying that my underlying data should remain Date type in this case and I should use a converter in the xaml to present the data on screen? And thus the input data will match types? Off the top of my head I don't remember the data type of my underlying data here, but is this what you are not quite saying clearly?
0
Lee
Top achievements
Rank 1
answered on 20 Jun 2012, 04:37 PM
So is this the quality of help at Telerik? No response after cryptic response that makes no sense?
0
Dimitrina
Telerik team
answered on 25 Jun 2012, 01:40 PM
Hello,

I would recommend you to check our online documentation where all specifics related to filtering are described. As to my previous reply, you could as well check this help article.

On I side note, please be advised that the Telerik Community Forum is to provide a free form of peer-to-peer communication between registered Telerik users. The forums are not moderated and should not be considered support substitutes. 

Kind regards,
Didie
the Telerik team

Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>

0
Lee
Top achievements
Rank 1
answered on 25 Jun 2012, 03:11 PM
My apologies, I had forgotten this forum was not supported by Telerik and my comments were out of order. Yours were especially diplomatic by comparison.

That said, the breaks caused by the changes in Telerik libraries are not fully documented as you suggest. Certainly not 'all specifics' as you say, are not covered on the matter of filtering. There is a supply of documentation that addresses many of the issues and that has helped to a great degree. But just my asking suggests that all is not covered.

Lee
0
Dimitrina
Telerik team
answered on 26 Jun 2012, 05:33 AM
Hello Lee,

 Thank you for your feedback. Indeed, you are right that our documentation is to be improved constantly. We will update the article I have pointed to with more descriptive information.

We will be grateful if you could give us some more specifics on what should be changed for the filtering documentation. We will gladly extend the texts so that they are more helpful.
 

Greetings,
Didie
the Telerik team

Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>

Tags
GridView
Asked by
Lee
Top achievements
Rank 1
Answers by
Dimitrina
Telerik team
Lee
Top achievements
Rank 1
Share this question
or