Rank 1: Thread
I have n numbers of data in appwrite collection. I want to get that data where id is something and createdAt DESC.
But I 'm getting error while creating index in it.
Votes
0
Replies
20
Participants
Unknown
Messages
21
Rank 1: Thread
I have n numbers of data in appwrite collection. I want to get that data where id is something and createdAt DESC.
But I 'm getting error while creating index in it.
you don't need fulltext on $createdAt. There is index by default on all internal attributes. Leave it on "key" and try recreating once?
Moderator
I thought that was related to yesterday issue 😅
Moderator
@Khushal@2303 Try this
Rank 1: Thread
okay, I'm trying @joeyouss
Rank 1: Thread
Getting same error
is it on cloud?
Rank 1: Thread
Yes, in cloud
weird, i tried creating it, it is successful for me
Can you DM me your project ID please?
Also, why are you creating a createdAt index? can you tell me your use case of this?
Rank 1: Thread
I think I don't need to create index for it. I will work with $createAt.
So I will manage it with key $createAt.
Thank you @joeyouss for you time.
Rank 1: Thread
it's strange, I'm trying with other attribute and it's still failing
Moderator
Seems like there are problems with the database cluster
would be helpful if you share your project ID with me once?
Moderator
@Khushal@2303 Does it work now?
If not, send your project ID to Jyoti
Rank 1: Thread
@D5 and @joeyouss
Now working perfectly, don't know how but it's working fine now.
That’s great to know, I shall close this then
Moderator
[SOLVED] Failed - Index creating
Moderator
Error in line 92749718848: Jyoti couldn't fetch further information
I wonder if I might be an AI as well