I want to implement global search functionality in which user can select multiple attributes their search value and join these multiple attribute using AND or OR operator (providing dropdown). For Above task I think it’s best to use direct OQL query using OQL module provided by mendix. but to create a string (OQL query) how can I compare ENUM values? using WHERE for e.g., SELECT name, other from module.attribute = ‘Mendix’ WHERE category = ‘’A’’ ‘ AND type = _______(what to use here for ENUM comparison)? And Also please provide best way to provide global search with multiple attributes to operator choice(Contains and equal) and join these condition option(using Dropdown AND or OR).
You can try Global Search module available in Marketplace.