JetEngine Query Builder Integration
Overview
Version 2.4.3 introduces a dedicated JetEngine query type — WC Order HPOS Query — that allows you to build Elementor and JetEngine Listing Grids driven by WooCommerce orders stored in the HPOS tables. The query type ships with smart filters for payment methods, customer context, and refined date handling so you can create order dashboards, customer activity feeds, or reporting widgets without custom SQL.
Key Features
- Payment Method Filtering — select one or multiple gateways directly in the builder.
- Custom Context Control — target a specific customer ID or rely on the
%current_user_id%macro. - Improved Date Inputs — “Date After” and “Date Before” support relative macros and handle inclusive ranges out of the box.
- JetEngine Ready — pair the query with Elementor templates, Listing Grids, and our new order dynamic tags for rich order-based layouts.
Query Settings
| Setting | Description |
|---|---|
| Custom Context | Leave blank for all orders, set a numeric user ID, or use %current_user_id% for logged-in customer listings. |
| Statuses | Multi-select field mirroring native WooCommerce order statuses. |
| Payment Methods | New multi-select that lists registered WooCommerce gateways. |
| Include Products | Comma-separated product IDs. Returns orders that contain at least one of these products. |
| Exclude Products | Comma-separated product IDs. Excludes orders that contain any of these products. |
| Enable Pagination / Items Per Page | Standard JetEngine pagination controls. |
| Offset | Skip the first X results (automatically disables pagination). |
| Date After / Date Before | Inclusive range filters with macro support (%current_date%, +7 days, etc.). |
Tip: When combining “Date Before” with “Date After”, the query automatically converts the values to GMT timestamps for accurate HPOS lookups.
Note: For product filtering, matching uses “any of” semantics — an order qualifies if it contains at least one of the specified product IDs. It does not require all IDs to be present in the same order.
Recommended Pairings
- Ordered Items, Order Payment Method, Order Status — the new dynamic tags render order metadata inside Listing Grid templates.
- JetEngine Dynamic Visibility — hide or show order cards based on lifecycle events (payment method, status, customer role).
- Elementor Theme Conditions — display order-centric layout parts for administrators or shop managers only.
Getting Started
- Open JetEngine > Query Builder and create a new query of type WC Order HPOS.
- Configure the filters (context, payments, statuses, date range).
- Assign the query to a Listing Grid and design the item template with the Woo Order dynamic tags.
- Drop the Listing Grid into your Elementor page and enjoy the live order feed.
Need inspiration? Check the changelog for v2.4.3 to see everything that shipped alongside the query type, including the complementary dynamic tags.