I am having a problem filtering data on a dynamic collections page. I have a collection called “Users” that has each site member’s email address and other information about their projects. There is also a reference field for Members in this table. Here is the structure and some sample content:
When a site member logs in, I want to redirect to that dynamic page, and filter on the email column (“Title”) by the logged-in member’s email address.
I am not able to filter by logged in user’s email. I used the following link for sample code:
https://www.wix.com/velo/forum/coding-with-velo/filtering-a-dataset-by-user-not-owner
And here is my code:
import wixData from 'wix-data';
import wixUsers from 'wix-users';
$w.onReady(function () {
wixUsers.currentUser.getEmail()
then(( (email) => {
let userEmail = email;
$w("#Users").setFilter(wixData.filter()
.eq("Title",email))
})
)});
Here is a screenshot of how my page is set up:
Here is a screenshot of the page without a filter:
Note the logged in user email appears on associated repeater container box.
Scrolling down you can see all the repeater container boxes associated with other users, but not the other users email address at the top of the container box.
And here is a screenshot of the results with the filter in place:
