Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Filters disabled when filtering for invalid / non existing input #20155

Open
Eventyret opened this issue Apr 19, 2024 · 0 comments
Open

Filters disabled when filtering for invalid / non existing input #20155

Eventyret opened this issue Apr 19, 2024 · 0 comments
Assignees
Labels
issue: bug Issue reporting a bug severity: medium If it breaks the basic use of the product but can be worked around source: core:content-manager Source is core/content-manager package status: pending reproduction Waiting for free time to reproduce the issue, or more information version: 5

Comments

@Eventyret
Copy link
Contributor

Bug report

Required System information

  • Node.js version: 20.x
  • Strapi version: v5.0.0-beta.4
  • Database: Postgres
  • Operating system: MacOS
  • Is your project Javascript or Typescript: TS

Describe the bug

500 error when filtering on relation column where other side has no entries in the database yet

function lower(integer) does not exist seems to be the root of the error. Looks like the generated query is trying to call lower on an id field which is an int type

Steps to reproduce the behavior

  1. Blog content-type
  2. Tags content-type
  3. Add many2many relation between
  4. Have some blogs, no tags yet
  5. Try to add tag filter, contains (insensitive)

You will now see that filters are disabled, so you would have to go back

image

Expected behavior

I would expect to have filtered enabled to change filters again.
Screenshot of the same search but for something that does exist
image

Error logs

@Eventyret Eventyret self-assigned this Apr 19, 2024
@Eventyret Eventyret added issue: bug Issue reporting a bug severity: medium If it breaks the basic use of the product but can be worked around source: core:content-manager Source is core/content-manager package version: 5 labels Apr 19, 2024
@derrickmehaffy derrickmehaffy added the status: pending reproduction Waiting for free time to reproduce the issue, or more information label Apr 29, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
issue: bug Issue reporting a bug severity: medium If it breaks the basic use of the product but can be worked around source: core:content-manager Source is core/content-manager package status: pending reproduction Waiting for free time to reproduce the issue, or more information version: 5
Projects
Status: To be reviewed
Status: To triage
Status: Reproducible on Strapi 5
Development

No branches or pull requests

3 participants