Question
Bits In Glass
GB
Last activity: 10 Jul 2017 2:57 EDT
DB Datatype to be casted with Pega's Property.
Hi, I have a requirement to filter a property, which has different DataType at DB level and Pega.
A property named PurchaseDate is created with DateTime. so inDB it is saved as TimeStamp.
Presently, this was made as withdrawn and re-saved with Date Type. now in the Application, no errors were found.
but, during reporting when used with a report-definition. i am able to fetch the PurchaseDate as TimeStamp eg: 201707T000000.00 GMT
when i filter using a report browser, the value is taken as date rather than datetime. so it was returning an error:
** An error occured on executing the query for the report definition - Class is mapped to table (removed the table name) in database pegadata , which has column of unsupported type Date : code: <none> SQLState: <none> Message: <none>
I tried using toDay function alias. but no luck.
***Updated by moderator: Lochan to add Categories***
Accepted Solution
Bits In Glass
GB
Hi All,
I found the answer to this. The article is missing a key point of fetching the filtered value when retrieved.
I added the Function alias in the Fetch part of the Column search in Report Definition.
BUPA
AU
Hi Sesha,
The similar issue has been solve in the below link. Pls check and implement accordingly.
https://community.pega.com/support/support-articles/filter-does-not-work-date-type-property
Hope you will get the solution.
Bits In Glass
GB
Hi SwarnenduM ,
I have created a Functionalias as mentioned in the link, but it is not appearing in the Report definition
Pegasystems Inc.
US
Hi Sesha,
As per your screenshot, the name of the Function Alias is given as "sample" and the ID is provided as "ToStringDateOrcl". So you should try to search with "sample" keyword for the function alias and share your observations.
Regards
Mahesh
Bits In Glass
GB
In the Tracer, when i have put DB Query : this is the sql executed.
Bits In Glass
GB
I see that sometimes the SQL inserts are present(when no filters were applied). but when filters are applied the query builds properly but there is no sql inserts generated.
Just for information: this property is retrieved from PEGADATA.
Accepted Solution
Bits In Glass
GB
Hi All,
I found the answer to this. The article is missing a key point of fetching the filtered value when retrieved.
I added the Function alias in the Fetch part of the Column search in Report Definition.