Same column reference from multiple field filters

Hi All,
is it possible to give same column reference to multiple field filters used on a table.
I am having 2 different columns(‘Listing’ and ‘Bidder’) but both refer to same column(‘company’) . I want to add field filter on both columns (‘Listing’ and ‘Bidder’) but m not able to, bidder filter is working fine but every time m applying filter on ‘Listing’ the filter gets applied to bidder column instead.

Hi @prashantpnd07
Without seeing your query or knowing which database you’re querying, then it’s difficult to know.
But I would recommend that you read this:

This is a standard SQL problem where a table has multiple uses. Create views - one for listing, the other for bidder. Use those instead of the original table.

1 Like