houseprice-object-sync

What problem does it solve?

This Skill documents and clarifies the end-to-end HousePrice object synchronization workflows so engineers can confidently develop, debug, and operate the background jobs that move data from MSSQL to Elasticsearch and the C-side display layer.

Core Features & Use Cases

• Job inventory and schedules: Lists all recurring and manual Hangfire jobs (AdaptedWebCaseJob, BuyBusinessCaseViewDataJob, AIPictureJob, ClickCount tasks, etc.) and their typical triggers and timings.
• Data flow mapping: Describes how AdaptedWebCase and related tables are assembled, how SP15 and other stored procedures participate in grouping, and how documents are written into the buy_business_case ES index.
• Operational rules and error handling: Explains expiration vs advertisement flows, orphan image cleanup, retry and batching strategies, queueing patterns, and common anomalous states and fixes.
• Real-world use: Useful for Hangfire job development, troubleshooting MSSQL→ES sync issues, validating ES mappings, implementing AI image pipelines, and reproducing production anomalies.

Quick Start

Ask for a concise runbook: Describe how buy_business_case documents are constructed from AdaptedWebCase tables, list the jobs that touch those records, and outline the checkpoints to verify a successful MSSQL-to-ES sync.