New Columns Required on property_sales_valuations

[SairamKDXFT]

Hi Team,

We're encountering an issue when generating the Valuations report due to missing data in the property_sales_valuations table.

We need an additional column, Valuation Time, which can be obtained from the Appointments table. However, the property_sales_valuations.Appointment_Id field is null for cancelled appointments, preventing a direct comparison between the tables.

Is there a way to retrieve the Valuation Time for cancelled appointments using a database query? This would allow us to accurately compare data and generate the complete Valuations report.

[plittlewood-rpt]

Hi @SairamKDXFT can you give some examples of rows where you're running into this problem (property ids are fine). Omitting cancelled appointments is intentional, but what you're saying would suggest that the properties concerned don't have any other, non-cancelled valuation appointments. Some examples will help to confirm if there is a bug or not in that data transformation logic. Thanks

[github-actions[bot]]

We have recently requested additional information relating to the issue you have raised. Please can you take the time to review this ticket and where applicable, provide the information requested. For more information on our processes, please click here

[plittlewood-rpt]

Hi @SairamKDXFT are you able to provide some examples of problematic records if this is still something you'd like us to look into? Thanks