I am having issues with being able to filter by certain fields.
I have a few thousand projects mapped with varied attributes and I am trying to filter by the project number in bulk.
Essentially, out of 4000 projects I only want to view around 600 and the project number is listed in the attributes and I can apply a filter to the data but i would need to do this one by one. I am trying to find a way I can apply this in bulk and easily in Portal.
I have been able to successfully filter the projects in ArcMap using SQL but I don't have the option in Portal.
I came across custom expressions and I was wondering if there would be a way to use this in a similar manner? I have not had much success with the custom expressions with also keeping the existing Polygon for the projects.
Thanks in advance.