Find items with one field OR another

fabiojordan

Hi there.

So. I want to make JA K2 Filter work in a way it can filter items by one field or another.

Right now, I'm trying to filter items by date, but some are using one field and others are using other fields.

https://www.cafecomfilme.com.br/filmes-na-tv?xf_82=2019-06-26&xf_83=2019-06-26&xf_85=2019-06-26&xf_86=2019-06-26&xf_87=2019-06-26

As you can see in this URL, I'm trying to filter them by the same date (today). As of today, there's only one item with that date and it's an item that has the Extra Field 82 with that date. If I change my URL and delete all of the other Extra Fields, the Search works and show the item. BUT, sometimes, I may have one field with that date and other item with Extra Field 83 or 85, so I need JA K2 Filter to show me all of those items.

Previously, I was using a hack (that someone of Joomlart team provided me) in the itemlist.php file.

I was using a second array with the code "$where2 = array();" an aditional line for SQL ($sql .= empty($where2) ? '' : ' AND (' . implode(' AND ', $where2).' )'😉 and some tricks in the "case 'range':".

Problem is... in the last updates, this hack isn't working anymore. Any other way to do this?

Hope you can help me!

Thanks in advance!

saguaros

fabiojordan
Hi,

Correct me if I'm wrong that

-you have item A with Extra Field 82
-item B with Extra Fields: 82, 83, 85

When you search with credential that matches the Extra Field 82 and you want to show both items: A & B

is that right?

fabiojordan

saguaros

Something like that. Let's suppose we're talkinh about 5 different items. Each one matches differents extra fields, but with the same date so:

Item A: matches 06/26/2019 in Extra Field 82
Item B: matches 06/26/2019 in Extra Field 83
Item C: matches 06/26/2019 in Extra Field 85
Item D: matches 06/26/2019 in Extra Field 86
Item E: matches 06/26/2019 in Extra Field 87

So, in the URL, all 5 items should appear, since the filter should show any items that match any parameters. Do you get it?

saguaros

fabiojordan
Kindly share the credentials of your site and screenshot highlighting the items you're referring to as I'm not familiar with the native language on your site.