Multiple Where clauses not working?

[imangazalievm]

Multiple Where clauses not working?

[ImangazalievM]

1. This sample is not correct:

List<Note> notes = Select.from(Note.class).execute();

I removed it from the documentation.

2. ReActiveAndroid has a different syntax for building SELECT queries with `WHERE' clause. The sample in the documentation was incorrect and I fixed it. The correct version of the query:

Note note = Select.from(Note.class).where("id=? AND title LIKE '?%'", 1, "Hello").fetchSingle();

Thanks for your report!

[bhapps]

There is still an issue where I wish to return all (or paginated) data filtered by the query using fetch() which returns the error of Cannot bind argument at index 2 because the index is out of range. The statement has 1 parameters

All the documentation advises only of using fetchSingle() when using multiple Where clauses
I wish not to return only the first hit, but all (or some) data items.

Maybe fetch() has not been implemented for using multiple Where clauses

[cviacmob]

How to use single column to get multiple value based on filter , given below code error . kindly solve this query
Select.from(SeasonMasterDB.class).where("state LIKE '%" + "current_season" +"old_season"+ "%'").fetchSingle();