Navigation · Beginner

Use Advanced Search and Filters in ManWinWin

Learn to combine column filters and search text in ManWinWin Web to narrow down maintenance records. Refine the criteria, check the results, and remove restrictions when you finish.

Efficiently locating specific maintenance records within a CMMS is crucial for operational responsiveness and data analysis. ManWinWin Web offers powerful advanced search and filtering capabilities to help users quickly narrow down extensive lists of work orders, requests, or material records. Mastering these features streamlines your workflow and ensures you access the right information precisely when needed.

Where it's available and step by step

Step by step in ManWinWin Web

1
Open Works for work orders, Requests for maintenance requests, or Materials for material records, according to your search objective.
2
Check the search box and column filters for existing restrictions before adding new criteria.
3
Open the arrow of a column relevant to your search and set a filter using the options available for that column.
4
Open a second relevant column’s arrow and set another filter, keeping the first condition in place.
5
Enter search text in the list’s search box if you need to narrow the filtered results further.
6
Review the resulting records against your intended conditions; if the list is empty or too restrictive, remove the search text or relax one column filter at a time.
7
Refine one condition at a time and review the results after each change to identify which restriction affects the records shown.
8
Remove the filters you set and clear the search box to return to the list without those search restrictions.

Theory and technical background

The Importance of Effective Data Retrieval in CMMS

In maintenance management, quick and accurate access to information is paramount. CMMS databases often contain thousands of records, from work orders and asset histories to spare parts and supplier data. Effective data retrieval, facilitated by robust search and filtering tools, enables faster decision-making, reduces asset downtime, and improves overall maintenance efficiency. It supports performance analysis by allowing users to pinpoint specific data points relevant to KPIs like MTBF or MTTR, ultimately contributing to better asset reliability and cost control. Without these tools, valuable data can become effectively 'lost' within the system.

Leveraging Column Filters for Structured Data Search

Column filters provide a structured way to narrow down data based on specific attributes in a table. Instead of a free-text search across all fields, column filters target individual data points like 'Status', 'Priority', 'Assigned Technician', or 'Asset Type'. This precision is essential for effective data segmentation, aligning with principles of data organization found in standards like ISO 14224 for data collection. By applying multiple column filters, users can create complex queries that precisely match desired criteria, making the dataset manageable and focused for analysis or action. This method is superior for structured data than broad text searches alone.

Combining Search Text and Filters for Granular Control

While column filters excel at structured data, a global search box allows for free-text queries across multiple fields, useful for finding keywords, codes, or descriptions. Combining column filters with search box text offers the most granular control over record retrieval. For instance, you might filter for all 'Open' work orders assigned to 'Technician A' and then search for 'bearing replacement' within that subset. This multi-layered approach ensures that even in vast databases, users can pinpoint exact records. Best practice dictates a systematic approach: start broad, apply specific filters, then use search text if needed, refining step-by-step to avoid over-restriction.

Best practices

Always check for existing filters or search text before starting a new search.
Apply column filters for structured data first, then use the global search box for keywords.
If results are too narrow or empty, relax one condition at a time to identify the problematic filter.
Clear all filters and search text immediately after finishing your task to prevent future confusion.

Frequently asked questions

Why use advanced search instead of just scrolling through lists?

Advanced search and filters save significant time and ensure accuracy, especially in large databases. They allow you to quickly pinpoint specific records, enhancing operational efficiency and data analysis for KPIs like availability.

Can I combine multiple column filters at once?

Yes, you can apply multiple column filters simultaneously. Each subsequent filter further refines the results based on the combined criteria, allowing for highly specific data segmentation relevant to asset criticality or maintenance type.

What's the best strategy if my search returns no results?

If your search yields no results, begin by removing the most recent restriction you added, such as the search text or the last column filter. Re-evaluate your criteria and relax conditions one by one until relevant records appear.

Need help with this topic?

Back to Winston Help Center

Ask Winston or explore other lessons.

Winston Help Center