idea Filter Catalog EGDB FCs by owner in ArcGIS Pro Ideas

Filter Catalog EGDB FCs by owner

Bud — Wed, 12 Jun 2024 17:54:52 GMT

In Catalog:

It would be helpful if we could filter/show/hide enterprise geodatabase connection items (FCs, tables, views, relationship classes) by owner.

For example, if there are items from several owners (ROADS, WATER_RES, WATER), let me only see items from WATER.

My connection is OS Authentication (items from lots of owners), not a DB/owner-based connection (only one owner).

Oracle 10.7.1 EGDB

Re: Filter Catalog EGDB FCs by owner

sthorne — Wed, 19 Oct 2022 22:31:50 GMT

Hi Bud,

If you are using ArcGIS Desktop, you can accomplish this by going to Customize > ArcCatalog options... > check the "List only objects owned by the connecting user with enterprise geodatabases" checkbox.

For ArcGIS Pro, this option will be available with the upcoming release of version 3.1.

Hope this helps,

-Shawn

Re: Filter Catalog EGDB FCs by owner - Status changed to: In Product Plan

JonathanMurphy — Thu, 20 Oct 2022 15:55:34 GMT

Re: Filter Catalog EGDB FCs by owner

SSWoodward — Wed, 25 Jan 2023 21:03:55 GMT

Thank you for the idea!

In ArcGIS Pro 3.1, users will have the ability to see only objects owner by the connected database user. This option will be available in the Catalog Browsing page of the application options dialog. For more on this, and for other new additions from the geodatabase team in 3.1, check out our latest blog.

Link - What's new with Geodatabases in 3.1

Re: Filter Catalog EGDB FCs by owner - Status changed to: Implemented

AmeliaBradshaw — Fri, 10 Mar 2023 14:56:48 GMT

This Idea has been implemented in ArcGIS Pro 3.1. Please see the What's New documentation for more new features in Pro 3.1.

The Ideas in ArcGIS Pro 3.1 blog will be wrapped up soon, highlighting all Ideas implemented in this release, including this one. Once complete, I will add the link to this comment.

Re: Filter Catalog EGDB FCs by owner

EmmaVWKnowles — Fri, 08 Sep 2023 16:08:50 GMT

Hi, I think this is asking to be able to filter other people's data by owner? Not just view our own.
For example, all data published by Natural England.

Re: Filter Catalog EGDB FCs by owner

SSWoodward — Fri, 08 Sep 2023 19:18:43 GMT

Thanks for pointing this out. It looks like that's correct. Seems like this idea might need an amended status. While it IS true that users have new filtering functionality that matches ArcMap, this idea goes a step further.

@Bud , @EmmaVWKnowles

Where would you expect to find this functionality in the catalog? There is an existing filter option at the top of the catalog pane that allows you to filter by multiple criteria, but not ownership. Would you expect to find it here? Or somewhere else like a right-click option on a specific workspace?

Re: Filter Catalog EGDB FCs by owner

EmmaVWKnowles — Mon, 11 Sep 2023 09:00:49 GMT

Hi @SSWoodward, thanks for following up on this. I was looking for a "filter by owner" option in the dropdown list for the filter criteria box at the top of the catalog pane, as you say, so that is indeed where I would expect to find it.

I did subsequently discover that it is possible to filter by owner by typing "owner:" and then the owner's name. However, this is not obvious, I had to look it up; and also you have to get the username for the data owner exactly right, (for example, NE_opendata instead of Natural England), so a search box that can filter organisation names and tags would be more intuitive.

Re: Filter Catalog EGDB FCs by owner

Bud — Wed, 20 Sep 2023 17:48:56 GMT

@SSWoodward

Agree with @EmmaVWKnowles. I think this idea needs to be re-opened. Thanks.

Re: Filter Catalog EGDB FCs by owner

Bud — Thu, 18 Apr 2024 17:55:54 GMT

@SSWoodward Can this idea be reopened?

Re: Filter Catalog EGDB FCs by owner

MelissaJarman — Wed, 12 Jun 2024 12:48:59 GMT

@Bud - After re-reading this I believe there was a misundertanding of the larger scope of this request.

It was read as - I only want to see the datasets owned by the 'current' connected user in my database connection. You actually want a way to filter based on a user provided owner (this could be different than the current connected user even).

Do you want the filtering done based on the actual owner or the schema (because this can differ).

Re: Filter Catalog EGDB FCs by owner

Bud — Wed, 12 Jun 2024 13:10:02 GMT

@MelissaJarman I wasn't aware that the owner and schema could be different. Can you explain?

For Oracle EGDBs, I want to filter based on the item prefix. I’m not sure if you would consider the prefix to be the owner or the schema.

Re: Filter Catalog EGDB FCs by owner - Status changed to: Open

SSWoodward — Wed, 12 Jun 2024 17:05:05 GMT

Thank you very much to everyone involved in this Idea.

In ArcGIS Pro 3.1, the ability to filter the catalog for items owned by the connected user was implemented, making finding your own data in the catalog pane easier.

Since this idea is asking for a more specific feature, the ability to filter the connection by *any* owner, we will reopen it for support from the community. @EmmaVWKnowles, feel free to give this Idea a kudo now that its reopened.