As the platform,

I need to retrieve Country and City records based on search keywords and selected filters,

So that administrators can efficiently locate and manage destination data.

---

Business Rules¶

Search shall only return matching Country or City records.

Filtering shall only return records matching the selected status.

Search and filters shall work together.

---

Functional Requirements¶

1. Country Search¶

The system shall support searching Countries by:

• Country Name

Search shall:

• Ignore uppercase and lowercase differences.
• Ignore leading and trailing spaces.
• Support partial text matching.

---

2. City Search¶

The system shall support searching Cities by:

• City Name

Search shall:

• Ignore uppercase and lowercase differences.
• Support partial text matching.

---

3. Country Filter¶

Supported filters

• All
• Active
• Inactive

---

4. City Filter¶

Supported filters

• All
• Active
• Inactive

---

5. Combined Search & Filter¶

When both search and filter are provided,

Only records matching both conditions shall be returned.

---

6. No Matching Records¶

If no records match,

The system shall return an empty result set.

---

7. Default Behaviour¶

If no search text or filters are provided,

The system shall return all available records.

---

Business Exceptions¶

Invalid filter value

Display

The selected filter is not supported.

Search text contains only spaces

Treat it as an empty search.

---

Acceptance Criteria¶

Scenario 1¶

Given a valid Country search,

When matching records exist,

Then matching Countries shall be returned.

---

Scenario 2¶

Given a valid City search,

When matching records exist,

Then matching Cities shall be returned.

---

Scenario 3¶

Given an Active filter,

When records exist,

Then only Active records shall be returned.

---

Scenario 4¶

Given search and filter are applied together,

When matching records exist,

Then only matching records shall be returned.

---

Scenario 5¶

Given no matching records,

When search completes,

Then an empty result shall be returned.

---

In Scope¶

• Country Search
• City Search
• Status Filters
• Combined Search & Filter
• Default Results

---

Out of Scope¶

• Sorting
• Pagination
• Export
• Bulk Search
• Full-text Search
• Advanced Filters