LS on-prem asset filtering options

[CCal]

Hi, 

Im wondering, is there a guide on how to to advance filtering on LS on-prem.

For example:
I have a column with these potential values: 
engineering, structural engineering, design engineering, part engineering.

I want to filter just engineering, but when I type in engineering, i get all the rows instead of just the engineering rows.
I tried typing in "engineering" with the quotes, but it does not work.

[Jacob_H · Accepted solution]

oh dang - I did that when using 'Non-Active' and 'Active'  -  I will have to mess around with the filtering on the webpage as I'm not sure if there's some sort of way to do it, but you could always make a report of assets (inner join tblassetcustom on assetID) and say 'where tblassetcustom.custom4 (if its the fourth custom field) = 'Engineering'  and that will give you the results you need - then you can set deployment to run with the report as the target...   I'd give you the full report but I'm on my phone  -Jacob

[CCal]

Ok, thanks @Jacob_H  and @Katgroup ,
I will give it a try.

[Katgroup]

Yes! Filtering in the report is an option as well. Sometimes I find it's faster to search the columns for multiple searches rather than editing the report multiple times, just depends on my exact needs at the time.

[Katgroup]

If you have a report with those columns, you should be able to search after running the report.

[Mister_Nobody]

You can export to Excel and use filters into Excel.

[CCal]

But I am also actively editing the assets. I also want to run deploys to the filtered assets as well. 
Exporting back and forth seems tedious and won't work If I intend to deploy to the assets.