TOPIC:

Using Dropdown Filter on Bool is not working 21 Feb 2016 23:48 #13834

jonathanbell Topic Author Offline Premium Member Posts: 147 Thank you received: 5	When using the drop down filter for bool fields , it does not work. Regardless of selecting yes or no the list remains the same.
	Please Log in or Create an account to join the conversation.

Using Dropdown Filter on Bool is not working 07 Mar 2016 19:45 #13848

Romkabouter
Offline
Elite Member
Posts: 310
Thank you received: 131

In the plural model there is an error in this.
Somewhere above $this->applySqlStates($query); in the prepareQuery function you probably have:

		//WHERE - FILTER : SomeBool
		if($filter_somebool = $this->getState('filter.somebool'))
		{
			if ($filter_somebool !== null){
				$this->addWhere("a.somebool = " . (int)$filter_somebool);
			}
		}

that does not work, copy the prepareQuery function in a forked plural model file and change the filter for the boolean:

		//WHERE - FILTER : SomeBool
		if($this->getState('filter.somebool') !== null)
			$this->addWhere("a.somebool = " . (int)$this->getState('filter.somebool'));

Cheers

Please Log in or Create an account to join the conversation.

Using Dropdown Filter on Bool is not working 06 Apr 2016 18:51 #13877

admin Offline Administrator Chef Posts: 3711 Thank you received: 986	Fixed. Might be better now. Coding is now a piece of cake The following user(s) said Thank You: jonathanbell
	Please Log in or Create an account to join the conversation.