Diagnose missing CRM object visibility by validating EAV data and pivot views.
npx skills add https://github.com/aspectrr/denchclaw-workspace --skill crm-debug
Please help me install this Agent Skill. Skill: crm-debug Source: https://github.com/aspectrr/denchclaw-workspace/tree/main/skills/crm-debug Command: npx skills add https://github.com/aspectrr/denchclaw-workspace --skill crm-debug
Debugging CRM objects not showing entries despite data existing in the database.
Verify the CRM object's data in objects and entries, check for a missing v_<object_name> Pivot view, create the view if missing, and re-query the API to confirm entries appear.
High-intent search queries and answers about installing and using this skill.
CRM entries may not show because the EAV-based object is missing its required pivot view, commonly named v_{object_name}, which prevents the system from reading the data for display.
Diagnose missing pivot views by verifying object data in the database, checking for the absence of the v_<object_name> view, and querying the API to confirm if entries return a non-zero totalCount.
Fix CRM data visibility by recreating the missing pivot view for the specific object and then re-running the API query to confirm that entries successfully appear with a non-zero totalCount.
EAV-based CRM objects rely on pivot views to flatten entity-attribute-value data into a queryable structure, allowing APIs to retrieve entries and return a non-zero totalCount for UI display.
Verify CRM object entries by checking the database for existing data, creating the missing pivot view if absent, and re-querying the API to validate that entries appear with a non-zero totalCount.
Yes, this debugging approach applies to any EAV-based CRM system that relies on v_ views, guiding engineers to validate database entries, repair missing pivot views, and confirm API visibility.
himes19Create CRM schemas, pivot views, and CRUD operations in DuckDB.
putrawitamaGenerate JSON-based CRM report configurations with SQL and v_object pivot views.
aspectrrAutomate CRM object creation from SQL to filesystem with verification.
InchooAutomate creation, manipulation, and querying of EAV attributes in Magento 2.
