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

Doesn't scramble the where correctly #494

Open
frbuceta opened this issue Feb 25, 2022 · 0 comments
Open

Doesn't scramble the where correctly #494

frbuceta opened this issue Feb 25, 2022 · 0 comments
Assignees
Labels

Comments

@frbuceta
Copy link
Contributor

Steps to reproduce

A call is made in Loopback 4 but it doesn't resolve the where correctly.

curl --location -g --request GET '127.0.0.1:3000/articles?filter[include][0]=attributes&filter[limit]=25&filter[where][attributes][or][0][name]=COLECCIÓN&filter[where][attributes][or][0][value][inq][0]=MARVEL&filter[where][attributes][or][0][value][inq][1]=SUPERHÉROES'

Current Behavior

  loopback:connector:postgresql SQL: SELECT "id","name","value","article_id" FROM "public"."attributes" WHERE (("name"=$1 AND "value"=$2)) ORDER BY "id"
  loopback:connector:postgresql Parameters: ["COLECCIÓN","[object Object]"] +6s

Expected Behavior

SQL: SELECT "id","name","value","article_id" FROM "public"."attributes" WHERE (("name"=$1 AND "value" in ($2, $3))) ORDER BY "id"
Parameters: ["COLECCIÓN","MARVEL","SUPERHÉROES"] +6s

Additional information

linux x64 16.14.0
├── loopback-connector-postgresql@5.5.0
@frbuceta frbuceta added the bug label Feb 25, 2022
@frbuceta frbuceta self-assigned this Feb 25, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
Status: Icebox
Development

No branches or pull requests

1 participant