Table Issue: ignore empty constraints and constraints conflict

Hi All, thanks in advance.

Goal

  • Display items filtered to a constraint in a table before a search happens, but allow further filtering once a search is executed

Details

  • There are two data types: a schedule and events. Each event has a parent schedule.
  • The table is a list of events
  • The table has two constraints.
    1. The first is a search on any field based on a query string from the page URL.
    2. The second is filtering events to a specific schedule ID
  • Navigation to this page is when someone clicks on the “see events” of a specific schedule. When the page loads, it has the schedule ID in the URL parameter BUT no query yet.

Challenge

  • If I set “ignore empty constraints” to off, nothing appears in the table because there is no query parameter yet for the search. And I can’t seem to find a wildcard value.
  • If I set “ignore empty constraints” to on, everything appears even if it isn’t from the original schedule.

Question
What’s the best way to resolve this? Thank you!

This topic was automatically closed after 70 days. New replies are no longer allowed.