All Users Filter

Plugin for filtering, sorting, and exporting users.

This plugin allows you to filter, sort, and export users in CSV format. You can filter users by multiple parameters, such as date, role, meta key-value, and registration date.

Usage

Use the Users → All Users Filter screen to compose conditions. Choose a meta key, operator, type, value, and (optionally) group relation to build complex queries without code. Export matched users to CSV.

Admin UI → WP_Meta_Query Mapping

• meta_key → key
• operator → compare
• Type → type
• meta_value → value
• Group relation (if available) → relation: AND | OR

Meta keys used in tests (wp_usermeta.meta_key)

• job_description (string)
• job_designation (string; single value OR a pipe/comma-separated list)
• age_in_years (integer-like string)
• joining_date (stored as YYYY-MM-DD or full YYYY-MM-DD HH:MM:SS)
• monthly_salary (numeric, e.g., 9000)

If your dataset stores dates in a different format (e.g., DD/MM/YYYY) or salaries with commas (e.g., 9,000), see Edge Cases below.

Test Cases

The following UI test cases validate common scenarios and guardrails.

1) Single-condition functional tests

1A. Exact match on text
Intent: Users with job_description exactly 「Lorem ipsum test」.
UI:
– meta_key: job_description
– operator: =
– Type: CHAR
– meta_value: Lorem ipsum test
Expected: Exact match; typically case-insensitive under default collations; respects spaces.

1B. Case-sensitive regex match
Intent: job_description starts with Lorem (case-sensitive).
UI:
– meta_key: job_description
– operator: REGEXP
– Type: BINARY
– meta_value: ^Lorem
Expected: Matches only values beginning with uppercase Lorem.

1C. Negative regex
Intent: job_description does NOT mention ipsum as a whole word.
UI:
– meta_key: job_description
– operator: NOT REGEXP
– Type: CHAR
– meta_value: (^|[^A-Za-z])ipsum([^A-Za-z]|$)
Expected: Excludes any row containing ipsum as a separate word.

2) Multi-value (roles) tests for `job_designation`

Assume values include: UI/UX Designer | QA Engineer | DevOps Engineer | Project Manager | Business Analyst | HR Manager | Data Analyst | Software Engineer | System Admin | Marketing Specialist

2A. Membership via IN
Intent: QA Engineer OR DevOps Engineer.
UI:
– meta_key: job_designation
– operator: IN
– Type: CHAR
– meta_value: QA Engineer, DevOps Engineer (comma-separated → parsed to array) Must Include at least one array
Expected: Exact membership match.

2B. Pipe-separated field using REGEXP
Intent: Field stores multiple roles separated by |; match Software Engineer or Data Analyst.
UI:
– meta_key: job_designation
– operator: REGEXP
– Type: CHAR
– meta_value: (^|s*|s*)(Software Engineer|Data Analyst)(s*|s*|$)
Expected: Token-aware match; avoids partials like 「Engineer」 inside longer tokens.

2C. Excluding a role with NOT REGEXP
Intent: Exclude HR Manager.
UI:
– meta_key: job_designation
– operator: NOT REGEXP
– Type: CHAR
– meta_value: (^|s*|s*)HR Manager(s*|s*|$)
Expected: Excludes any token equal to HR Manager.

3) Numeric range tests for `age_in_years`

3A. Inclusive range (happy path)
Intent: 18–45 inclusive.
UI:
– meta_key: age_in_years
– operator: BETWEEN
– Type: NUMERIC (or UNSIGNED)
– meta_value: 18,45
Expected: Ages 18 through 45 inclusive.

4) Date tests for `joining_date` on Meta Filters

Reference cut-off date: 2023-08-25 (two years ago from baseline).

4A. On or before cut-off (joined ≥ 2 years ago)
UI:
– meta_key: joining_date
– operator: <=
– Type: DATE
– meta_value: 2023-08-25
Expected: On or before 2023-08-25. If stored as DATETIME, see 4A』.

4B』. DATETIME variant
UI:
– meta_key: joining_date
– operator: <=
– Type: DATETIME
– meta_value: 2023-08-25 23:59:59

5) Salary tests for `monthly_salary` (business rule: exactly 9000)

5A. Exact numeric
UI:
– meta_key: monthly_salary
– operator: =
– Type: NUMERIC
– meta_value: 9000

5B. Degenerate range ⇒ equality
UI:
– operator: BETWEEN
– Type: NUMERIC
– meta_value: 9000,9000

10) Extending scope for multiple users

Allow non-admins (specific user ID) to use the plugin by adding this to your theme』s functions.php: