JP CS Data Query - Best Practices

Best Practices

• Start by configuring and testing the Main Table before adding joins.
• Add one database join at a time and verify the returned fields before adding another.
• Use the searchable table and column selectors instead of manually guessing database field names.
• Use table-prefixed fields when multiple tables contain columns with identical names.
• Use the built-in compatibility fields when creating reusable YOOtheme Pro layouts.
• Set a sensible Quantity / Limit instead of retrieving unnecessary database records.
• Use ordering to ensure records are returned consistently.
• Verify database relationships before configuring LEFT JOIN columns.
• Configure JP CS Global Pagination only after the DataQuery source itself is returning the correct records.
• Test complex queries on mobile, tablet, and desktop layouts.
• Always test extension updates on a staging website before deploying them to production.