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.