I have created one script which set a defination query at certain location in script.
I use lyr.definitionquery = "some expression"
After running the script i want to remove the definition query . But not getting any hint to do it.
[GIS] Removing definition query in ArcPy
arcpydefinition-query
Related Solutions
Your current expression is looking for dates that are 7 days or more than the current date.
Try:
ExprDate <= (CURRENT_DATE + 7) AND ExprDate >= CURRENT_DATE
EDIT
As mentioned, the above only works in some database environments. I ran into an issue implementing the above solution for data that was stored in a SQL database. Below is the Definition Query I used to get the last 30 days of data:
DATEDIFF(d, FIXED_DATE , GETDATE()) <= 30 AND NOT FIXED_DATE > GETDATE()
If you have the unique IDs in an Excel file, you can join this file to your points feature class and then query on the joined file. See Esri's information on joining Excel files to feature classes.
Say that your feature class has a field IdRPL, and your Excel file has IDs in a field called UniqueID.
- Right-click on your feature class and choose Joins and Relates/ Join...
- Choose Join attributes from a table
- Choose the field in this layer that the join will be based on: IdRPL
- Choose the table to join to this layer: (select your Excel file)
- Choose the field in the table to base the join on: UniqueID (or whatever column name you used in Excel)
- Join Options: Keep only matching records
In the sample below, the "matching records" would be only those five records that don't show 'null' in the Excel file. The three null records do not exist in Excel, so they will not display in the layer.
Best Answer
Just clear that property:
Noneis the python forNULL, so making it = None will clear the query.