We have requirement for a search screen with nearly 20 fields. I am not very familiar with the Elastic search capabilities.
Is it a good option to implement elastic search for this requirement? The OOTB elastic search is having one search field that will search through the entire BLOB for the case types.
We want to have 20 search fields but internally we want to use the elastic search. If they enter a value in one of the search fields, the search should be restricted to only that property and not on the complete BLOB.
Please advise if elastic search is a good option or it is better to create a separate search table with search fields exposed
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
In our application we are also using the custom search ,we have separate search harness we will be showing 5 fields in the search harness .As per our requirement i need to use a Boolean Operator "AND" for serving my requirement.
Example:DB column A has a value "COCA COLA GULF" and COCA COLA TURKEY and when user inputs a search value for A as "COCA GULF" then it should return only the values which has both the Words in our example it should return only "COCA COLA GULF"
For my requirement ,Using a lucene search sytax of boolean "AND" but am not sure how to form a query using the syntax it could be very helpful if you can explain how to form a alternative search query using lucene syntax.