News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Are we still unable to...

Finance | Project Operations, Human Resources, ...

Answered

Are we still unable to filter grid column if the column is display only ?

(1) Share

Report

Report

Posted on by Teevo

362

Hi guys,

I know this is old question. But since the evolution of D365FO, may I know if I have Display method in a grid (list), how to filter it ?

Thanks.

All responses Img

All responses (5)

Answers Img

Answers (3)

Teevo 362 on at

Like (1)

Report

Are we still unable to filter grid column if the column is display only ?

Hi Layan/all,

I'm still unable to mark it, actually for all the thread.

Kindly help to mark all the answer ?

The issue solved as it is answered.

Thanks
Layan Jwei 7,347 Super User 2024 Season 2 on at

Like (0)

Report

Are we still unable to filter grid column if the column is display only ?

Hi Teevo,

If your question is answered then please verify the answers that helped.
Verified answer

Kevin Xia Microsoft Employee on at

Like (0)

Report

Are we still unable to filter grid column if the column is display only ?

Hi,

If a grid column has a Display method and is display only, it cannot be filtered directly through the grid's built-in filtering functionality. You can create a new column in the grid by adding a calculated or derived column based on the logic of the Display method, so you can use this new column to filter.

Best regards,

Kevin
Verified answer

Layan Jwei 7,347 Super User 2024 Season 2 on at

Like (0)

Report

Are we still unable to filter grid column if the column is display only ?

Hi Teevo,

You can't filter a display method. You need to convert it to an actual field if possible (in case filtering is really needed)

Thanks,
Layan Jweihan
Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future
Verified answer

Anthony Blake 2,181 Super User 2024 Season 2 on at

Like (0)

Report

Are we still unable to filter grid column if the column is display only ?

Yes correct - a display only field will have a method behind it, rather than showing you the contents of a field in a table, view, or query. Therefore sorting isn't possible,

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans