Cursor filter in custom field doesn t work

-- HikaShop version -- : 2.3.2
-- Joomla version -- : 2.5.24
-- PHP version -- : 5.3.29

Hi!
I tried to create a filter cursor on a custom field which is a checkbox.

It is a date with mupltiple choices like 1999,2000,2001 (example)

i checked with field too. But the same.
What I need to do is to display a between filter but I can t find another way

I tested with fields too.

Hello,

As Jerome said your filter is based on a custom field values from 1980 to 2014 ("cursor maximum/minimum values") If you want to use it with your checkbox custom fields, you'll have to :
- Use it with values from 1 to 35
OR
- Set the values of your custom field as their titles from 1980 to 2014.

I tested with fields too.

It was checkbox and I made it field.
I wrote in the field 2000
I filtered with the cursor 1980 to 1981 and it still brings up the item

Can you give me a temporary back-end access through a private message so that I can directly test it and tell you from where your issue is coming from ?
Thanks.

ok. I ll pm you

Did you removed the "Xpovo.." filter and custom field ? if not can you please give me then name of the filter and custom field.
Thanks .

NAME OF FILTER IS Xρονολογία With columnname xronologia and id 2
FILTER NAME IS Xρονολογία apply on xronologia and id 3

I thing I gave you wrong site to see it. thats why you can t find it . I ll pm again with the correct sorry

Hello,
Cursor filters are not supposed to support "checkbox" custom fields, so the "solution" will be to directly use some code customization which will require some development skills.

To do that you can use that code through the "administrator\components\com_hikashop\classes\filter.php" file :

for($i = (int)$values[0]; $i <= (int)$values[1]; $i++){
      $limit .=' OR b.'.$filter->filter_data.' LIKE "%'.$i.'%" ';
}

}else{
	$limit=' b.'.$filter->filter_data.' BETWEEN '.(int)$values[0].' AND '.(int)$values[1].' ';

Thanks for the reply Mohamed, but can you be a little more specifiq?
a.What would be the result of adding such code?

b. is this result combined with cursor filter or should I use some other ?

c. this is a new type in filters ?

Thanks for your time.

cursor still doesnt work with these modification.

Hi,

To summarize you problem, now for the checkboxes the values are years too and not values from 1 to 35, right ?
When using the cursor on years it display products even if they are not in the correct range ?

As Jérome and Mohamed said cursors are not really made to be used like that, it must be applied on one value and not many as it can be the case with the checkboxes.

Mohamed gave you some code which should be working fine, if it's not that's potentially because of the "BETWEEN" part of the MySQL request. So you have to remove it and only use the "LIKE" part.

Thanks to try that instead:

}else{
	//$limit=' b.'.$filter->filter_data.' BETWEEN '.(int)$values[0].' AND '.(int)$values[1].' ';
	$limit = '';
	for($i = (int)$values[0]; $i <= (int)$values[1]; $i++){
		if($i != (int)$values[0])
			$limit .= ' OR';
		$limit .=' b.'.$filter->filter_data.' LIKE "%'.$i.'%" ';
	}

Hi Xavier.
Yes values are years too.
Yes it displays every product
But.
I dont care if I use cursor or something else.
I only need to use some how a filter RANGE or BETWEEN .

I did that too so my code looks like.

you answer coverd me.
I ll be waiting for such function, and I believe most of your clients would think it as natural -- to have the ability to filter a range between fileds.
The truth is that most free component have this as a buildin function, but the balance still goes on hikashop even if it is a paid component in my case , because of its great support and really few bugs.

Thanks!