Update your settings

Filtering Duplicates in COMOS Queries

Yes, you can filter out duplicates in COMOS queries without using grouping. The key is to utilize a combination of query properties and potentially a calculated property.

Here's how you can achieve this:

1. Identify the Column: Determine the column where you want to remove duplicates (e.g., 'Item Code', 'Description').
2. Use a "Distinct" Filter: In the query filter settings, select the column. Choose the operator "is one of" or similar, and then use the function DISTINCT within the value field. This will only return unique values for that column.
3. Calculated Property (If Needed): If a direct "DISTINCT" option isn't available for your column type, you might need to create a calculated property that concatenates relevant fields and then apply the "DISTINCT" filter to the calculated property.

Grouping, as you noted, can limit the displayed information. Using the "DISTINCT" filter directly addresses the duplicate removal without altering the overall query results.

For detailed guidance and examples, please refer to the SiePortal documentation: COMOS Queries - Handling Duplicates (SiePortal)