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
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