Use current user to filter table view data in confiForms

[Ralf Weidauer]

I need to filter the data displayed in a confiForms table view. The data is stored on a different page and I want to show only these records which were created by the current user.

In the "Filter to apply on entries dataset" field of the table view macro I tried something like

_user:createdBy

with or without leading underscores, using or not using the [entry.] notation, (I guess) all combination of those, wouldn't work.

Most interesting, if I use a fixed username "aUser" (where aUser created the records and is the current user)  _user:aUser succeeds as well as createdBy:aUser.

I do not think that confiForms abolished the "a=b and b=c   =>   a=c"-principle, so I must be getting something wrong.

Anybody out there having solved this problem?

[Alex Medved _ConfiForms_ · Accepted solution]

Hi @Ralf Weidauer 

Welcome to this community 

The filtering expression looks like this 

createdBy:[entry._user]

How is this translated!? Comparing the createdBy field in the record with the value accessed from the context 

https://wiki.vertuna.com/display/CONFIFORMS/Accessing+field+values+and+properties#Accessingfieldvaluesandproperties-Additionalvaluesavailableinthecontext

Alex

[Ralf Weidauer]

Alex,

actually I was pretty sure to have tried that as well (since I did not know how to make it ;-) ).

Nevermind, it works allright!

Thanks a lot for your super quick and perfect answer!

[Valjean Clark]

Awesome. I was trying to do the exact same thing and luckily this thread popped up in my first search.