Searching
📘 Merci Cloud ERP - Search Functionality Guide¶
In Merci Cloud ERP, users can filter data in Entry Modules and Reports using flexible search expressions. These expressions are entered in the top row of the grid (with pale yellow background).
🔍 Search Types & Syntax¶
| 🔢 Type of Search | 📝 Syntax | 🔍 Description | 📌 Example Matches |
|---|---|---|---|
| Any Value | RAM |
Finds rows where the column contains the value anywhere. Value can be left as space to enable search blank values | Siyaram, Radheshyam, Ramayan |
| Greater Than or Equal | >= value |
Filters rows where column value is greater than or equal to given value | >=100 → matches 100, 105, etc. |
| Less Than or Equal | <= value |
Filters rows where column value is less than or equal to given value | <=50 → matches 50, 40, etc. |
| Greater Than | > value |
Filters rows where column value is strictly greater than given value | >75 → matches 80, 90, etc. |
| Less Than | < value |
Filters rows where column value is strictly less than given value | <30 → matches 20, 25, etc. |
| Exact Match | = value |
Returns rows where the column is exactly equal to the given value | =500 → only matches 500 |
| Ends With | % value |
Matches rows where the column ends with the value | %ram → Siyaram, Mevaram |
| Starts With | value % |
Matches rows where the column starts with the value | Ram % → Ramayan, Ramdev |
📝 Notes¶
- You can enter these directly in the column headers.
- Case-insensitive for text fields.
- Works across both Entry Modules and Reports.
See Also: Configuration of Modules & Reports
💡 Pro Tip: Combine these searches across multiple columns to narrow down data efficiently.