I have this strange situation, i have 4 users, two of them has the label "owner" other two has the label "admin" and its data seems consistent, but for some reason one user is a "ghost" for any search term, im using php to get list of users, examples:
if i do this:
var_dump($usersow->list());
appwrite return my 4 users
if i do this:
var_dump($usersow->list([],'admin'));
appwrite return the two users that has "admin" label
but, if i do this:
var_dump($usersow->list([],'owner'));
appwrite only return one user that has the 'owner' label, but there are two users with 'owner' label
any other valid search term return the user but not the same user that do no list with the 'owner' label, in resume one user (user 3 in array) do not return with any search term, here is the array data of the two users with 'owner' label:
User 2:
$id: "xxxxxx"
$createdAt: "2024-01-25T19:36:38.934+00:00"
$updatedAt: "2024-01-25T20:52:43.031+00:00"
name: "Demo"
password: [Hashed Password]
hash: "argon2"
hashOptions: [Array of Hash Options]
registration: "2024-01-25T19:36:38.932+00:00"
status: true
labels: ["owner"]
passwordUpdate: "2024-01-25T19:36:38.932+00:00"
email: "t@t.com"
phone: "+229876543210"
emailVerification: false
phoneVerification: false
prefs: [Empty Array]
accessedAt: ""
User 3:
$id: "yyyyyyyyyyyyyyyyy"
$createdAt: "2024-02-02T03:48:03.150+00:00"
$updatedAt: "2024-02-02T03:48:03.239+00:00"
name: "demo80"
password: [Hashed Password]
hash: "argon2"
hashOptions: [Array of Hash Options]
registration: "2024-02-02T03:48:03.148+00:00"
status: true
labels: ["owner"]
passwordUpdate: "2024-02-02T03:48:03.148+00:00"
email: "f@f.com"
phone: "+221234567890"
emailVerification: false
phoneVerification: false
prefs: [Empty Array]
accessedAt: ""
TL;DR
The developer is experiencing an issue with a "ghost" user in an app using Appwrite. The search column of the problematic user does not return any results even though it has valid search terms. The user is only listed if an empty list is requested. The developer has provided data for two users with the "owner" label, but only one of them is returning in the search results. The issue persists even after manually editing the users in the Appwrite console.
Solution: The developer should check the database directly to see the value of the search column for the problematic user. They should also ensure they are using the latest version of Appwrite
