Saved views:- Filter view by current user

(0) Share

Report

Posted on by Kerry Moran

Is it possible to filter any list in D365 by the current user and then publish this as a saved view to all users. For example the All Sales orders view, can we filter the 'Sales Taker' column by the current logged in user eg "User A" and then publish. So if "User B" was to log in the list would be filtered by "User B":-

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

MelR 80 on at

Like (0)

Report
Copy link

Link copied!

It cannot be mass published, if the user goes in and filters themselves you can then save that view for that user individually - it would need to be done by "user A" and then "user B" etc.

Was this reply helpful? Yes No
Suggested answer

Ramit Paul 22,803 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi,

I don't have system right now.

Can you try with exporting the personalization and import the same to other user?

Was this reply helpful? Yes No
vinitgoyal2005 6,332 on at

Like (0)

Report
Copy link

Link copied!

[Deleted]

Was this reply helpful? Yes No
Suggested answer

Jake M 78 on at

Like (0)

Report
Copy link

Link copied!

Yes, you can do this! At least what I think you are trying to achieve.

Navigate to Options tab > Advanced filter or sort.

Add the Table: Worker, Field: Record-ID, Criteria: (HcmWorkerLookup::currentWorker())

You can then publish it for other users. The grid is then filtered to only show sales orders created by that user.

Was this reply helpful? Yes No
Kerry Moran 40 on at

Like (0)

Report
Copy link

Link copied!

perfect thank you. This worked and I was able to save it as a saved view and then publish it as a tile to users workspaces!

Was this reply helpful? Yes No
Holger Lamberti 95 on at

Like (0)

Report
Copy link

Link copied!

Hello Jake,

do you know if this would be possible with a method for the current user?

My use case is for Purchase Orders.

Thank you,

Holger

Was this reply helpful? Yes No
Suggested answer

GirishS 27,843 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Holger,

Try to use the function with close and open brackets like below.

(CurrentUserId())

Thanks,

Girish S.

Was this reply helpful? Yes No
Mohit Rampal 12,573 Moderator on at

Like (0)

Report
Copy link

Link copied!

(currentUserId()) is the correct syntax to use in Saved views.

1 people found this reply helpful.

Was this reply helpful? Yes No