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

Cannot filter != or NOT IN #1047

Open
LevEricCheung opened this issue Dec 7, 2018 · 1 comment
Open

Cannot filter != or NOT IN #1047

LevEricCheung opened this issue Dec 7, 2018 · 1 comment

Comments

@LevEricCheung
Copy link

I am a little new at this but I'm trying to find out why when filtering using != (and NOT IN) does not work, all the other operators (=, >, >=, <, <=) seem to work fine.

It throws an error when querying on GET on my server:

/api/ticket?filter[ticket_number][value]=220080&filter[ticket_number][operator]="!="

{
"type": "http://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html#sec10.5.1",
"title": "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'node.entity_id' in 'where clause'",
"status": 500
}

Ticket is a node.
A Ticket__1_0.php was created that extends resourceNode
Ticket number is a field created with Field API.
Data provider is pointing to DataProviderEntity.

If anyone can help steer me in the right direction on where to look to fix the problem, it would be appreciated!

@ordavidil
Copy link

@echeung3
#1051 is merged and seems to solve your issue as well.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants