Skip to content

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

Description

@jordanbtucker

Steps to reproduce

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

  • Tell us what broke. The more detailed the better.
  • 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

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions