Select by Attributes in attribute table of database view

Bud

ArcGIS Pro 3.2.1; mobile geodatabase and file geodatabase

 

Background (works):

In an Oracle 18c 10.7.1 EGDB, I have a database view:

--species_records_latest_no_ties_vw
select
    s.*
from
    species_records s
inner join
    (
    select
        min(objectid) as objectid,
        min(t_unique_id) as t_unique_id,
        t_species,
        max(t_date) as t_date
    from
        (select
            s.*
        from
            species_records s
        inner join
            (select
                t_species,
                max(t_date) as t_date 
            from
                species_records 
            group by
                t_species) l
            on s.t_species = l.t_species 
               and s.t_date = l.t_date
        )
    group by
        t_species
    ) l
    on s.t_unique_id = l.t_unique_id

When I add the database view to the map and open the attribute table, I can use Select By Attributes without issue.

 

Idea:

Could Select By Attributes functionality be added for mobile and file geodatabase views too?

 

species_records.xlsx

AlfredBaldenweck_3-1731519143823.png

Bud

Mobile Geodatabase:

I have the same table and the exact same database view as the Oracle view above in a mobile geodatabase. However, the Select By Attributes button is greyed out in the attribute table.

 

File Geodatabase:

I have the same table and near-identical database view in a file geodatabase. The only difference in the SQL is a slight difference in the field aliases. Reason: FGDB views seem to prefer slightly different syntax when it comes to those aliases.

select
    *
from
    species_records s
inner join
    (
    select
        min(objectid) as objectid,
        min(t_unique_id) as t_unique_id,
        t_species,
        max(t_date) as t_date
    from
        (select
            *
        from
            species_records
        inner join
            (select
                t_species,
                max(t_date) as t_date 
            from
                species_records 
            group by
                t_species) l
            on species_records.t_species = l.t_species 
               and species_records.t_date = l.t_date
        )
    group by
        t_species
    ) l
    on s.t_unique_id = l.t_unique_id

The Select By Attributes button is available, but it throws an error.

ERROR 000358: Invalid expression

 

Could Select By Attributes functionality be added for mobile and file geodatabase views too?