There is a video blog on the Mendix website on how to implement a full text search using ElasticSearch. I think this may have the answers you need.
https://www.mendix.com/videos/how-to-build-full-text-search-capabilities-into-your-mendix-app-with-elasticsearch/
Good luck!
Hi Malay,
you can try Global search module where you cansearch through multiple entities and attributes
https://marketplace.mendix.com/link/component/115019
Hope it helps!!!