Back

Applying unique index on 2 fields

  • 0
  • Databases
Said H
5 Apr, 2023, 10:52

Hello, I am trying to apply attribute A and B combined as a unique index, but it gives me "failed" message. Is it not supported at the moment?

Thanks.

TL;DR
TL;DR: The user is experiencing an issue with applying a unique index on two fields. They have tried creating a new attribute and setting an index but it failed. They are looking for solutions and have shared the necessary information with the relevant parties. It is unclear if the issue has been resolved.
joeyouss
5 Apr, 2023, 11:00

Hi πŸ‘‹

joeyouss
5 Apr, 2023, 11:00

let me check once

joeyouss
5 Apr, 2023, 11:06
joeyouss
5 Apr, 2023, 11:21

can you do docker compose logs appwrite-worker-databases

Said H
5 Apr, 2023, 12:51

Hello Jyoti. I'm using appwrite cloud

Said H
5 Apr, 2023, 12:51

Or Is there a way for me to access the log?

Said H
5 Apr, 2023, 12:52

There is no duplication because I only have that 1 index for that collection

joeyouss
5 Apr, 2023, 13:09

Hmm seems possible to me..can you share project ID with me? You can DM me

Tessa
7 Apr, 2023, 21:13

@Said H has this been resolved? πŸ™‚

Said H
8 Apr, 2023, 01:46

hey @Tessa , thanks for following up. Hello @joeyouss , let me know if you have some solutions. I have DM you the info.

Said H
9 Apr, 2023, 05:40

Hi @joeyouss , even when i tried creating a new attribute and set an index to that new attribute, it just failed it

Said H
9 Apr, 2023, 05:42

i think i found a pattern to replicate this.

Said H
9 Apr, 2023, 05:42

this is happening to any attribute with URL type

joeyouss
12 Apr, 2023, 07:35

Hi - thanks for sharing in depth, let me look into this and apologies for taking a bit longer to reply!

Reply

Reply to this thread by joining our Discord

Reply on Discord

Need support?

Join our Discord

Get community support by joining our Discord server.

Join Discord

Get premium support

Join Appwrite Pro and get email support from our team.

Learn more