chrisbonifacio
commented
2 days ago Hi @hangoocn thanks for raising this issue. I was not able to reproduce the behavior described in the issue with the latest versions of amplify backend and library, the following backend schema, and frontend code:
Message: a
.model({
roomId: a.id().required(),
createdAt: a.datetime(),
content: a.string().required(),
})
.secondaryIndexes((index) => [
index("roomId").sortKeys(["createdAt"]).queryField("listByDate"),
])
.authorization((allow) => [allow.owner()]),"use client";
import { Authenticator } from "@aws-amplify/ui-react";
import "@aws-amplify/ui-react/styles.css";
import CustomerCreateForm from "@/ui-components/CustomerCreateForm";
import { generateClient } from "aws-amplify/api";
import { Schema } from "@/amplify/data/resource";
const client = generateClient<Schema>();
const App = () => {
const createMessage = async () => {
const { data, errors } = await client.models.Message.create({
roomId: "123",
content: "Hello",
});
console.log({ data, errors });
};
const listByDate = async () => {
const { data, errors } = await client.models.Message.listByDate(
{ roomId: "123" },
{ sortDirection: "DESC" }
);
console.log({ data, errors });
};
return (
<Authenticator>
{({ user, signOut }) => {
return (
<>
<h1>Hello {user?.username}</h1>
<h1>Protected content!</h1>
<button onClick={createMessage}>Create Message</button>
<button onClick={listByDate}>List By Date</button>
<CustomerCreateForm />
</>
);
}}
</Authenticator>
);
};
export default App;Result:
I was able to use createdAt with a sortDirection of DESC
Also, I did not run into any errors when changing sortDirection to ASC
hangoocn
Environment information
Data packages
Description
What I want to do is to sort results by
createdAt, so below is what I did:Create a model with
datetimefield and add a secondaryIndex like this:then run the query in the app:
It will then show error
Validation error of type UnknownType: Unknown type ModelAWSDateTimeKeyConditionInput.I also noticed two patterns when testing it in sandbox:
contentfrom model, wait sandbox rebuild, then add it backcreatedAttype to string, it will start to work, and then you change it back todatetime, it also work.It always have the error when deploy to non-sandbox env.
I am not sure if this is correct way of sorting result by create time in gen 2, but this was what used to work in gen 1.