fetching from database

i want to fetch user followers from database and i double checked everything but still not able to get the list. here's my user_api code . there could be a mistake in query i guess -

  Future<List<model.Document>> getFollowers(String uid) async {
    final documents = await _db.listDocuments(
      databaseId: AppConstants.APPWRITE_DATABASE_ID, 
      collectionId: AppConstants.APPWRITE_USERS_COLLECIION,
      queries: [
        Query.equal('followers', uid)
      ]
    );
    return documents.documents;
  }```

it looks good, have you created an index on followers field?

and could you pls send the error message

here's my controller code - Future<List<UserModel>> getFollowers(String uid) async { final followersDocs = await _userAPI.getFollowers(uid); return followersDocs.map((e) => UserModel.fromMap(e.data)).toList(); }

provider - final getFollowersProvider = FutureProvider.family((ref, String uid) async{ final UserProfileController = ref.watch(userProfileControllerProvider.notifier); return UserProfileController.getFollowers(uid); });

and here i am displaying - ref.watch(getFollowersProvider(user.uid)).when( data: (followers) { print('Followers Count: ${followers.length}'); print('User UID: ${user.uid}'); return ListView.builder( itemCount: followers.length, itemBuilder: (BuildContext context, int index) { final follower = followers[index]; return SearchTile(userModel: follower); }, ); }, error: (error, st) => ErrorText(error: error.toString()), loading: () => const Loader(), ),

followers present in my usermodel - class UserModel { final String email; final String name; final List<String> followers;

and there's no error. the list is just not displaying. and printing followers.length = 0

I think i am using wrong query because the followers are in list but idk what would be the right query to use

as here followers field is a list its still wip here you can see an issue about the same https://github.com/appwrite/appwrite/issues/2838

you can trying using Query.search (as mention in one of the comments it kinda works) or filter in the client side as per the requirment

i tried using query.search. still not working :_

Yes i tried using listDocument its not working, also not getting desired attribute data

rn something like Query.contains is not present to search from a list but you can do filter it in the client side 😁

whats exactly not working for you @Pradhumansinh Padhiyar

Something like

SELECT username, email, password, firstname, lastname from tbl_users WHERE lastname = "Ranjan"

How can i achieve something like this using Db collection ?

add a query as
Query.equal('lastname', 'Ranjan')
and make a index for the lastname parameter in the appwrite console

how could i do that?

actually depends on what exactly you are tying to do

Some days Ago I am also Facing this issue You need To Specify your attribute into the indexes Section