Issue:
====
We see there are few filters are not working while searching based on Lookup Fields. But those filters are working fine in Text Fields. Please find the below screenshot for reference.
Repro:
======
-Login to affected environment
-Go to Sustainability manager app
-Go to All emissions view
-We see there are few filters are not working while searching based on Lookup Fields. But those filters are working fine in Text Fields. Please find the below screenshot for reference.
1. Search Data in Text Field :
Search Result : Working as expected.
2. Search Data Lookup Fields:
Search Result : Not Working as expected
Lookup Fields
We faced the below,
Working Filters -> Equals, Does not Equal.
Not Working Filters
-> Contains, Does not contains, Begins With, Ends With, Does not Begin With, Does not End With.
As per PG team this is the product limitation however users wants to have these filters on Elastic table.
Comments
Second this, indeed has impact on user experience as it is not intuitive.
Category: Microsoft Sustainability Manager
I totally agree on this. Everybody who is using other model driven apps naturally tries to filter like they are used to. Especially the "contains data" or "Begins with" would be super helpful because it gives a wider range of flexibility when setting up the calculation.Also the user interface makes you believe that you can filter whatever you want because it is looking exactly like the advanced filtering from the model driven app tables. The only reference that you cannot do that is in the official microsoft documentation.If it's not possible to change that at least a visual hint for the users would be nice - or a check before the calculation is saved. I found out that I can set the filter to "not allowed" values, and then run the pcf calculation without any issue but I don't get data out of the calculation, which I only can see after the calculation is finished. This is not a good user experience :(
Category: Microsoft Sustainability Manager
Sustainability Feedback (administrator)
Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future. Best regards, Business Central Team