Filter Document without using section access

[#1]

Hi, it it possible to filter a document using the osuser() with a corresponding document ID?

eg,

I have the following lookup table :

OSUser()	DocumentUserID
mydomain/user1	smith
mydomain/user2	jones
mydomain/user3	evans
mydomain/user4	thomas
mydomain/user5	rees
mydomain/user6	hunt

In my document dataset I also have the DocumentUserID field.

Is it possible to set the DocumentUserID field depending on the value of the OSUser()??

many thanks,

Tom

[alexandros17]

Yes but it is not as safe as section access.

[#3]

Thanks for your reply.

I understand that - but I need to give the user the option of seeing all the data if required after the document is initially filtered on opening.

Do you know how to achieve this?

[#4]

Assuming you have OSUSER field in your document.

Document Properties -> Triggers -> Document Event Triggers -> OnOpen -> Add Action(s) -> Add -> Selection -> Select in Field -> OK -> OSUSER as Field -> =OSUser() as Search String

Regards,

KKR

[alexandros17]

if you need to filter data by user then test if  Osuser() match with your user into your chart or your sheet.

I shuld need more details to help ypu more