hi,

the column data set to foreign key, is unable to search.

all search result return is nothing.

Hi Milo,

Please see the image attach this is our original setting. The SQL query is correct, no error.

2nd attach: table look like this. Country is foreign key.

3rd attach show the foreign key setting.

4th attach show nothing filter.

I had purchased twice the advance filter plugin; I was thinking can solve with upgrade but still the same after 5 years.

Still have others bugs such as fix heading and row, I will create separate ticket.

Hope you could help to review more detail. Thanks.