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()?
Chaining the methods will create an AND operation, for example: eq(...).eq(...).gt(...)
You can read more about working with the data API here:
https://support.wix.com/en/article/working-with-the-data-api
Also, see this thread: https://www.wix.com/code/home/forum/questions-answers/chaining-two-or-more-eq-in-setfilter