Database Query AND operation

Discussion Ask a question
,
1

I want to query database query on the condition like
DBcolumn1 = abcd and DBcolumn2= 123 . i can easily use eq() , Or() function .
But how to to AND operation directly.

currently doing separable after pulling the data from one query and then performing the other search . is there any direct AND function present like eq() .Or()?

2

Chaining the methods will create an AND operation, for example: eq(…).eq(…).gt(…)
You can read more about working with the data API here:

3

Also, see this thread: https://www.wix.com/code/home/forum/questions-answers/chaining-two-or-more-eq-in-setfilter