Date column sorting issue with 'sortable' option

[gokuzhan]

Hi there,

I don't see what's wrong with this simple query.

Schema

import { Schema } from 'redis-om';

export type User = {
  id: string;
  gender: string;
  age: number;
  lastMatchAt: Date;
};

export const userSchema = new Schema(
  'User',
  {
    id: { type: 'string' },
    gender: { type: 'string' },
    age: { type: 'number' },
    lastMatchAt: { type: 'date', sortable: true },
  },
  { dataStructure: 'HASH', indexName: 'id' },
);

Query

    const find = this.db.userRepository.search().where('id').is.not.equalTo(me.id);

    if ([Gender.Male, Gender.Female].includes(looking.gender)) {
        find.and('gender').is.equalTo(looking.gender);
    }
    
    find.and('age').is.between(looking.minAge, looking.maxAge);
    
    return await find.returnMin('lastMatchAt');   

Result

[ErrorReply: Property lastMatchAt not loaded nor in schema]

[MR4online]

I had the same error minutes ago.
Restarting the nodeJs-Service / Docker-Container fixed it for me.
May there an issue like: indexing on service start took too long, so that redis-om thinks it's not there?

[EDIT: still happens almost everytime I start my services. @guyroyse may you please have a look?]

[Desnoo]

The issue at our end (@MR4online, same company) was, that the index was overwritten by another service at startup. That in the end some fields were missing on the used index.