nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

ArcGIS Pro 2.6.3 Definition Query

Jurogin

Hi All,

I'm trying to make one basic Definition Query like "OBJECTID = 1" using one layer from one enterprise geodatabase (Oracle) and i'm receiving one error message "There was an error with the expression", but if I make the same query using the "Select By Attributes" the selection is done without problems.

So someone have ideas to solve my problem?

PS: Using the previous versions of ArcGIS Pro I was able to make query on the same layers.

Thanks,

Vítor Carvalho

capture1.PNG

Find more posts tagged with

Desktop

Accepted answers

All comments

Robert LeClair

Good morning - good news! ArcGIS Pro 2.7 was released a little more than a week ago. You can upgrade at any time and test the workflow again.

KatharinaWerner1

Hello Robert,

thanks for your answer. No we haven't already upgrated ArcGIS Pro. I'll try
the same workflow, when 2.7.x is released and let you know, if the problem
has resolved or not.

Robert LeClair

Kathi - interesting - thx for the response. I wonder - have you upgraded to ArcGIS Pro 2.7 and attempt the same workflow again? Not sure if it's a bug in ArcGIS Pro or not, but there were a lot of bugs resolved in the latest update.

KatharinaWerner1

Hello, we've have the same problem.

We get this errormessage, when we use the SQL option. When we use the not-SQL option ArcGIS Pro crashes. But after some tries with not-SQL-option ArcGIS Pro crashes also. There isn't any systemic errorbehavior. I've created a case at Esri Support Germany. But we couldn't find the cause of the crash nor couldn't resolve the problem. I guess there's a bug in ArcGIS Pro. We'll see in the case, if there is a solution.

Happy new year,

Kathi

Robert LeClair

Is the error occurring in the Layer Properties->Definition Query? If so, click the SQL slider in the Layer Properties->Definition Query and type OBJECTID=1 without the quotes. Click Apply followed by OK. Does it process correctly?

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.