Solved Select entries by emailadress of the logged in user

[depauw]

Hello,

I've made a project, where users can make entries of schedules.
The entries are saved in table 'j25_extratime' and the user is identified by emailadress in the column 'teammember'

I'd like to create a list, where the users can see thier entries, but not the entries of other users.

I think it can be done by this sort of selection (pseudocode):
show the entries where 'teammember' in 'j25_extratime' = 'email' in 'jom3_users'of the logged in user

Can this be done with a prefilter? or a query?

I found this example in the pre-filter wiki:
where:
field = your-user-element(raw)
condition: equals
value: {$my->id}
type=text
Apply to = public

field would be: j25_extratime___teammember_raw
But i have no idea on how to determine the 'value' for my project.
I tried this, with no succes: {$my->jom3_users___email}

Anyone who can help point me in the right direction?

Cheers,
Christophe

 

[troester]

Value {$my->email}
https://fabrikar.com/forums/index.php?wiki/placeholders/#types-of-placeholders-8203

 

[depauw]

Thanks for the pointer and the placeholder-list!
Got it working in no time!!!!

Cheers