Discussion
Filter issue in Repeating Grid
Hello,
We have a repeating grid loads on Report Definition in Work Class. Filter option on Date fields has an issue. We are getting below error.
An error occured on executing the query for the report definition - Class is mapped to table in database , which has column of unsupported type Date: code: <none> SQLState: <none> Message: <none>
It clearly says the column data type(Date Time) in the work table and the property data type(Date) in the work class are different.
We can change the type of property to date time (which works fine), but this property has been referred through out the application which impacts the existing functionlaities.
Is there any way we can make the filter works on these date fields? Please advise.
Thanks,
Veera
Hello Veera,
I would first determine which data type your application requires and create one property for purposes of reuse, consistency and reducing maintenance overhead although this may take a little more work in the short run. Although this would be my preference, another idea is try to create a new property for the report of type Date Time or you can make this new property that you reference in the report as a target property of a Declare Expression that contains the date property used by the application and add the time with a second property in the expression.
Regards,
The PDN Forum Support Team,
Lu