I can use item(user list) to get current user, i.e. the user who login current system, it requires to use user list as dimension. Now I have a module which is not dimensioned user list, is it possible to retrieve current user directly without adding user list as dimension?
@kevin.cho Thanks for your reply Kevin. I'd like to customize a dashboard, so that it will dynamically display the module for each specific user. Those users have access to the list related to the module, but that's not enough, we have to embed another condition to restrict their access. I need to get 'current user' in order to bundle the current user with the condition.
@kevin.cho Thanks Kevin. More exactly, the condition I tried to set is current user = the approver, 'the approver' is a line item in that module, it's not dimensioned as user list. I need to build a Boolean to get TRUE/FALSE for 'current user = the approver', then use the Boolean as filter on that dashboard. Merely current user won't be enough. The painpoint is that the Boolean doesn't work if I don't use user list as dimension. I'm stuck here...I also tried to apply user list as a dimension and build a subsidiary view for the Boolean line item, on the dashboard filter, it will not appear current user/current page, instead it will take the exact user/current page...
@kevin.cho Hi Kevin, since the Filter is dimensioned against user, the problem is when I tried to apply the Filter on dashboard, it can only filter the exact user, instead of 'current user', kindly find below yellow highlighted part. I think it's difficult to apply this kind of filter if my module doesn't use User as dimension...
Oh I see! Okay, so you have been using the non-system Users list, i.e. a "Fake" users list (similar to Fake Time).
The system Users list has this special behaviour that allows the filter to still be applied; your situation is akin to using just a default type of list, which yes does need the dimension being applied.
You can potentially still do this however by creating two line items; one against the Users list formatted with "User List", and then another boolean formatted which you apply as a filter. If there is a mapping between the System "Users" list and your non-System "User List", create a line item that returns the item from the System "Users" list.
If Approved By is the name of the line item formatted by "User List", then you can do something like below (assuming names of the items in "User List" are email addresses that correspond to the system User list) Mapped User = FINDITEM(Users, NAME(Approved By))
You can then do everything as previous, but now referencing this "Mapped User" line item.
Is there a reason why you use your own "User List" rather than "Users"?
@kevin.cho Thanks a lot Kevin for your suggestions. I'm able to solve the problem now. The reason that we use fake user list is because the business requires to write data into user list and save the data, system Users list can't achieve the expected result so we had to build a dummy list for users.