Report Filter gs.getUser() does not work on a condition of report filter

[mkm1]

I have a table  A which has a reference field KO  which is referencing to a extended table B which is an extended table of User (sys_user) table.

I am trying to create a report on Table A with filter condition as KO = gs.gertUser() which is not returning any value. I tried several ways to filter as below:

KO.Sys ID = gs.getUser().getD()

KO.Name = gs.getUser().getName()

Is there anyway to do it other than using ACL?

[Scott Jordheim]

Have you tried gs.getUserID()? That should be passing the sys_id of the current user. If you don't use it in a dynamic filter condition, you will have to do something like:

KO is javascript:gs.getUserID()

Even more ideally, you should be able to use the condition as such: KO is(dynamic) me.

[sachin_namjoshi · Accepted solution]

You have to use report filter like this

KO.Sys ID = javascript:gs.getUserID();

Regards,
Sachin