createIndex¶

Creates an index on the columns listed. Your index should include all the columns you will query in a single request. Type can be key, fulltext, or unique.

Usage Example¶

extends Node

func _ready():
    # You can skip setup if you have .env
    Appwrite.set_endpoint('https://<REGION>.cloud.appwrite.io/v1') # Your API Endpoint
    Appwrite.set_project('<YOUR_PROJECT_ID>') # Your project ID
    Appwrite.set_key('<YOUR_API_KEY>') # Your secret API key

    var result = await Appwrite.tablesDB.create_index(
        '<DATABASE_ID>',
        '<TABLE_ID>',
        "",
        Appwrite.TablesDBIndexType.KEY,
        [],
        Appwrite.[OrderBy.ASC], # optional
        [] # optional
    )

    if result is AppwriteException:
        push_error(result.message)

    if result is AppwriteColumnIndex:
        print(result.to_dict())