Dynamoose-无法使用2个键查询和where

我已经在GitHub上打开了一个相关的问题,但是也许这里的人能够更快地提供帮助。

总结:

ValidationException: Query key condition not supported 我需要在给定位置的最后(数量)秒内查找记录。 One 和 another one

:

Activity.query('locationId').eq(locationId).exec();

:

Activity.query('locationId').eq(locationId).where('createdAt').ge(date).exec();

代码示例:

const Activity = (dynamoose: typeof dynamooseType) => dynamoose.model<ActivityType, {}>('Activity',
    new Schema({
      id: {
        type: String,
        default: () => {
          return uuid();
        },
        hashKey: true,
      },
      userId: {
        type: String,
      },
      locationId: {
        type: String,
        rangeKey: true,
        index: {
          global: true,
        },
      },
      createdAt: { type: Number, rangeKey: true, required: true, default: Date.now },
      action: {
        type: Number,
      },
    }, {
      expires: 60 * 60 * 24 * 30 * 3, //  activity logs to expire after 3 months
    }));

async getActivitiesInLastSeconds(locationId: string, timeoutInSeconds: number) {
    const Activity = schema.Activity(this.dynamoose);
    const date = moment().subtract(timeoutInSeconds, 'seconds').valueOf();
    return await Activity.query('locationId').eq(locationId)
      .where('createdAt').ge(date).exec();
  }