Multiple where() condition doesn't work about sleekdb HOT 8 CLOSED

Nice one mate 👍
Dzieki Lukasz 🥇

from sleekdb.

Got the same issue! The bug came with the lastest release 1.5.0. Unfortunately 1.0.3 is missing some new features :(

from sleekdb.

@lukasznowicki thanks for the contribution, appreciate that you take the time and to fix the issue. I will merge your PR today!

from sleekdb.

@lukasznowicki Didn't worked for me. I copied your src/traits/helpers.php but the bug is still there (
UPDATE:

$tasksArr = $tasksStore
                ->where('done', '=', false)
                ->where('assigned', '=', $workerId)
                ->where('done', '=', false)
                ->fetch();

Actually this worked. If I use ->where('done', '=', false) one time, the first one is ignored

from sleekdb.

@snoopy4ever @typomedia @rakibtg Guys, here is the solution for this problem - #23

I also forked (to create PR) this repository and merged that fix - https://github.com/lukasznowicki/SleekDB

from sleekdb.

@lukasznowicki thanks for the contribution, appreciate that you take the time and to fix the issue. I will merge your PR today!

So where is the merge?! This has to be a hotfix

from sleekdb.

@snoopy4ever I think you should use orWhere like this:

$news = $newsStore
        ->orderBy( 'asc', 'order' )
        ->where( 'startDate', '<', time() )
        ->orWhere( 'endDate', '>', time() )
        ->fetch();

from sleekdb.

I will close the issue here, feel free to post a comment and re-open it.

from sleekdb.