finding by association doesn't work

[mkeremguc]

User.js

attributes: {
 groups: {
  collection: 'userGroup',
 }
}

UserGroup.js

attributes: {
 name: {
  type: 'STRING',
 }
}

when i try something like:

User
.find()
.where({groups: [1,2]})
.exec(function(err, user) {
 if (err) {
  res.json({ error: err }, 500);
 } else {
  res.json(user);
 }
});

it gives error:

-error: {
 error: "E_UNKNOWN"
 status: 500
 summary: "Encountered an unexpected error"
-raw: {
 code: "ER_BAD_FIELD_ERROR"
 errno: 1054
 sqlState: "42S22"
 index: 0
}
}

however, i do really need to search via blueprints like posting this to find method of the user controller:

{
 "where": {
   "groups": [1,2]
 }
}

it also gives server error 500 without details.

according to sails issue 124 which was the post about associations, the examples about finding through collections was like that: #124 (comment)

sorry if this is a sails issue and i posted this to wrong place.

using sails v0.10-rc7 and waterline-v0.10-rc13

bug or error on my side ?

thanks

[mkeremguc]

nooone even uses find by associations?

[luislobo]

I'm having a similar issue here. Any info on this @mikermcneil?

[tjwebb]

Use the latest version of sails. Works for me in 0.10.5

[mkeremguc]

it still doesn't work for me

[AnalogJ]

This isn't working for me either in Sails v0.11.0
Is this a verified bug? Or just an unimplemented feature?

[dmarcelino]

@mkeremguc, @AnalogJ, which adapters are you using?

Regarding .where({groups: [1,2]}), are 1 and 2 primary keys?

[mkeremguc]

@dmarcelino, mysql and mongo

and yes, primary keys

[AnalogJ]

@dmarcelino I'm using postgres, and yes, I'm using the primary keys. I didn't catch an error like @mkeremguc saw, my query just never completed, though I just may not have had a .fail() clause set up.

[dmarcelino]

I'm just thinking... I'm not sure this functionality is in the spec, at least I don't recall it when I implemented sails-orientdb and I don't remember seeing it in the docs. Can someone PR a test to waterline-adapter-tests? That would help towards figuring out which adapters are broken/don't implement this and then we could work on getting it fixed/spec'ed.

[mkeremguc]

there are lotsa features that is not in the docs either. however, that feature may not be implemented as @dmarcelino said. i was just referencing #124 (comment) at the time.

even though it not be implemented yet, i would still ask how you search/find/filter by association values ? custom in-memory functions would not be efficient for large data sets.

btw, it gives empty array via blueprint at the moment.

[devinivy]

This often relies on using native (mongo adapter) or query (sql adapters) adapter methods, which allows you to make queries directly through the database wrapper.

[dmarcelino]

I believe for something like this to work (without resorting to .native() or .query()) we'll need the .populateKeys() feature being discussed in #532 or wait for #266.

[dmarcelino]

Closing this as duplicate of #266, please re-open if you believe this is a different feature.