Filter Participant Notes to Logged-In Member Only (Wix Studio / Members Area)

Ask the community
, , , ,
1

Filter Participant Notes to Logged-In Member Only (Wix Studio / Members Area)

Working in
Wix Studio

Site link

I’ve been working for longer than I want to admit on a Wix Studio Members Area and am stuck on a specific filtering issue.

Goal
Each logged-in member should only see their own Participant Notes—not notes belonging to other participants.

Setup

  • Wix Studio

  • Members Area (custom member page, not dynamic)

  • CMS collections:

    • Participants (linked to members via member/user ID)

    • Participant Notes (each note linked to a Participant reference)

  • Notes are displayed via a repeater connected to a dataset

What I’ve Tried

  • Dataset filters using:

    • currentMember._id

    • reference fields (Participant → Notes)

  • Client-side code with:

    • currentMember.getMember()

    • wixData.query() filtering notes by participant

  • Filtering datasets onReady and after login

  • Custom member pages vs dynamic pages

  • Verified permissions and collection roles

Current Problem

  • The page either:

    • Shows all Participant Notes to all logged-in users, or

    • Fails to display anything when filters are applied

  • Menu navigation and page access work correctly

  • I can confirm the logged-in member ID and participant relationship, but I can’t reliably restrict the dataset to only that participant’s notes

What I’m Looking For

  • The correct pattern (dataset setup + code, if needed) to:

    • Resolve the logged-in member

    • Match them to their Participant record

    • Filter a Notes dataset so only their notes appear

If this is something that must be done via dynamic pages, backend code, or a specific dataset configuration, I’d appreciate confirmation. At this point I need to know the canonical Wix Studio way to do this.

Thank you
Eric

2

So if I understand correctly, you have three collections involved in this:

  1. Wix App Collection > Members > FullData / PrivateData / PublicData
  2. Participants
  3. Participant Notes

For a three-level filtering like this, using code is the best option instead of trying to make it work with dataset filters. You will have to write code that runs like this:

  1. Fetches the logged in Member’s ID.
  2. Finds the Participant ID by querying the referenced field using the Member ID.
  3. Filters the Participant Notes collection to only show notes based on the referenced Participant ID.

This way it should correctly show notes only belonging to each respective participant.