how to make a attribute unique and it should be optional so it can store null or empty string

its giving error while leaving the optional field as empty because field is already empty string that is why its giving error. AppwriteException: document_already_exists, Document with the requested ID already exists. (409)

TL;DR

The user is trying to make an attribute unique and optional, allowing it to store null or an empty string. They are facing an issue where an empty string is being stored, but it is not visible in the appwrite console. They have shared their code and are not sure why it is not working. They have confirmed that they are passing null as the value for the attribute. Another user suggests checking if the document ID already exists and provides a link with more information about unique attributes. There is no solution provided in the thread.

any one kows the solution ?

Are you manually setting the document ID? Are you using a SDK?

For the unique attribute take a look at: https://github.com/appwrite/appwrite/discussions/1492

both

Can you share the code?

You can use the console to check if there's already a document with the id you are passing.

Also note that if you mark an attribute as unique and try to create two documents with same value for unique attribute the error message is the one you mentioned AppwriteException: document_already_exists, Document with the requested ID already exists. (409) with no indication about which attribute is causing the error.

yes i know about this

Are you making sure to pass null rather than empty string?

yes sending null

yes sending null and also tried empty string but its not working for unique attribute

What's your code? Can you do a get collection on the collection and share the output?

it definitely should work. In the screenshot below i have a unique index on s and the first two documents have s set to null

not using console ,

here is my code

TypeScript

            databaseId: databaseId,
            collectionId: productDataCollectionId,
            documentId: documenId,
            data: {
              "sellingPrice": price,
              "totalQuantity": quantity,
              "productName": pname,
              "image": imageUrl,
              "itemCode":null,
            });```