The query set in secondaryIndexes cannot be executed.

[rnrnstar2]

Environment information

npx amplify info                                                                                                          【 main 】
System:
  OS: macOS 14.0
  CPU: (10) arm64 Apple M2 Pro
  Memory: 220.56 MB / 16.00 GB
  Shell: /bin/zsh
Binaries:
  Node: 20.5.0 - /usr/local/bin/node
  Yarn: 1.22.19 - /usr/local/bin/yarn
  npm: 9.8.0 - /usr/local/bin/npm
  pnpm: 8.15.5 - ~/Library/pnpm/pnpm
NPM Packages:
  @aws-amplify/backend: 0.13.0-beta.20
  @aws-amplify/backend-cli: 0.12.0-beta.22
  aws-amplify: 6.0.28
  aws-cdk: 2.138.0
  aws-cdk-lib: 2.138.0
  typescript: 5.4.5
AWS environment variables:
  AWS_PROFILE = cloudteam
  AWS_DEFAULT_PROFILE = cloudteam
  AWS_STS_REGIONAL_ENDPOINTS = regional
  AWS_NODEJS_CONNECTION_REUSE_ENABLED = 1
  AWS_SDK_LOAD_CONFIG = 1
No CDK environment variables

Description

The query set in secondaryIndexes cannot be executed.

OnePieceItem: a
 .model({
   name: a.string().required(),
   getInfo: a.string(),
 })
 .secondaryIndexes((index) => [
   index("getInfo").sortKeys(["name"]).queryField("listByGetInfo"),
 ])
 .authorization([
   a.allow.owner(),
   a.allow.private().to(["read", "update", "create"]),
 ]),

const res = await client.models.OnePieceItem.listByGetInfo({
   getInfo,
 });

Property 'listByGetInfo' has type '{ create: (model: { [x: string]: { [x: number]: string; toString: () => string; charAt: (pos: number) => string; charCodeAt: (index: number) => number; concat: (...args: (string | ConcatArray)[]) => string[]; ... 71 more ...; readonly [Symbol.unscopables]: { ...; }; }; }, options?: { ...; }) => Does not exist in SingularRetur...'.

[AnilMaktala]

Hey @rnrnstar2, Thank you for raising this. We have a follow up question, Have you deployed your backend resources? Can you verify in AppSync console and confirm listByGetInfo query exist?

[rnrnstar2]

Yes, appsync has listByGetInfo.

[rnrnstar2]

I selected multiple sortKeys for secondaryIndexes.
Then I couldn't get the list.

Post: a
      .model({
        name: a.string().required(),
        categoryId: a.id().required(),
        s3ImgKey: a.string(),
        message: a.string().required(),
        gender: a.string().required(),
        prefecture: a.string().required(),
        ageGroup: a.string().required(),
        category: a.belongsTo("Category", "categoryId"),
      })
      .secondaryIndexes((index) => [
        index("categoryId")
          .sortKeys(["gender", "prefecture", "ageGroup"])
          .queryField("listByCategoryId"),
      ]),

// @ts-ignore
      const { data: posts, errors } = await client.models.Post.listByCategoryId(
        {
          categoryId,
          gender: {
            eq: gender,
          },
          prefecture: {
            eq: prefecture,
          },
        }
      );

indexQuery.mjs:76 Uncaught (in promise) TypeError: Cannot convert undefined or null to object
    at Function.keys (<anonymous>)

[chrisbonifacio]

Hi @rnrnstar2 thanks for raising this issue.

This seems to be a duplicate of another issue that was opened regarding composite identifiers.

Please track this issue for updates: #2526

[iartemiev]

We've patched this bug in the latest release of @aws-amplify/data-schema.
Please make sure you're using at least @aws-amplify/backend@1.0.0 and aws-amplify@6.3.0 and then run npm update @aws-amplify/data-schema to consume the patch.

[github-actions]

This issue is now closed. Comments on closed issues are hard for our team to see.
If you need more assistance, please open a new issue that references this one.