22/09/2025 - Flight assist major release

🔝 Ordering and Limiting for Customer Queries (to facilitate 'best customer')

• Ability to order customer query results by metrics (visit_count, purchase_count, accumulative_spend, booking_count, booking_covers, stay_total_guests, reward_code_count).

• Results can be limited and paginated.

• Human-friendly pseudo-SQL summaries with min/max/avg/total for the sorting metric.

🏨 Extended “Stays” Support

• Customer queries now support new “stay” filters for overnight bookings, including location, booking status, room type, booker/guest distinction, used voucher, pets, and date windows.

• “Stays” are handled as a distinct dataset alongside visits, with dual querying if enabled.

🏆 Reward (Unique Code) Filtering

• Filter customers by reward/unique code: redeemed status, validity, location, time windows.

• New pseudo templates and API for listing reward campaigns.

🗳️ Groups/Folders Filtering

• Filter customers by group/folder membership, match mode (any/all/none), added between dates, include/exclude mode.

• New pseudo templates and API for listing groups/folders.

🧾 get_forms Functionality (NEW)

• New get_forms API function enables listing and filtering forms (e.g., feedback or data collection forms) with parameters:

• limit (pagination)

• location_id (filter by location)

• active (active/inactive)

• name_like (search by form name)

• created_between (date range)

• form_type_id (filter by form type)

• is_zonal_form (boolean)

• include_deleted (boolean)

• order_by_created_at_desc (sort order)

• Results are to be presented in a table format by default.

🤖 Other Improvements & Additions

• Pseudo-SQL/humanisation updates for new keys and clearer summaries.

• Improved date/time phrase handling.

• Larger chat log storage (LONGTEXT migration).

• Results for all list-type queries (groups, forms, reward campaigns) must be shown in tables.

In summary:

This release adds advanced segmentation/ranking features, rich “stay” and reward filters, group and form listing/filtering, and makes list data more user-friendly with tables. It also improves pseudo-SQL summaries and increases system scalability.

🧑🏻‍💻 Jules