Question
Accenture Solutions Pvt Ltd
IN
Last activity: 24 Jul 2018 0:01 EDT
Issues with Listview
Hi Team,
I have an issue while displaying case data through list view. All the columns fetched from case data table are being displayed except one column, where i can see data saved across that property in data base table but not getting displayed when fetched using list view or report definition. I have even checked the mapping of property to table column and it is fine. Tried using class joins but only that column fails to get data in list view. Please help me in finding the solution.
***Updated by moderator: Lochan to update platform capability***
Accenture Solutions Pvt Ltd
IN
Hi Team,
Now the issue is different, the property value is not getting saved in data base column. The property is optimised and column property mapping is also fine, but unable to save the value. Please help us what could be the issue.
Vodafone
IN
Hi Jyothi,
Can you run the report definition individually and check the data is updated and fetched from DB?? update any value and save. validate are there any exceptions in Pega rules log or javascript console logs.
if there are any exceptions/validations fired value will not be submitted to the database.
Accenture Solutions Pvt Ltd
IN
Hi Naveen,
Yeah I have tried fetching data from report definition and the issue is same, not displaying values for that property.
Vodafone
IN
Did you optimized the properties?? The properties you are fetching from the blob will not be working. you need to optimize the property. In app explorer right click on the property >> last option you will find optimizing.
Enable DBQuery in tracer, Check the SQL Query and run the query in DB with proper inputs replacing the "??". Check the property column is available in the table or not.
Re-try the scenario.
Accenture Solutions Pvt Ltd
IN
Yeah Naveen, the property is optimised and there is a column created and mapped to my property in external mapping tab. The issue here is, the property value is not getting saved to that mapped column. I will try the tracing method.
CollabPartnerz
IN
Hi,
I think report is fetching data from the blob.
Could you try to drop that column and again recreate in same table and check for new cases/Applications.