amplify-category-api icon indicating copy to clipboard operation
amplify-category-api copied to clipboard

Amplify Gen 2: Filtering by relational models

Open AryaRDI opened this issue 7 months ago • 1 comments

Environment information

System:
  OS: macOS 13.6.4
  CPU: (8) x64 Intel(R) Core(TM) i7-7820HQ CPU @ 2.90GHz
  Memory: 775.02 MB / 16.00 GB
  Shell: /bin/zsh
Binaries:
  Node: 22.11.0 - ~/.nvm/versions/node/v22.11.0/bin/node
  Yarn: 1.7.0 - /usr/local/bin/yarn
  npm: 10.9.0 - ~/.nvm/versions/node/v22.11.0/bin/npm
  pnpm: 9.15.2 - ~/Library/pnpm/pnpm
NPM Packages:
  @aws-amplify/auth-construct: 1.6.0
  @aws-amplify/backend: 1.14.1
  @aws-amplify/backend-ai: Not Found
  @aws-amplify/backend-auth: 1.5.0
  @aws-amplify/backend-cli: 1.4.10
  @aws-amplify/backend-data: 1.4.0
  @aws-amplify/backend-deployer: 1.1.17
  @aws-amplify/backend-function: 1.12.2
  @aws-amplify/backend-output-schemas: 1.4.0
  @aws-amplify/backend-output-storage: 1.1.4
  @aws-amplify/backend-secret: 1.1.6
  @aws-amplify/backend-storage: 1.2.4
  @aws-amplify/cli-core: 1.2.4
  @aws-amplify/client-config: 1.5.7
  @aws-amplify/data-construct: 1.14.8
  @aws-amplify/data-schema: 1.17.5
  @aws-amplify/deployed-backend-client: 1.5.0
  @aws-amplify/form-generator: 1.0.4
  @aws-amplify/model-generator: 1.0.12
  @aws-amplify/platform-core: 1.6.2
  @aws-amplify/plugin-types: 1.8.0
  @aws-amplify/sandbox: 1.2.11
  @aws-amplify/schema-generator: 1.2.7
  aws-amplify: 6.13.0
  aws-cdk: 2.1000.0
  aws-cdk-lib: 2.179.0
  typescript: 5.3.3
No AWS environment variables
No CDK environment variables

Describe the feature

The possibility of using the filter in the List() operation to filter the nested objects and its fields (Models' relationship)

Use case

Imagine I have the Post model, which has a nested object Author, and I want to filter to Post where author.name = 'XXX' I can't find any way to do it

AryaRDI avatar Mar 10 '25 09:03 AryaRDI