Is there any widgets or module for Advanced search which can accommodate And and Or operators in the search operation in the single go ?

Hello Folks, I am looking for widget or module where that supports the “AND” & ”OR” operator in the search operations.   Lets say that the user wants to search something in the data table in the page by querying multiple keywords by separating them by “AND” or “OR” operators, which will compare the records in the combination of multiple keywords and render those in the data table. FYI, I have already explored GridSearch widget, which only supports “OR” operator. Lemme know if there are any such module/widget which supports both “AND” & “OR”.   Thanks in Advance!!
1 answers

Hi, it might be a bit too much, but you could look to the OQL module, where you can build up full query’s to fire at the database.