Skip to content

[BUG] Pagination does not reset when applying filters in Prisma Studio@^7Β #1430

@broisnischal

Description

@broisnischal

Bug description

Pagination does not reset when applying filters in Prisma Studio

Description

When using Prisma Studio, applying or changing filters does not reset the current pagination state.
If the user is on a later page (e.g. page 5) and applies a filter that reduces the result set, Prisma Studio continues to show the same page number, often resulting in an empty table or missing records.

Severity

πŸ”Ή Minor: Unexpected behavior, but does not block development

Reproduction

Steps to reproduce

  1. Open Prisma Studio
  2. Navigate to any model with multiple pages of data
  3. Go to a later page (e.g. page 4 or 5)
  4. Apply a filter that reduces the dataset
  5. Observe that the table stays on the same page and may show no records

Expected vs. Actual Behavior

Expected behavior

  • Pagination should automatically reset to the first page when:
    • A filter is applied
    • A filter is modified
    • A filter is cleared
  • The first page should always reflect the filtered result set.

Actual behavior

  • Pagination remains on the previously selected page.
  • Filtered results may appear empty even though matching records exist on earlier pages.
  • Users must manually navigate back to page 1 to see results.

Frequency

Consistently reproducible

Does this occur in development or production?

Only in development (e.g., CLI tools, migrations, Prisma Studio)

Is this a regression?

Workaround

Impact

  • Confusing user experience, especially with large datasets
  • Makes it appear as if filters are not working
  • Requires unnecessary manual pagination reset

Prisma Schema & Queries

// Add relevant schema.prisma snippet
// Add relevant Prisma Client query

Prisma Config

// Add your `prisma.config.ts`

Logs & Debug Info

// Debug logs here

Environment & Setup

  • OS:
  • Database:
  • Node.js version:

Prisma Version

// Prisma version output

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions