Answered

Where to control Advanced Filter "Add table join" permission

(0) Share

Report

Posted on by Community member

Hello everyone,

I'm trying to utilize the advanced filter to extract specific data, but the option to /+Add table join/ is currently inactive. Can anyone provide information on where to define the Role/Duty/Privilege to enable this feature on specific users?

Categories:

Administration and Setup

All responses (2)

Answers (1)

Verified answer

Hana Xue Microsoft Employee on at

Like (1)

Report

Where to control Advanced Filter "Add table join" permission

Hi,
The ability to add table joins in advanced filters is generally not directly controlled by specific roles, responsibilities, or permissions. You need to expand the selected table and click add table join.

In addition, this blog explains how to use advanced filters for your reference.
https://dynamics-tips.com/how-to-use-advanced-filter-d365-finance-and-operations/
Best Regards,
Hana
Suggested answer

André Arnaud de Cal... 290,246 Super User 2024 Season 2 on at

Like (1)

Report

Where to control Advanced Filter "Add table join" permission

Hi James,

Options for using this advanced query editor are part of the basic system user role. Is it still inactive when you select an actual table node, like Vendors? The selection is now on the main node where the buttons are disabled. You first need to select a particular table to be able to add another table join.