UserName vs Author in View

Hi there,

I want to create a view where a person which is logged in can only see its own created documents.

In other words: I am getting the current logged in user with @username. All documents have the entry @author.

So in my view I want to connect these two information. Like the following select statement (here for better understanding as SQL):

select documents from currentdb where @username = @author.

Is there any possibility to do that. Any links.

Thanks for any advice

Yuying zhang

Subject: @SetViewInfo

if the view is categorized take a look at @SetViewInfo

Subject: Using dynamic @formula view selections

Hi Yuying,I have seen this commonly done using embedded views. You can have a categorized view using @author, then create an embedded view with the @username formula in the Show Single Category value.

This can also be used to use environment variables if you have other information you wish to display and change on the fly.

Hope it helps