Check Database By Owner

Ask the community
,
1

Hello Community,

I am trying to query my database - if a record exists for the “Owner”, then return true. Nothing I’ve tried is working. Here are a few things I’ve tried:

wixData.query(“response”)
.eq(“Owner”, wixUsers.currentUser.id)
.find()
.then(res => {
if (res.items.length === 0)
{
return false ;
}
else
{
return true ;
}
});

wixData.query(“response”)
.eq(“Owner”, wixUsers.currentUser.id)
.find()
.then(res => {
return true
});

I assume I can filter by the default “Owner” field, right? Why are none of these working? I definitely have data in both the Live and Sandbox databases for the user.

2

See here about the system fields and their appropriate field names and keys.
https://support.wix.com/en/article/about-your-database-collection-fields#system-fields

Field Name: Owner
Field Key: _owner
Field Type: Text
Field Description:
A unique identifier for the creator of the item. Used by the permissions model to determine which user is assigned the Site member author role for the item.

3

Thanks for the response - I referred to the articles; I tried changing my reference to the “Owner” field to “_owner”, which still didn’t work. I have custom permissions set up - and it’s not even working in my preview mode (admin user) role, so I don’t think it’s a page permission issue…?