feathers-knex icon indicating copy to clipboard operation
feathers-knex copied to clipboard

`find` adds the `id` column automatically with no easy way to remove it

Open jordanbtucker opened this issue 5 years ago • 1 comments

Steps to reproduce

(First please check that this issue is not already solved as described here)

  • [x] Tell us what broke. The more detailed the better.
  • [x] If you can, please create a simple example that reproduces the issue and link to a gist, jsbin, repo, etc.

find will always return records with an id, and while this is often useful, it makes it difficult to customize the query with something like distinct or group by.

An example, including a workaround, are available at https://gist.github.com/jordanbtucker/30d403170e3104b841f7195d25ba6101.

Expected behavior

There should be a way to remove the id column from a query.

Actual behavior

The id column is included in queries, which is problematic when you want to alter the query with something like distinct as explained in Customizing the query.

System configuration

Module versions (especially the part that's not working):

"feathers-knex": "^7.1.0",
"knex": "^0.21.1",
"mysql": "^2.18.1",

NodeJS version:

v12.18.1

jordanbtucker avatar Jun 29 '20 16:06 jordanbtucker

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Apologies if the issue could not be resolved. FeathersJS ecosystem modules are community maintained so there may be a chance that there isn't anybody available to address the issue at the moment. For other ways to get help see here.

stale[bot] avatar Oct 04 '20 02:10 stale[bot]