Use arcpy and check each row of the table using da.SearchCursor and list ObjectIDs of the rows matching your condition. Then select using the list. Adjust and execute in python window:
layer = 'somelayeraddedtothemap' #Change
field_to_check = 'somefield' #Change
oidfield = arcpy.Describe(layer).OIDFieldName #What is the oid fieldname
Thanks for the demonstration.
Just wanted to offer my experience:
For option 2 above the Get_Municipality_List and Get_County_List functions can be defined within the validator script file (outside and prior to the ToolValidator class definition worked for me). You still need to set the parameter filter value to 'value list' as shown in option 1 above.
You can't load those layers in ArcGIS.
The "layers" are provided as a Web Map Service,
meaning you only get the image of where the data is located and the actual vector data which is available for purchase in SOI's (Mapi) website.
You can try and ask someone there if the data is available trhough WMS/WFS as well, which will enable you to open the layer as ...
In my case, the ESRI representative technician reinstalled the portal due some problems, what fits with CCantey answer based on that tech article. Anyway, I'm not on the mood of reinstalling ArcGIS Desktop or search for another solution, so I present a not elegant solution:
Change the "Database Connections/some.sde" for 'C:\Users\your_user\AppData\Roaming\...
I know it's an old question, but I'll leave this here for anyone who stumbles across this looking for help. Using arcpy.Frequency_analysis() quickly puts all the unique values from a field into a new table, which you can then use for cursor operations. One single command to do what all these other solutions do and faster and easier. As a bonus, you also ...
1) is just the value itself and 2) is just the stats/histogram break down into 100 bins. You can do this any number of ways (ex. use the classifier in the symbology tab>Quantities>Graduated colors).
So it sounds like #3 is really the heart of your question. A word of warning, this method will create a lot of files, so it would be helpful to build in a ...
It seems the answer is very simple. Run the script outside the active map document and use mxd.save() after setting the definition query:
import arcpy, os, re
from arcpy import env
inmxd = r'C:\Temp\Tenure_Shire Notification.mxd'
tenID = 'E40/01300'
env.workspace = os.path.dirname(inmxd)
mxd = arcpy.mapping.MapDocument(inmxd)
df = arcpy.mapping....