Available Values for a Query Layer Subset Selection

[MichaelVolz]

I have brought an Oracle spatially enabled query layer into Pro 2.1.3 and performed a query on the data to get a subset.  Now when I try to create a selection from the subset of values I am presented with all the unique values from the original datasource and not just from the previously selected records.  This does not seem correct to me as it is retrieving all values from the database instead of just values from the selected records.  Has anyone seen this type of behavior before when using a query layer in Pro 2.x?

[RexRobichaux2]

Hello Michael, 

 Thanks for bringing this behavior in Pro to light. Would it be possible for you to share a simple / sample query layer syntax with an example subset selection that I could test this out with? Also- does the same query layer and selection subset function as expected in ArcMap? Thanks in advance!

Best-

Rex 

Geodatabase‌ Managing Data‌