Overview
Every Pretreatment table has two ways to narrow it down: a quick search on a single field, and an advanced filter for multi-condition queries. They work together — you can apply one on top of the other. This replaced an older search bar that expected query syntax. If you remember typing conditions into the bar itself, that is gone; the bar is now a plain text search, and the query building has moved behind an icon.
Before you begin
📝 Pick a field before you type. The search box stays disabled until you choose a field from the dropdown to its left — there is nothing to search until the table knows which column you mean.
Searching one field
Open the field dropdown to the left of the search box. It lists every column available on that table; the table's default search field is marked with an asterisk.
Choose the field you want to search.
Type your text in the search box and press Enter, or select the Search button.
To undo it, select the Clear search (✕) control at the right of the box.
Building an advanced filter
For anything more than one field, use the builder.
Select the Advanced Filter Builder icon beside the search box.
Build your conditions in the window that opens.
Select Apply Advanced Filter. The search runs and the window closes.
While an advanced filter is active, a badge on the icon shows how many conditions are in it, and a clear (✕) control appears beside the icon to remove them all.
Combining the two
The quick search and the advanced filter stack rather than replace each other:
Run a text search after an advanced filter, and it searches only the filtered rows.
Apply an advanced filter after a text search, and it filters only the searched rows.
So if a row you expect is missing, check whether both are active — the badge on the builder icon and the text in the search box each tell you.
Where this works
The same search bar and builder appear on the Pretreatment tables, including:
Industrial Users
Sampling Results
Permitting
Inspections
Nonconformances
Response
Users
Limits, on both the Outfall Overview and Permit Overview pages
General Controls, under Configurations → POTW
What happens next
Searches and filters only change what you are looking at — nothing is saved or altered on the records themselves. If you find yourself rebuilding the same filter often, you can keep it: see Saving Filters on Pretreatment Tables.
Video walkthrough
FAQ
Why can't I type in the search box?
No field is selected yet. The box is disabled until you pick one from the dropdown to its left.
What does the asterisk next to a field mean?
It marks that table's default search field.
I used to type my whole query into the search bar. Where did that go?
That bar expected a specific query syntax, and most people reasonably expected a plain text search instead. The bar is now a plain search, and query building moved into the Advanced Filter Builder behind the icon beside it — nothing was lost.
A row I expect is missing from the table. Why?
Check whether both a text search and an advanced filter are active — they combine, so a search runs only against rows the filter already allowed. The badge on the builder icon shows how many filter conditions are applied.
Which fields can I search?
Any column available on that table. The dropdown lists them by their column name.
Does searching change my data?
No. Search and filter only affect what the table displays.
Related articles
Saving Filters on Pretreatment Tables
Navigating an Industrial User Record