i dont have a specific reference to this, for example i have a unique attribute in a collection of type integer and i want to create that attribute based on a range lets say 250-500 if was to do query.lessthanequal 500 query.greaterthanequal 250 i would have to list all the documents just to check if that integer is occupied so i can create one in that range am i right? i think thats a heavy approach i may be missing something here
You can just create and get error if the ID is occupied
ive thought of thise but then i would iterate until i find one document that doesnt have that int occupied
Yes that sounds as a bummer I don't think you have a way to do it in AppWrite database engine What I would suggest is that you create a flag collection with the last ID as integer and go from there
can you explain how a flag collection works? is it just that integer as doc id and then how would i query for the ascending doc in a collection?
It's just a logic offer What I mean Let's say you have Database Website Collection Users when each user id can be only between 250-500 Then you create a second collection named Flags with the attributes name, value and you add a document with the balues name last_inserted_id value 250
Then in your code you first fetch this data like so
const MAX_USERS_ID = env['MAX_USERS_ID'] ?? 500;
const lastID = getLastID() // In this function you will connect to database and get the value
if(lastID >= MAX_USERS_ID){
throw "We don't accept any new users"
}
if(createNewUser(++lastID)) {
updateLastID(lastID);
}
i think this is a really good approach thank you for sharing
[SOLVED] creating unique attribute values by range-integer
Recommended threads
- Type Mismatch in AppwriteException
There is a discrepancy in the TypeScript type definitions for AppwriteException. The response property is defined as a string in the type definitions, but in pr...
- What Query's are valid for GetDocument?
Documentation shows that Queries are valid here, but doesn't explain which queries are valid. At first I presumed this to be a bug, but before creating a githu...
- HTTP POST to function returning "No Appw...
Hi everyone, I’m running into an issue with my self-hosted Appwrite instance. I’ve set up my environment variables (APPWRITE_FUNCTION_PROJECT_ID, APPWRITE_FUNC...